To Nha Notes | April 5, 2023, 12:38 p.m.
SELECT
QUERY_TEXT
, WAREHOUSE_NAME
, TOTAL_ELAPSED_TIME
, EXECUTION_TIME
, START_TIME
, END_TIME
FROM
TABLE(INFORMATION_SCHEMA.QUERY_HISTORY( DATEADD('days', -3, CURRENT_TIMESTAMP()), CURRENT_TIMESTAMP()))
ORDER BY
EXECUTION_TIME DESC
, TOTAL_ELAPSED_TIME DESC
LIMIT 100;