pg_store_plans 1.9 is available for PostgreSQL 17

pg_store_plans now supports PostgreSQL 17.

The RPM package will only be released for RHEL9 at this time.

In this version, pg_store_plans handles new statistics columns for local buffer reads/writes, and renames existing columns previously used for shared buffers.

pg_store_plans 1.8 is available for PostgreSQL 16.

pg_store_plans now supports PostgreSQL16.
The RPM package will only be released for RHEL9 at this time.

pg_store_plans 1.7 isavailable for PostgreSQL 15.

Several new columns have been added in line with PostgreSQL 15 support. For the time being, the release targets only RHEL8. A version for RHEL9 will be released in due course.

Released pg_store_plans 1.6.1.

Released pg_store_plans 1.6.1.

This is a bug-fix release. One non-critical bug is fixed since 1.6.

• Properly close tentatively opened file when persistent storage file is not found. With 1.6, you will see a strange message at fresh start or restart after crash.

  WARNING: 1 temporary files and directories not closed at end-of-transaction

Released pg_store_plans 1.6.

Released pg_store_plans 1.6.

• Supports PostgreSQL 14 only.
• Removed the column queryid_stat_statements and now the column queryid shows the core generated query id that is controlled by compute_query_id. If it is set to off, pg_store_plans silently refuses to work.
• Added a new configuration parameter "pg_store_plans.plan_storage" to choose how plan strings are stored. The default is "file". By this setting this tool stores plan strings in a file as the current pg_stat_statements does. Set it to "shmem" (the default) to store on preallocated fixed-sized shared memory, which is the existing behavior.
• Maximum length of raw plan string is now configurable. It was accidentally unconfigurable.
• pg_store_plans now ignores queries/commands invoked during CREATE/ALTER EXTENSION by default (pg_store_plans.track = "all"). This tool didn't ignore them. If the old behavior is required, set pg_store_plans.track to "verbose".