Redshift Observatory

System Table Tracker

System view pg_catalog.stl_exec_state version 1.0.74503 / 2024-09-16

schema	name	column	data type
pg_catalog	stl_exec_state	bytes	int8
pg_catalog	stl_exec_state	currenttime	timestamp
pg_catalog	stl_exec_state	is_delayed_scan	char(1)
pg_catalog	stl_exec_state	is_diskbased	char(1)
pg_catalog	stl_exec_state	is_rrscan	char(1)
pg_catalog	stl_exec_state	label	char(256)
pg_catalog	stl_exec_state	node_id	int4
pg_catalog	stl_exec_state	num_parts	int4
pg_catalog	stl_exec_state	parent_node_id	int4
pg_catalog	stl_exec_state	query	int4
pg_catalog	stl_exec_state	rows	int8
pg_catalog	stl_exec_state	segment	int4
pg_catalog	stl_exec_state	slice	int4
pg_catalog	stl_exec_state	starttime	timestamp
pg_catalog	stl_exec_state	step	int4
pg_catalog	stl_exec_state	step_attribute	char(64)
pg_catalog	stl_exec_state	tasknum	int4
pg_catalog	stl_exec_state	userid	int4
pg_catalog	stl_exec_state	workmem	int8

View Text

SELECT stll_exec_state.userid,
       stll_exec_state.query,
       stll_exec_state.slice,
       stll_exec_state.segment,
       stll_exec_state.step,
       stll_exec_state.starttime,
       stll_exec_state.currenttime,
       stll_exec_state.tasknum,
       stll_exec_state.rows,
       stll_exec_state.bytes,
       stll_exec_state.label,
       stll_exec_state.is_diskbased,
       stll_exec_state.workmem,
       stll_exec_state.num_parts,
       stll_exec_state.is_rrscan,
       stll_exec_state.is_delayed_scan,
       stll_exec_state.step_attribute,
       stll_exec_state.parent_node_id,
       stll_exec_state.node_id
FROM stll_exec_state
WHERE stll_exec_state.access_control = 0
   OR stll_exec_state.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