Redshift Observatory

System Table Tracker

System view pg_catalog.stl_unnest version 1.0.51986 / 2023-06-17

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

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