pigsty icon indicating copy to clipboard operation
pigsty copied to clipboard

Adapt pg_stat_statements column rename in PostgreSQL 17

Open Vonng opened this issue 1 year ago • 1 comments
trafficstars

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

https://www.postgresql.org/docs/17/pgstatstatements.html

Adding a new collector in pg_exporter.yml

Vonng avatar May 24 '24 10:05 Vonng

  • Replace CALL parameters in pg_stat_statements with placeholders (Sami Imseih)

  • Replace savepoint names stored in pg_stat_statements with placeholders (Greg Sabino Mullane)

    This greatly reduces the number of entries needed to record SAVEPOINT, RELEASE SAVEPOINT, and ROLLBACK TO SAVEPOINT commands.

  • Replace two-phase commit GIDs stored in pg_stat_statements with placeholders (Michael Paquier)

    This greatly reduces the number of entries needed to record PREPARE TRANSACTION, COMMIT PREPARED, and ROLLBACK PREPARED.

  • Track DEALLOCATE in pg_stat_statements (Dagfinn Ilmari Mannsåker, Michael Paquier)

    DEALLOCATE names are stored in pg_stat_statements as placeholders.

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

    The new columns are "local_blk_read_time" and "local_blk_write_time".

  • Add JIT deform_counter details to pg_stat_statements (Dmitry Dolgov)

  • Add optional fourth argument (minmax_only) to pg_stat_statements_reset() to allow for the resetting of only min/max statistics (Andrei Zubkov)

    This argument defaults to "false".

  • Add pg_stat_statements columns "stats_since" and "minmax_stats_since" to track entry creation time and last min/max reset time (Andrei Zubkov)

Vonng avatar May 25 '24 02:05 Vonng

resolved by https://github.com/Vonng/pg_exporter/issues/53

Vonng avatar Jul 07 '24 00:07 Vonng