Redshift Observatory

System Table Tracker

System view pg_catalog.stl_unnest version 1.0.81462 / 2025-01-09

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers