Redshift Observatory

System Table Tracker

System view pg_catalog.stl_unnest version 1.0.74754 / 2024-09-16

schema	name	column	data type
pg_catalog	stl_unnest	endtime	timestamp
pg_catalog	stl_unnest	query	int4
pg_catalog	stl_unnest	rows	int8
pg_catalog	stl_unnest	segment	int4
pg_catalog	stl_unnest	slice	int4
pg_catalog	stl_unnest	starttime	timestamp
pg_catalog	stl_unnest	step	int4
pg_catalog	stl_unnest	tasknum	int4
pg_catalog	stl_unnest	userid	int4

View Text

SELECT stll_unnest.userid,
       stll_unnest.query,
       stll_unnest.slice,
       stll_unnest.segment,
       stll_unnest.step,
       stll_unnest.starttime,
       stll_unnest.endtime,
       stll_unnest.tasknum,
       stll_unnest.rows
FROM stll_unnest
WHERE stll_unnest.access_control = 0
   OR stll_unnest.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