Warehouse p9x metrics and cache usage
- Date
- Ian WhitestoneCo-founder & CEO of SELECT
To help with monitoring performance and understanding the impact of warehouse or query changes, we’ve added three new capabilities to the warehouse performance tab.
Monitor a larger variety of aggregation types (avg, p50 through p99) across any metric.
![SELECT warehouse performance change metric](https://storage.googleapis.com/prod_select_images/changelog/slice_by_metric_20230501.gif)
Analyze query times with any aggregation type (min, max, avg, p50 through p99).
![SELECT warehouse performance change aggregation type](https://storage.googleapis.com/prod_select_images/changelog/slice_by_agg_20230501.gif)
Monitor query result cache usage rates to better understand performance.
![SELECT warehouse performance cache usage](https://select.dev/cdn-cgi/imagedelivery/1zmOcgV1p520E4lLTrYjjg/changelog/cache_usage_20230501.png/width=3840,quality=75)