# -*- mode: snippet -*-
# name: query-requests-overview
# key: qro_
# group: vertica
# condition: (if (string-equal sql-product 'vertica)t)
# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't))
# --
SELECT user_name,
       start_timestamp,
       request_duration_ms,
       transaction_id,
       STATEMENT_ID,
       substr(request, 0, 1000) AS request
 FROM v_monitor.query_requests
WHERE transaction_id > 0
ORDER BY request_duration_ms DESC
LIMIT 10;$0