Redshift Observatory

System Table Tracker

System view pg_catalog.stl_plan_perf version 1.0.46806 / 2023-02-21

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