Package: postgresql-16-pg-stat-plans Source: pg-stat-plans Version: 2.1.0-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.0-1.pgdg26.04+1_amd64.deb Size: 99936 SHA512: fcfc45fbc136f3409c131b931931053a0057490061b45fb33235dac40b2c5b57b81d204def9925e3ed3ec8f079cbf3002406c5e8ddbb8e4877dece5c07044b8f SHA256: b636ee0e3b3524ae6e87b20c1b7df75dee726f1482067d99370346e7e460be6e SHA1: 1b703f4ea05440106f03a6765f394e36180d85b8 MD5sum: cc47f1b39cef8e0f2d62a96f75286d15 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.