Package: postgresql-16-pg-stat-plans Source: pg-stat-plans Version: 2.1.1-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 273 Depends: postgresql-16, 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-16-pg-stat-plans_2.1.1-1.pgdg26.04+1_amd64.deb Size: 100012 SHA512: 0cbc9f98e9145e2d9b3ee5676fb73caa374d72837fbc5a4c5ecb14a96a8fd7eedaca9bdee7c3caffcf927ea3f3948e6ac96dc6d3cf328207a61877a3c3fb2061 SHA256: bddbdbfd7c5429c1158d0c81865801746b479b465d4339613a2364cb756cc7ba SHA1: 229995531fb7d65b2ee66734a16fa13128f265e2 MD5sum: 98d1653051e6301d0f2370ba2799efc6 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.