Which component(s) does this affect?
Problem Statement
The Query Stats tab groups by query_hash and aggregates all metrics, but does not include any date/time columns in the output. The underlying v_query_stats view has collection_time, last_execution_time, and creation_time, but these are lost in the GROUP BY.
This makes it impossible to know when a query was last executed or when it was first cached without drilling down to the history window.
Proposed Solution
Add to the Query Stats SQL and model:
MAX(last_execution_time) AS last_execution_timeMAX(creation_time) AS creation_time (cached time)
Add corresponding columns to the DataGrid in both Dashboard and Lite.
The drill-down history window should also include these columns if it doesn't already.
Which component(s) does this affect?
Problem Statement
The Query Stats tab groups by
query_hashand aggregates all metrics, but does not include any date/time columns in the output. The underlyingv_query_statsview hascollection_time,last_execution_time, andcreation_time, but these are lost in the GROUP BY.This makes it impossible to know when a query was last executed or when it was first cached without drilling down to the history window.
Proposed Solution
Add to the Query Stats SQL and model:
MAX(last_execution_time) AS last_execution_timeMAX(creation_time) AS creation_time(cached time)Add corresponding columns to the DataGrid in both Dashboard and Lite.
The drill-down history window should also include these columns if it doesn't already.