Package: postgresql-16-pg-stat-plans Source: pg-stat-plans Version: 2.1.0-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 286 Depends: postgresql-16, libc6 (>= 2.14), libzstd1 (>= 1.4.0) Homepage: https://github.com/pganalyze/pg_stat_plans Priority: optional Section: database Filename: pool/main/p/pg-stat-plans/postgresql-16-pg-stat-plans_2.1.0-1.pgdg22.04+1_amd64.deb Size: 110460 SHA512: 90ecc597c2077e5db0640b450e67e8fc75fb0c69a842b9dda92d749a12a5e0d8a8ee7d7582b1dc7a4d863c137d3361d763fff49997fbe41202e7620ccb2eac0d SHA256: 0b8cf57d4061f59b77212d1eaa9c900a87dac766f541fab80d1e0eee9a886efa SHA1: bc03c2ab32a236f30893d492f7c12e9cb8c40492 MD5sum: e05c75b745896913372fc1439b9fa353 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.