Redshift Observatory

System Table Tracker

System view pg_catalog.stl_segment_starts version 1.0.39734 / 2022-07-11

schema	name	column	data type
pg_catalog	stl_segment_starts	arrivetime	timestamp
pg_catalog	stl_segment_starts	node	int4
pg_catalog	stl_segment_starts	pid	int4
pg_catalog	stl_segment_starts	query	int4
pg_catalog	stl_segment_starts	seg	int4
pg_catalog	stl_segment_starts	slice	int4
pg_catalog	stl_segment_starts	starttime	timestamp
pg_catalog	stl_segment_starts	tasknum	int4
pg_catalog	stl_segment_starts	userid	int4

View Text

SELECT stll_segment_starts.userid,
       stll_segment_starts.node,
       stll_segment_starts.tasknum,
       stll_segment_starts.pid,
       stll_segment_starts.starttime,
       stll_segment_starts.query,
       stll_segment_starts.slice,
       stll_segment_starts.seg,
       stll_segment_starts.arrivetime
FROM stll_segment_starts

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