Redshift Observatory

System Table Tracker

System view pg_catalog.stl_plan_info version 1.0.41194 / 2022-09-03

schema name column data type
pg_catalog stl_plan_info bytes int8
pg_catalog stl_plan_info locus int4
pg_catalog stl_plan_info nodeid int4
pg_catalog stl_plan_info plannode int4
pg_catalog stl_plan_info query int4
pg_catalog stl_plan_info rows int8
pg_catalog stl_plan_info segment int4
pg_catalog stl_plan_info startupcost float8
pg_catalog stl_plan_info step int4
pg_catalog stl_plan_info totalcost float8
pg_catalog stl_plan_info userid int4

View Text

SELECT stll_plan_info.userid,
       stll_plan_info.query,
       stll_plan_info.nodeid,
       stll_plan_info.segment,
       stll_plan_info.step,
       stll_plan_info.locus,
       stll_plan_info.plannode,
       stll_plan_info.startupcost,
       stll_plan_info.totalcost,
       stll_plan_info.rows,
       stll_plan_info.bytes
FROM stll_plan_info


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