Redshift Observatory

System Table Tracker

System view pg_catalog.stl_explain_internal version 1.0.74503 / 2024-09-16

schema	name	column	data type
pg_catalog	stl_explain_internal	missingstats	int4
pg_catalog	stl_explain_internal	nodeid	int4
pg_catalog	stl_explain_internal	parentid	int4
pg_catalog	stl_explain_internal	plannode	char(400)
pg_catalog	stl_explain_internal	query	int4
pg_catalog	stl_explain_internal	rows	int8
pg_catalog	stl_explain_internal	startupcost	float8
pg_catalog	stl_explain_internal	totalcost	float8
pg_catalog	stl_explain_internal	userid	int4
pg_catalog	stl_explain_internal	width	int8

View Text

SELECT stll_explain_internal.userid,
       stll_explain_internal.query,
       stll_explain_internal.nodeid,
       stll_explain_internal.parentid,
       stll_explain_internal.plannode,
       stll_explain_internal.startupcost,
       stll_explain_internal.totalcost,
       stll_explain_internal.rows,
       stll_explain_internal.width,
       stll_explain_internal.missingstats
FROM stll_explain_internal

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