Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_detail version 1.0.74097 / 2024-09-02

schema	name	column	data type
pg_catalog	stl_query_detail	alert	char(1024)
pg_catalog	stl_query_detail	blocks_read	int8
pg_catalog	stl_query_detail	blocks_write	int8
pg_catalog	stl_query_detail	child_query_id	int4
pg_catalog	stl_query_detail	child_query_sequence	int4
pg_catalog	stl_query_detail	cpu_time	int8
pg_catalog	stl_query_detail	endtime	timestamp
pg_catalog	stl_query_detail	input_bytes	int8
pg_catalog	stl_query_detail	input_rows	int8
pg_catalog	stl_query_detail	internal_query	char(1)
pg_catalog	stl_query_detail	is_rrscan	char(1)
pg_catalog	stl_query_detail	local_read_io	int8
pg_catalog	stl_query_detail	output_bytes	int8
pg_catalog	stl_query_detail	output_rows	int8
pg_catalog	stl_query_detail	plan_node_id	int4
pg_catalog	stl_query_detail	plan_parent_id	int4
pg_catalog	stl_query_detail	query_id	int8
pg_catalog	stl_query_detail	remote_read_io	int8
pg_catalog	stl_query_detail	segment_id	int4
pg_catalog	stl_query_detail	slice	int4
pg_catalog	stl_query_detail	source	char(64)
pg_catalog	stl_query_detail	spilled_block_local_disk	int8
pg_catalog	stl_query_detail	spilled_block_remote_disk	int8
pg_catalog	stl_query_detail	starttime	timestamp
pg_catalog	stl_query_detail	step_attribute	char(64)
pg_catalog	stl_query_detail	step_id	int4
pg_catalog	stl_query_detail	step_name	int4
pg_catalog	stl_query_detail	stream_id	int4
pg_catalog	stl_query_detail	table_id	int4
pg_catalog	stl_query_detail	table_name	char(136)
pg_catalog	stl_query_detail	user_id	int4

View Text

SELECT stll_query_detail.user_id,
       stll_query_detail.query_id,
       stll_query_detail.child_query_id,
       stll_query_detail.child_query_sequence,
       stll_query_detail.stream_id,
       stll_query_detail.segment_id,
       stll_query_detail.step_id,
       stll_query_detail.slice,
       stll_query_detail.starttime,
       stll_query_detail.endtime,
       stll_query_detail.step_name,
       stll_query_detail.table_id,
       stll_query_detail.table_name,
       stll_query_detail.input_rows,
       stll_query_detail.input_bytes,
       stll_query_detail.output_rows,
       stll_query_detail.output_bytes,
       stll_query_detail.is_rrscan,
       stll_query_detail.blocks_read,
       stll_query_detail.blocks_write,
       stll_query_detail.local_read_io,
       stll_query_detail.remote_read_io,
       stll_query_detail.alert,
       stll_query_detail.internal_query,
       stll_query_detail.source,
       stll_query_detail.cpu_time,
       stll_query_detail.spilled_block_local_disk,
       stll_query_detail.spilled_block_remote_disk,
       stll_query_detail.step_attribute,
       stll_query_detail.plan_parent_id,
       stll_query_detail.plan_node_id
FROM stll_query_detail
WHERE stll_query_detail.access_control = 0
   OR stll_query_detail.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers