feat(metrics): improve bloat metric ordering, add query limits, helm schedule change to daily

Metrics changes:

  • pg_btree_bloat, pg_table_bloat: prioritize valid entries in ordering (is_na = 0 desc, bloat_pct desc) and reduce limit from 5000 to 1000, also introduced a limit of at least 1MiB
  • Add LIMIT 1000 to table_size_detailed, pg_invalid_indexes, redundant_indexes, unused_indexes, rarely_used_indexes

Helm values:

  • Change reporter schedule from every 6 hours to daily at midnight

Merge request reports

Loading