Package: postgresql-19-pg-stat-plans Source: pg-stat-plans Version: 2.1.0-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 262 Depends: postgresql-19, libc6 (>= 2.14), libzstd1 (>= 1.5.5) Homepage: https://github.com/pganalyze/pg_stat_plans Priority: optional Section: database Filename: pool/main/p/pg-stat-plans/postgresql-19-pg-stat-plans_2.1.0-1.pgdg26.04+1_amd64.deb Size: 89324 SHA512: 18ff13a50f2a1fad4a52d92ca256ac1d0c7091c30ab19bd6448a296da35b2c1a0afb862764e35f7e71bb1357cd02eb8298a9536c2aa03ce78f1fa927bbc88507 SHA256: 04befe87fa01fff0d0e48a9c3da0b59d430d0046d816681283369bf9501b5829 SHA1: 862959d685e042ac8ce9bb7ff12ab03824dce75a MD5sum: aa8aefd0eb0d7dd150d02258f687fa31 Description: Track per-plan call counts, execution times and EXPLAIN texts in PostgreSQL pg_stat_plans is designed for low overhead tracking of aggregate plan statistics in Postgres, by relying on hashing the plan tree with a plan ID calculation. It aims to help identify plan regressions, and get an example plan for each Postgres query run, slow and fast. Additionally, it allows showing the plan for a currently running query. . Plan texts are stored in shared memory for efficiency reasons (instead of a local file), with support for zstd compression to compress large plan texts. . Plans have the same plan IDs when they have the same "plan shape", which intends to match EXPLAIN (COSTS OFF). This extension is optimized for tracking changes in plan shape, but does not aim to track execution statistics for plans, like auto_explain can do for outliers.