SVL_QUERY_QUEUE_INFO - Amazon Redshift

SVL_QUERY_QUEUE_INFO

Summarizes details for queries that spent time in a workload management (WLM) query queue or a commit queue.

The SVL_QUERY_QUEUE_INFO view filters queries performed by the system and shows only queries performed by a user.

The SVL_QUERY_QUEUE_INFO view summarizes information from the STL_QUERY, STL_WLM_QUERY, and STL_COMMIT_STATS system tables.

SVL_QUERY_QUEUE_INFO is visible only to superusers. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
database text The name of the database the user was connected to when the query was issued.
query integer Query ID.
xid bigint Transaction ID.
userid integer ID of the user that generated the query.
querytxt text First 100 characters of the query text.
queue_start_time timestamp Time in UTC when the query entered the WLM queue.
exec_start_time timestamp Time in UTC when query execution started.
service_class integer ID for the service class. Service classes are defined in the WLM configuration file.
slots integer Number of WLM query slots.
queue_elapsed bigint Time that the query spent waiting in a WLM queue (in seconds).
exec_elapsed bigint Time spent executing the query (in seconds).
wlm_total_elapsed bigint Time that the query spent in a WLM queue (queue_elapsed), plus time spent executing the query (exec_elapsed).
commit_queue_elapsed bigint Time that the query spent waiting in the commit queue (in seconds).
commit_exec_time bigint Time that the query spent in the commit operation (in seconds).
service_class_name character(64) The name of the service class.

Sample queries

The following example shows the time that queries spent in WLM queues.

select query, service_class, queue_elapsed, exec_elapsed, wlm_total_elapsed from svl_query_queue_info where wlm_total_elapsed > 0; query | service_class | queue_elapsed | exec_elapsed | wlm_total_elapsed ---------+---------------+---------------+--------------+------------------- 2742669 | 6 | 2 | 916 | 918 2742668 | 6 | 4 | 197 | 201 (2 rows)