Vonng / pg_exporter

Advanced PostgreSQL & Pgbouncer Metrics Exporter for Prometheus
https://pigsty.io
Apache License 2.0
177 stars 45 forks source link

PostgreSQL 17 support #53

Closed Vonng closed 4 months ago

Vonng commented 4 months ago

https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-MIGRATION

Rename I/O block read/write timing statistics columns of pg_stat_statements (Nazir Bilal Yavuz)

This renames "blk_read_time" to "shared_blk_read_time", and "blk_write_time" to "shared_blk_write_time".

Remove buffers_backend and buffers_backend_fsync from pg_stat_checkpointer (Bharath Rupireddy)

These fields are considered redundant to similar columns in pg_stat_io.

Change pg_attribute.attstattarget and pg_attribute.stxstattarget to represent the default statistics target as NULL (Peter Eisentraut)

Change pg_stat_progress_vacuum columns max_dead_tuples to max_dead_tuple_bytes and num_dead_tuples to dead_tuple_bytes (Masahiko Sawada)

These columns now report bytes instead of tuples.

Rename SLRU columns in system view pg_stat_slru (Alvaro Herrera)

The column names accepted by pg_stat_slru_rest() are also changed.

Vonng commented 4 months ago

Resolved by https://github.com/Vonng/pg_exporter/commit/458624fca51b9ddc6861f04c5bde017a0e311668 https://github.com/Vonng/pg_exporter/commit/df9ec01a629a30eb4932771851be6f1b3b6d8538