T SQL Script: Azure SQL Find Top CPU Consumers (Query Store)

-- Azure SQL Find Top CPU Consumers (Query Store)
SELECT TOP 20
    q.query_id,
    qt.query_sql_text,
    SUM(rs.count_executions) AS ExecutionCount,
    SUM(rs.avg_cpu_time) AS TotalCPU,
    SUM(rs.avg_duration) AS TotalDuration
FROM sys.query_store_query q
JOIN sys.query_store_query_text qt ON q.query_text_id = qt.query_text_id
JOIN sys.query_store_plan p ON q.query_id = p.query_id
JOIN sys.query_store_runtime_stats rs ON p.plan_id = rs.plan_id
GROUP BY q.query_id, qt.query_sql_text
ORDER BY TotalCPU DESC;