Skip to content

Released pg_store_plans 1.6.

Compare
Choose a tag to compare
@horiguti horiguti released this 17 Jan 06:09
· 12 commits to master since this release

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".