Package: postgresql-19-pg-stat-plans Source: pg-stat-plans Version: 2.1.0-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 275 Depends: postgresql-19, 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-19-pg-stat-plans_2.1.0-1.pgdg22.04+1_amd64.deb Size: 96684 SHA512: f65dc56234ef06b3162eb6e850d807c069534f348ead509033b67fea1f323100f19e4c48081f5265bc291db03f54aad7f45feea211a29cb3cb4ca705cc7a7d7d SHA256: c291f4018db69517680c3072d02fc8c1cfa9679e7aa86b5b410d2b223c406782 SHA1: 1c06020491cfa9d08971e524cf295f37d0ab9a3b MD5sum: 08cd050d600ff84ef42ce3fa35b01252 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.