pg_store_plans

track plan statistics of all SQL statements executed

Overview

ID	Extension	Package	Version	Category	License	Language
6250	pg_store_plans	pg_store_plans	`1.9`	STAT	BSD 3-Clause	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd-r	No	Yes	Yes	Yes	yes	no

Relationships
See Also	pg_show_plans auto_explain pg_stat_statements pg_hint_plan pre_prepare pg_stat_monitor explain_ui plprofiler

pg18 breaks, fixed by Vonng

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PIGSTY	`1.9`	18 17 16 15 14 13	`pg_store_plans_$v*`	-
Debian	PIGSTY	`1.9`	18 17 16 15 14 13	`postgresql-$v-pg-store-plan`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PIGSTY 1.9	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
el8.aarch64	PIGSTY 1.9	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
el9.x86_64	PIGSTY 1.9	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
el9.aarch64	PIGSTY 1.9	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
el10.x86_64	PIGSTY 1.9	PIGSTY 1.9	PGDG 1.8	PGDG 1.8	MISS	MISS
el10.aarch64	PIGSTY 1.9	PIGSTY 1.9	PGDG 1.8	PGDG 1.8	MISS	MISS
d12.x86_64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
d12.aarch64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
d13.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
d13.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
u22.x86_64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
u22.aarch64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
u24.x86_64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8
u24.aarch64	MISS	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8	PIGSTY 1.8

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_18`	1.9	`el8.x86_64`	pigsty	44.5 KiB	pg_store_plans_18-1.9-1PIGSTY.el8.x86_64.rpm
`pg_store_plans_18`	1.9	`el8.aarch64`	pigsty	43.2 KiB	pg_store_plans_18-1.9-1PIGSTY.el8.aarch64.rpm
`pg_store_plans_18`	1.9	`el9.x86_64`	pigsty	43.5 KiB	pg_store_plans_18-1.9-1PIGSTY.el9.x86_64.rpm
`pg_store_plans_18`	1.9	`el9.aarch64`	pigsty	42.9 KiB	pg_store_plans_18-1.9-1PIGSTY.el9.aarch64.rpm
`pg_store_plans_18`	1.9	`el10.x86_64`	pigsty	44.7 KiB	pg_store_plans_18-1.9-1PIGSTY.el10.x86_64.rpm
`pg_store_plans_18`	1.9	`el10.aarch64`	pigsty	43.6 KiB	pg_store_plans_18-1.9-1PIGSTY.el10.aarch64.rpm

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_17`	1.8	`el8.x86_64`	pigsty	40.7 KiB	pg_store_plans_17-1.8-2PIGSTY.el8.x86_64.rpm
`pg_store_plans_17`	1.8	`el8.aarch64`	pigsty	39.4 KiB	pg_store_plans_17-1.8-2PIGSTY.el8.aarch64.rpm
`pg_store_plans_17`	1.8	`el9.x86_64`	pigsty	42.4 KiB	pg_store_plans_17-1.8-2PIGSTY.el9.x86_64.rpm
`pg_store_plans_17`	1.8	`el9.aarch64`	pigsty	41.5 KiB	pg_store_plans_17-1.8-2PIGSTY.el9.aarch64.rpm
`pg_store_plans_17`	1.9	`el10.x86_64`	pigsty	43.2 KiB	pg_store_plans_17-1.9-1PIGSTY.el10.x86_64.rpm
`pg_store_plans_17`	1.9	`el10.aarch64`	pigsty	42.2 KiB	pg_store_plans_17-1.9-1PIGSTY.el10.aarch64.rpm
`postgresql-17-pg-store-plan`	1.8	`d12.x86_64`	pigsty	119.2 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~bookworm_amd64.deb
`postgresql-17-pg-store-plan`	1.8	`d12.aarch64`	pigsty	116.3 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~bookworm_arm64.deb
`postgresql-17-pg-store-plan`	1.8	`u22.x86_64`	pigsty	128.9 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~jammy_amd64.deb
`postgresql-17-pg-store-plan`	1.8	`u22.aarch64`	pigsty	127.3 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~jammy_arm64.deb
`postgresql-17-pg-store-plan`	1.8	`u24.x86_64`	pigsty	114.0 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~noble_amd64.deb
`postgresql-17-pg-store-plan`	1.8	`u24.aarch64`	pigsty	112.5 KiB	postgresql-17-pg-store-plan_1.8-2PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_16`	1.8	`el8.x86_64`	pigsty	40.7 KiB	pg_store_plans_16-1.8-2PIGSTY.el8.x86_64.rpm
`pg_store_plans_16`	1.8	`el8.x86_64`	pgdg	45.4 KiB	pg_store_plans_16-1.8-1PGDG.rhel8.x86_64.rpm
`pg_store_plans_16`	1.8	`el8.aarch64`	pigsty	39.4 KiB	pg_store_plans_16-1.8-2PIGSTY.el8.aarch64.rpm
`pg_store_plans_16`	1.8	`el8.aarch64`	pgdg	44.1 KiB	pg_store_plans_16-1.8-1PGDG.rhel8.aarch64.rpm
`pg_store_plans_16`	1.8	`el9.x86_64`	pigsty	42.3 KiB	pg_store_plans_16-1.8-2PIGSTY.el9.x86_64.rpm
`pg_store_plans_16`	1.8	`el9.x86_64`	pgdg	46.1 KiB	pg_store_plans_16-1.8-1PGDG.rhel9.x86_64.rpm
`pg_store_plans_16`	1.8	`el9.aarch64`	pigsty	41.4 KiB	pg_store_plans_16-1.8-2PIGSTY.el9.aarch64.rpm
`pg_store_plans_16`	1.8	`el9.aarch64`	pgdg	45.1 KiB	pg_store_plans_16-1.8-1PGDG.rhel9.aarch64.rpm
`pg_store_plans_16`	1.8	`el10.x86_64`	pgdg	47.1 KiB	pg_store_plans_16-1.8-3PGDG.rhel10.x86_64.rpm
`pg_store_plans_16`	1.8	`el10.aarch64`	pgdg	46.0 KiB	pg_store_plans_16-1.8-3PGDG.rhel10.aarch64.rpm
`postgresql-16-pg-store-plan`	1.8	`d12.x86_64`	pigsty	119.0 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~bookworm_amd64.deb
`postgresql-16-pg-store-plan`	1.8	`d12.aarch64`	pigsty	116.2 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~bookworm_arm64.deb
`postgresql-16-pg-store-plan`	1.8	`u22.x86_64`	pigsty	128.7 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~jammy_amd64.deb
`postgresql-16-pg-store-plan`	1.8	`u22.aarch64`	pigsty	127.0 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~jammy_arm64.deb
`postgresql-16-pg-store-plan`	1.8	`u24.x86_64`	pigsty	113.9 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~noble_amd64.deb
`postgresql-16-pg-store-plan`	1.8	`u24.aarch64`	pigsty	112.6 KiB	postgresql-16-pg-store-plan_1.8-2PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_15`	1.8	`el8.x86_64`	pigsty	41.7 KiB	pg_store_plans_15-1.8-2PIGSTY.el8.x86_64.rpm
`pg_store_plans_15`	1.8	`el8.x86_64`	pgdg	46.3 KiB	pg_store_plans_15-1.8-1PGDG.rhel8.x86_64.rpm
`pg_store_plans_15`	1.7	`el8.x86_64`	pgdg	46.3 KiB	pg_store_plans_15-1.7-1PGDG.rhel8.x86_64.rpm
`pg_store_plans_15`	1.8	`el8.aarch64`	pigsty	40.3 KiB	pg_store_plans_15-1.8-2PIGSTY.el8.aarch64.rpm
`pg_store_plans_15`	1.8	`el8.aarch64`	pgdg	45.0 KiB	pg_store_plans_15-1.8-1PGDG.rhel8.aarch64.rpm
`pg_store_plans_15`	1.7	`el8.aarch64`	pgdg	44.8 KiB	pg_store_plans_15-1.7-1PGDG.rhel8.aarch64.rpm
`pg_store_plans_15`	1.8	`el9.x86_64`	pigsty	43.9 KiB	pg_store_plans_15-1.8-2PIGSTY.el9.x86_64.rpm
`pg_store_plans_15`	1.8	`el9.x86_64`	pgdg	47.2 KiB	pg_store_plans_15-1.8-1PGDG.rhel9.x86_64.rpm
`pg_store_plans_15`	1.7	`el9.x86_64`	pgdg	47.3 KiB	pg_store_plans_15-1.7-1PGDG.rhel9.x86_64.rpm
`pg_store_plans_15`	1.8	`el9.aarch64`	pigsty	43.1 KiB	pg_store_plans_15-1.8-2PIGSTY.el9.aarch64.rpm
`pg_store_plans_15`	1.8	`el9.aarch64`	pgdg	46.1 KiB	pg_store_plans_15-1.8-1PGDG.rhel9.aarch64.rpm
`pg_store_plans_15`	1.7	`el9.aarch64`	pgdg	45.9 KiB	pg_store_plans_15-1.7-1PGDG.rhel9.aarch64.rpm
`pg_store_plans_15`	1.8	`el10.x86_64`	pgdg	48.3 KiB	pg_store_plans_15-1.8-3PGDG.rhel10.x86_64.rpm
`pg_store_plans_15`	1.8	`el10.aarch64`	pgdg	47.2 KiB	pg_store_plans_15-1.8-3PGDG.rhel10.aarch64.rpm
`postgresql-15-pg-store-plan`	1.8	`d12.x86_64`	pigsty	120.6 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~bookworm_amd64.deb
`postgresql-15-pg-store-plan`	1.8	`d12.aarch64`	pigsty	117.5 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~bookworm_arm64.deb
`postgresql-15-pg-store-plan`	1.8	`u22.x86_64`	pigsty	130.6 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~jammy_amd64.deb
`postgresql-15-pg-store-plan`	1.8	`u22.aarch64`	pigsty	128.8 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~jammy_arm64.deb
`postgresql-15-pg-store-plan`	1.8	`u24.x86_64`	pigsty	115.8 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~noble_amd64.deb
`postgresql-15-pg-store-plan`	1.8	`u24.aarch64`	pigsty	114.4 KiB	postgresql-15-pg-store-plan_1.8-2PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_14`	1.8	`el8.x86_64`	pigsty	41.6 KiB	pg_store_plans_14-1.8-2PIGSTY.el8.x86_64.rpm
`pg_store_plans_14`	1.8	`el8.aarch64`	pigsty	40.2 KiB	pg_store_plans_14-1.8-2PIGSTY.el8.aarch64.rpm
`pg_store_plans_14`	1.8	`el9.x86_64`	pigsty	43.6 KiB	pg_store_plans_14-1.8-2PIGSTY.el9.x86_64.rpm
`pg_store_plans_14`	1.8	`el9.aarch64`	pigsty	43.0 KiB	pg_store_plans_14-1.8-2PIGSTY.el9.aarch64.rpm
`postgresql-14-pg-store-plan`	1.8	`d12.x86_64`	pigsty	120.2 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~bookworm_amd64.deb
`postgresql-14-pg-store-plan`	1.8	`d12.aarch64`	pigsty	117.1 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~bookworm_arm64.deb
`postgresql-14-pg-store-plan`	1.8	`u22.x86_64`	pigsty	130.0 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~jammy_amd64.deb
`postgresql-14-pg-store-plan`	1.8	`u22.aarch64`	pigsty	128.2 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~jammy_arm64.deb
`postgresql-14-pg-store-plan`	1.8	`u24.x86_64`	pigsty	115.5 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~noble_amd64.deb
`postgresql-14-pg-store-plan`	1.8	`u24.aarch64`	pigsty	114.4 KiB	postgresql-14-pg-store-plan_1.8-2PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_store_plans_13`	1.8	`el8.x86_64`	pigsty	41.6 KiB	pg_store_plans_13-1.8-2PIGSTY.el8.x86_64.rpm
`pg_store_plans_13`	1.8	`el8.aarch64`	pigsty	40.2 KiB	pg_store_plans_13-1.8-2PIGSTY.el8.aarch64.rpm
`pg_store_plans_13`	1.8	`el9.x86_64`	pigsty	43.5 KiB	pg_store_plans_13-1.8-2PIGSTY.el9.x86_64.rpm
`pg_store_plans_13`	1.8	`el9.aarch64`	pigsty	42.8 KiB	pg_store_plans_13-1.8-2PIGSTY.el9.aarch64.rpm
`postgresql-13-pg-store-plan`	1.8	`d12.x86_64`	pigsty	119.6 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~bookworm_amd64.deb
`postgresql-13-pg-store-plan`	1.8	`d12.aarch64`	pigsty	116.5 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~bookworm_arm64.deb
`postgresql-13-pg-store-plan`	1.8	`u22.x86_64`	pigsty	129.4 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~jammy_amd64.deb
`postgresql-13-pg-store-plan`	1.8	`u22.aarch64`	pigsty	127.8 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~jammy_arm64.deb
`postgresql-13-pg-store-plan`	1.8	`u24.x86_64`	pigsty	115.3 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~noble_amd64.deb
`postgresql-13-pg-store-plan`	1.8	`u24.aarch64`	pigsty	113.4 KiB	postgresql-13-pg-store-plan_1.8-2PIGSTY~noble_arm64.deb

Source

Repository

github.com/ossc-db/pg_store_plans

Source Tarball

pg_store_plans-1.9.tar.gz

pig build get pg_store_plans; # get pg_store_plans source code
pig build dep pg_store_plans; # install build dependencies
pig build pkg pg_store_plans; # build extension rpm or deb
pig build ext pg_store_plans; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install pg_store_plans; # install by extension name, for the current active PG version
pig ext install pg_store_plans; # install via package alias, for the active PG version
pig ext install pg_store_plans -v 18;   # install for PG 18
pig ext install pg_store_plans -v 17;   # install for PG 17
pig ext install pg_store_plans -v 16;   # install for PG 16
pig ext install pg_store_plans -v 15;   # install for PG 15
pig ext install pg_store_plans -v 14;   # install for PG 14
pig ext install pg_store_plans -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_store_plans;

Last updated on 2025-11-02

pg_qualstats pg_track_settings