Redshift Observatory

System Table Tracker

System view pg_catalog.stl_plan_rule_stats version 1.0.39009 / 2022-06-08

schema name column data type
pg_catalog stl_plan_rule_stats applicable_avg_time float8
pg_catalog stl_plan_rule_stats applicable_count int4
pg_catalog stl_plan_rule_stats applicable_max_time float8
pg_catalog stl_plan_rule_stats applicable_min_time float8
pg_catalog stl_plan_rule_stats applicable_total_time float8
pg_catalog stl_plan_rule_stats apply_avg_time float8
pg_catalog stl_plan_rule_stats apply_count int4
pg_catalog stl_plan_rule_stats apply_max_time float8
pg_catalog stl_plan_rule_stats apply_min_time float8
pg_catalog stl_plan_rule_stats apply_total_time float8
pg_catalog stl_plan_rule_stats match_count int4
pg_catalog stl_plan_rule_stats optimizer char(15)
pg_catalog stl_plan_rule_stats query int8
pg_catalog stl_plan_rule_stats rule char(15)
pg_catalog stl_plan_rule_stats sequence int4
pg_catalog stl_plan_rule_stats trasnformed_count int4

View Text

SELECT stll_plan_rule_stats.query,
       stll_plan_rule_stats.sequence,
       stll_plan_rule_stats.optimizer,
       stll_plan_rule_stats.rule,
       stll_plan_rule_stats.match_count,
       stll_plan_rule_stats.applicable_count,
       stll_plan_rule_stats.apply_count,
       stll_plan_rule_stats.trasnformed_count,
       stll_plan_rule_stats.applicable_total_time,
       stll_plan_rule_stats.applicable_max_time,
       stll_plan_rule_stats.applicable_min_time,
       stll_plan_rule_stats.applicable_avg_time,
       stll_plan_rule_stats.apply_total_time,
       stll_plan_rule_stats.apply_max_time,
       stll_plan_rule_stats.apply_min_time,
       stll_plan_rule_stats.apply_avg_time
FROM stll_plan_rule_stats


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