Package: postgresql-19-pg-stat-plans Source: pg-stat-plans Version: 2.1.1-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 258 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.1-1.pgdg26.04+1_amd64.deb Size: 87512 SHA512: 7e1599d93cde9462b30bafb51b03cfb586bc4229b24ecfc6850b4555496ca4c334ebf169583380894ea5d969a51f1acc0330462490b94baaf842ad587707fc2a SHA256: 8e581080eb35510a2f39f05ce0e1259c99caefd0c029fa0cfc4db07850865490 SHA1: 15d3e94a2c2f407d4e03dacf59b722bfd7acac6f MD5sum: 37d58a281c47c43c5acd81dfdc5525ff 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.