Redshift Observatory

System Table Tracker

System view pg_catalog.stl_dist version 1.0.70695 / 2024-07-11

schema	name	column	data type
pg_catalog	stl_dist	bytes	int8
pg_catalog	stl_dist	distribute_by_lds	char(1)
pg_catalog	stl_dist	endtime	timestamp
pg_catalog	stl_dist	is_intra_node	char(1)
pg_catalog	stl_dist	packets	int4
pg_catalog	stl_dist	query	int4
pg_catalog	stl_dist	rows	int8
pg_catalog	stl_dist	segment	int4
pg_catalog	stl_dist	slice	int4
pg_catalog	stl_dist	starttime	timestamp
pg_catalog	stl_dist	step	int4
pg_catalog	stl_dist	tasknum	int4
pg_catalog	stl_dist	topology_signature	int8
pg_catalog	stl_dist	userid	int4

View Text

SELECT stll_dist.userid,
       stll_dist.query,
       stll_dist.slice,
       stll_dist.segment,
       stll_dist.step,
       stll_dist.starttime,
       stll_dist.endtime,
       stll_dist.tasknum,
       stll_dist.rows,
       stll_dist.bytes,
       stll_dist.packets,
       stll_dist.topology_signature,
       stll_dist.is_intra_node,
       stll_dist.distribute_by_lds
FROM stll_dist
WHERE stll_dist.access_control = 0
   OR stll_dist.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