Package: postgresql-17-pg-stat-plans Source: pg-stat-plans Version: 2.1.1-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 290 Depends: postgresql-17, 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-17-pg-stat-plans_2.1.1-1.pgdg22.04+1_amd64.deb Size: 112236 SHA512: 957fd18ca3ab514721548e6bf217fb7a6cbda27acf72fe8b9bdcbdb378026581f96a74ab846461c965fa95a069250dd70afd3d44f891761393aa742faefd3bc8 SHA256: 246a93cfcbcc5f6d175caa18a98c1142900ca311e1ed1cc1dd108e6cc30c90f8 SHA1: 1bd474f5866a8569547c4c30effef7eef9879779 MD5sum: 9ea80e1da1aac9a4ae9142a87613daeb 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.