Redshift Observatory

System Table Tracker

System view pg_catalog.stl_plan_rule_stats version 1.0.59596 / 2023-11-12

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