Top Gradient
Back

New warehouse performance views

Friday, April 14, 2023

  • Author
    Niall WoodwardCo-founder & CTO of SELECT

On the warehouse performance tab, we’ve included two new views to help with warehouse sizing:

  1. The number of queries by execution time. Here you can see that over 98% of the queries running on this warehouse are taking less than 1 second to execute.
  2. The number of queries by utilizable warehouse size. Utilizable warehouse size represents the size of warehouse a query can fully utilize. The value is always capped at the query's current warehouse size. Where lots of queries don't utilize the warehouse's size, it indicates that the warehouse is oversized or the queries should run on a smaller warehouse. In this example, over 96% of queries being run on the warehouse aren’t using all 8 nodes available in the warehouse.

SELECT warehouse performance views

Up next.Previous Changelog Entries.

Get up and running in less than 15 minutes

Connect your Snowflake account and instantly understand your savings potential.

CTA Screen