Redshift Observatory

System Table Tracker

System view pg_catalog.stl_plan_state version 1.0.58814 / 2023-10-31

schema	name	column	data type
pg_catalog	stl_plan_state	component	char(32)
pg_catalog	stl_plan_state	detail	char(100)
pg_catalog	stl_plan_state	label	char(320)
pg_catalog	stl_plan_state	query	int8
pg_catalog	stl_plan_state	state	char(15)
pg_catalog	stl_plan_state	vpid	int4
pg_catalog	stl_plan_state	xid	int8

View Text

SELECT stll_plan_state.query,
       stll_plan_state.component,
       stll_plan_state.state,
       stll_plan_state.detail,
       stll_plan_state.label,
       stll_plan_state.xid,
       stll_plan_state.vpid
FROM stll_plan_state

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