# -*- mode: snippet -*-
# name: pool_queues
# key: pq_
# group: vertica
# condition: (if (string-equal sql-product 'vertica)t)
# https://www.vertica.com/blog/calculate-request-queue-length-quick-tip/?utm_campaign=00164962
# https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/RESOURCE_ACQUISITIONS.htm
# --
SELECT node_name, request_type, transaction_id, statement_id, pool_name, (acquisition_timestamp - queue_entry_timestamp) request_queue_length FROM v_monitor.resource_acquisitions WHERE pool_name = '${1:general}' ${2:AND (acquisition_timestamp - queue_entry_timestamp) > '1 second'} ORDER BY (acquisition_timestamp - queue_entry_timestamp) DESC ${3:LIMIT 42};$0