Queries

This page lists all running queries, completed queries that are archived in memory, and imported query profiles.

The in-memory archive size is controlled by --query_log_size and --query_log_size_in_bytes command line parameters. The length of the statements are controlled by --query_stmt_size command line parameter.

{{num_executing_queries}} queries in flight

{{! filter to get just executing queries from in_flight_queries}} {{#in_flight_queries}} {{?executing}} {{/executing}} {{/in_flight_queries}}

Query ID	Action	User	Default Db	Query Type	Start Time	First Fetch Client Fetch Duration	Duration Queued Duration	Mem Usage Mem Estimate	Scan Progress Query Progress	Bytes Read Bytes Sent	State	Last Event	# rows fetched	Resource Pool	Coordinator Slots	Executor Slots	Statement
{{query_id}}	Cancel	{{effective_user}}	{{default_db}}	`{{stmt_type}}`	{{start_time}}	{{first_fetch}} {{client_fetch_duration}}	{{duration}} {{queued_duration}}	{{mem_usage}} {{mem_est}}	{{progress}} {{query_progress}}	{{bytes_read}} {{bytes_sent}}	`{{state}}`	`{{last_event}}`	{{rows_fetched}}	{{resource_pool}}	{{coordinator_slots}}	{{executor_slots}}	`{{stmt}}`

{{num_waiting_queries}} waiting to be closed ^[?]

{{! filter to get just waiting queries from in_flight_queries}} {{#in_flight_queries}} {{?waiting}} {{/waiting}} {{/in_flight_queries}}

Query ID	Action	User	Default Db	Query Type	Start Time	Waiting Time	First Fetch Client Fetch Duration	Duration Queued Duration	Mem Usage Mem Estimate	Scan Progress Query Progress	Bytes Read Bytes Sent	State	Last Event	# rows fetched	Resource Pool	Coordinator Slots	Executor Slots	Statement
{{query_id}}	Close	{{effective_user}}	{{default_db}}	`{{stmt_type}}`	{{start_time}}	{{waiting_time}}	{{first_fetch}} {{client_fetch_duration}}	{{duration}} {{queued_duration}}	{{mem_usage}} {{mem_est}}	{{progress}} {{query_progress}}	{{bytes_read}} {{bytes_sent}}	`{{state}}`	`{{last_event}}`	{{rows_fetched}}	{{resource_pool}}	{{coordinator_slots}}	{{executor_slots}}	`{{stmt}}`

Last {{completed_log_size}} Completed Queries

Query ID	User	Default Db	Query Type	Start Time	End Time	First Fetch Client Fetch Duration	Duration Queued Duration	Mem Usage Mem Estimate	Scan Progress Query Progress	Bytes Read Bytes Sent	State	# rows fetched	Resource Pool	Coordinator Slots	Executor Slots	Statement
{{query_id}}	{{effective_user}}	{{default_db}}	`{{stmt_type}}`	{{start_time}}	{{end_time}}	{{first_fetch}} {{client_fetch_duration}}	{{duration}} {{queued_duration}}	{{mem_usage}} {{mem_est}}	{{progress}} {{query_progress}}	{{bytes_read}} {{bytes_sent}}	`{{state}}`	{{rows_fetched}}	{{resource_pool}}	{{coordinator_slots}}	{{executor_slots}}	`{{stmt}}`

0 Imported Query Profiles ^[?] Import JSON Profile

Query ID	User	Default Db	Query Type	Start Time	End Time	Bytes Read Bytes Sent	State	# rows fetched	Resource Pool	Statement	Delete

Query Locations

Location	Backend Id	Number of running queries with fragments on this host
{{location}}	{{backend_id}}	{{count}}