Package: postgresql-17-pg-stat-plans Source: pg-stat-plans Version: 2.1.0-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 277 Depends: postgresql-17, 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-17-pg-stat-plans_2.1.0-1.pgdg26.04+1_amd64.deb Size: 100876 SHA512: 6b6e92a54947b4273636d28ef1e7540fa138bddf9024bff640eef9bcfddaf03a2fca44b7ba9bc6e418bcfc3bcbe2742beec76586566d2ee50a35e507ee5f9890 SHA256: 4e169775c3d8275db85473059582e72a62df6d36436900c102df151a2a25e7f1 SHA1: fff38425aa338e746401bfec1ec73c065cd3d3c1 MD5sum: d81c6c65a4a81bc982c963806312bae4 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.