- Full compatibility: All new metrics and existing monitoring features now support Postgres 18
- Extended version range: Monitoring now supports Postgres versions 14-18
### :art: New dashboards
Dashboard 8 (Aggregated table analysis):
- Top tables by sizes (main (excluding TOAST), TOAST, size of indexes associated with the table)
- Top tables by tuple operation rates (inserts, deletes, HOT updates, non-HOT updates)
- Top tables by estimated bloat
- Top tables by shared blocks hit/read types
- Top tables by sequential/index live tuple fetches
Dashboard 9 (Single table analysis):
- Detailed table size distribution breakdown
- Estimated bloat analysis
- Sequential/index live tuple fetch breakdown
- I/O statistics section with shared block hits, reads, and hit ratio analysis
- Enhanced tuple operations analysis
### :rocket: pg_index_pilot integration
Monitoring of the automated index management solution brought by our team:
- New pg_index_pilot metric monitors index states, sizes, and optimization ratios
- pg_index_pilot_config metric tracks rebuild thresholds and settings
### :mag: Other new metrics added
Enhanced table monitoring capabilities:
- Table size components: table_size_detailed metric
- I/O performance tracking: pg_statio_all_tables metric
- System catalog access: pg_class metric
### :wrench: Miscellaneous minor fixes and improvements
- SQL query optimizations and compatibility enhancements
- More consistent styling across the board