Package: postgresql-18-pg-stat-plans Source: pg-stat-plans Version: 2.1.1-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 252 Depends: postgresql-18, 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-18-pg-stat-plans_2.1.1-1.pgdg26.04+1_amd64.deb Size: 84784 SHA512: 20d47d15db07d99a746a33dbac472130e159f8c61727be915d33d8f124a009cb4640fca17763ea49a75fe95e2e63b136cbf3bdd889046de9ef2998a44d5ca3f9 SHA256: d92474ad85e585c26b475abdb30cf3549d369d8b79c6a25357d8f2fdd4156c98 SHA1: 4ad4c4f7e074814878e5461f6270d40fbb0f866b MD5sum: dccd9e02462cce0a7aadc584e31553ef 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.