Model Performance Testing Alerts

[jelstongreen]

Is your feature request related to a problem? Please describe. When designing larger tables they can be performant at first but over time can become unwieldy to use as an end analyst if they are not optimised correctly.

Describe the solution you'd like I would like the capability to monitor query performance on specified tables over time - things like Selecting single rows from large table filtering on an ID or realistically, any query I want to test over time.

Describe alternatives you've considered I could write my own dbt models for unit testing and analyse those model run times using elementary but this doesn't provide the alerting functionality and involves a lot more code writing than a test.

Additional context

Would you be willing to contribute this feature? Yes I could give it a go.