Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_plan_perf	avg_time	float8
pg_catalog	stl_plan_perf	component	char(50)
pg_catalog	stl_plan_perf	count	int4
pg_catalog	stl_plan_perf	max_time	float8
pg_catalog	stl_plan_perf	min_time	float8
pg_catalog	stl_plan_perf	query	int8
pg_catalog	stl_plan_perf	sequence	int4
pg_catalog	stl_plan_perf	total_time	float8
pg_catalog	stl_plan_perf	udc	int4

View Text

SELECT stll_plan_perf.query,
       stll_plan_perf.sequence,
       stll_plan_perf.component,
       stll_plan_perf.count,
       stll_plan_perf.udc,
       stll_plan_perf.total_time,
       stll_plan_perf.max_time,
       stll_plan_perf.min_time,
       stll_plan_perf.avg_time
FROM stll_plan_perf

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