At a glance
Top 10 Slowest Queries is the named leaderboard behind your performance metrics: the ten queries with the longest total elapsed time in the last 24 hours, broken down by row. Where the rate and percentile cards tell you how much of your workload is slow, this card tells you exactly which queries to fix first.
Calculation
Calculated automatically from your Snowflake account data. See the At a glance summary above for what the metric tracks and the reconcile pointer below for the native check.What it tracks
This card lists the ten slowest queries of the last 24 hours, one per row, ranked byTOTAL_ELAPSED_TIME (compile plus queue plus execution) from QUERY_HISTORY. Each row typically surfaces the query id, the warehouse it ran on, the elapsed duration, bytes scanned, and a truncated query text, so a platform team can go straight from “something is slow” to the specific SQL responsible. A query appearing here is doing one of a few things: scanning far more data than it needs (no pruning predicate), sitting in a warehouse queue (saturation), spilling to local or remote storage (under-sized warehouse for the join), or simply being a heavy but legitimate batch job. The leaderboard is the drill-down companion to Slow-Query Rate % and Query Latency p95 (ms): when those move, this card names the offenders. Pair it with Warehouse Saturation % and Avg Query Queue Depth per Warehouse to tell whether the slowness is the query’s own fault or the warehouse being starved, and with Avg Cost per Query ($) because the slowest queries are usually the most expensive too.
Reconcile against the source: in Snowsight open Monitoring to Query History, set the window to the last 24 hours, and sort by Total Duration descending; or query SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY ordered by TOTAL_ELAPSED_TIME DESC LIMIT 10. The top rows should match the card (allow for ACCOUNT_USAGE latency of up to ~45 minutes on the most recent queries).