Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adapt pg_stat_statements column rename in PostgreSQL 17 #420

Open
Vonng opened this issue May 24, 2024 · 1 comment
Open

Adapt pg_stat_statements column rename in PostgreSQL 17 #420

Vonng opened this issue May 24, 2024 · 1 comment
Assignees
Labels
EXTENSION PostgreSQL Extension Related MONITOR Monitoring related PGSQL PostgreSQL Related
Milestone

Comments

@Vonng
Copy link
Owner

Vonng commented May 24, 2024

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 Vonng added MONITOR Monitoring related PGSQL PostgreSQL Related EXTENSION PostgreSQL Extension Related labels May 24, 2024
@Vonng Vonng added this to the v2.8 milestone May 24, 2024
@Vonng Vonng self-assigned this May 24, 2024
@Vonng
Copy link
Owner Author

Vonng commented May 25, 2024

  • 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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
EXTENSION PostgreSQL Extension Related MONITOR Monitoring related PGSQL PostgreSQL Related
Projects
Status: No status
Development

No branches or pull requests

1 participant