### 🆕 Postgres 18 support

-   Full compatibility: All new metrics and existing monitoring features now support Postgres 18
-   Extended version range: Monitoring now supports Postgres versions 14-18
### 🎨 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
### 🚀 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
### 🔍 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
### 🔧 Miscellaneous minor fixes and improvements
-   SQL query optimizations and compatibility enhancements
-   More consistent styling across the board

# Release Notes v0.8

## 🚀 New Features
- **Background Writer and Checkpointer Monitoring**: Added pg_stat_bgwriter metrics and dashboard visualizations
- **Vacuum Progress Tracking and visualisation**: Vacuum operation monitoring with pg_stat_progress_vacuum
- **Enhanced Table Statistics**: New comprehensive table stats dashboard
- **Query Text Export optimisation**: Added limits to query text export with optimized storage
## 🐛 Bug Fixes
- **Metric Collection Errors**: Fixed various metric collection issues
- **pg_stat_statements Optimization**: Removed “others” aggregation to improve detalization
- **PostgreSQL Sink**: Removed pg_vacuum_progress from postgres sink (kept in Prometheus)
- **Query Storage**: Optimized query text storage and export functionality

Merge branch 'add-password-generation' into 'main'

Add password generation

See merge request postgres-ai/postgres_ai!39

Merge branch 'checkup20' into 'main'

Checkup20

See merge request postgres-ai/postgres_ai!28

Fixed Active session history on the 1st Dashboard

Merge branch 'mvp' into 'main'

Dashboard fixes and new reports

See merge request postgres-ai/postgres_ai!18

Add Apache 2.0 license

Merge branch 'mvp' into 'main'

Redundant, unused and rarely used index metrics added

See merge request postgres-ai/postgres_ai!14

Merge branch 'mvp' into 'main'

Fixed a bug in reports related to invalid expression type Range query

See merge request postgres-ai/postgres_ai!13

Merge branch 'mvp' into 'main'

Modifications to CLI and new metrics

See merge request postgres-ai/postgres_ai!8