Redshift Observatory

System Table Tracker

System view pg_catalog.stl_save version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_save	bytes	int8
pg_catalog	stl_save	endtime	timestamp
pg_catalog	stl_save	is_diskbased	char(1)
pg_catalog	stl_save	is_save_rtf	char(1)
pg_catalog	stl_save	memory_usage_ratio	int4
pg_catalog	stl_save	query	int4
pg_catalog	stl_save	rows	int8
pg_catalog	stl_save	segment	int4
pg_catalog	stl_save	slice	int4
pg_catalog	stl_save	starttime	timestamp
pg_catalog	stl_save	step	int4
pg_catalog	stl_save	tasknum	int4
pg_catalog	stl_save	tbl	int4
pg_catalog	stl_save	used_mega_block	char(1)
pg_catalog	stl_save	userid	int4
pg_catalog	stl_save	workmem	int8

View Text

SELECT stll_save.userid,
       stll_save.query,
       stll_save.slice,
       stll_save.segment,
       stll_save.step,
       stll_save.starttime,
       stll_save.endtime,
       stll_save.tasknum,
       stll_save.rows,
       stll_save.bytes,
       stll_save.tbl,
       stll_save.is_diskbased,
       stll_save.workmem,
       stll_save.is_save_rtf,
       stll_save.used_mega_block,
       stll_save.memory_usage_ratio
FROM stll_save
WHERE stll_save.access_control = 0
   OR stll_save.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