Redshift Observatory

System Table Tracker

System view pg_catalog.stl_explain_internal version 1.0.82096 / 2025-01-23

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers