Skip to main content
Skip to main content

active_queries

Overview

Used to view currently executing queries

Database

information_schema

Table Information

Column NameTypeDescription
QUERY_IDvarchar(256)The ID of the query
QUERY_START_TIMEvarchar(256)The start time of the query
QUERY_TIME_MSbigintThe execution time of the query
WORKLOAD_GROUP_IDbigintThe ID of the Workload Group to which the query belongs
DATABASEvarchar(256)The Database where the query was executed
FRONTEND_INSTANCEvarchar(256)The IP address of the Frontend instance that received the query request
QUEUE_START_TIMEvarchar(256)The start time of queuing; empty if not queued
QUEUE_END_TIMEvarchar(256)The end time of queuing; empty if not queued
QUERY_STATUSvarchar(256)The status of the query
SQLtextThe text of the query statement