[Feature] Test Case Performance Monitoring in UI

[chillerno1]

Is your feature request related to a problem? Please describe.
We’ve noticed a recurring issue where long-running test cases are causing bottlenecks by queuing up when executed simultaneously. Currently, our visibility into test execution times is limited to the entire test suite through the DAG, making it tough to pinpoint the individual culprits. This lack of detail makes it hard for us to provide the business with actionable insights into problematic test cases and overall test performance.

Challenges:

1. We cannot monitor the execution times of individual tests.
2. Identifying and addressing problematic test suites is difficult because there are limited insights and visualisations.

Describe the solution you'd like
We believe adding a feature to display the execution time of each test case on a historical graph, akin to how test results are currently visualized in the OpenMetadata UI, would be incredibly beneficial. This enhanced visibility would help us spot and address performance issues more efficiently.

Describe alternatives you've considered
We have considered alternatives such as using systems external to OpenMetadata to inform users, however having this available through the OpenMetadata interface would allow everything to be in one place.

Additional context
Add any other context or screenshots about the feature request here.

[TeddyCr]

We’ve noticed a recurring issue where long-running test cases are causing bottlenecks by queuing up when executed simultaneously.

@chillerno1 are you referring to native OM test cases?

[chillerno1]

@TeddyCr yes native OM test cases and Custom SQL test cases.