Package: postgresql-19-pg-stat-plans Source: pg-stat-plans Version: 2.1.1-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 271 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.1-1.pgdg22.04+1_amd64.deb Size: 94912 SHA512: 50cfcc0fd870bfd3175c68dc8473334bee50d7193a9432b7640c8f53efd848ce40a942c7be6e4402a2ea830d0b8f2d9928e89039d8929cdd746a8c6b19f7461e SHA256: 97f3ceefb37a0650c0e30e095ec18e75e704e04ad31bbe501972562d879c769f SHA1: db64b83f73627652325a4c421dcdfdbd13e39054 MD5sum: bb4d5c2eae7039972ef180839709de52 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.