plan_filter

plan_filter

pg_plan_filter : filter statements by their execution plans.

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
2850
plan_filter
pg_plan_filter
0.0.1
FEAT
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--sL---
No
Yes
Yes
No
no
no
Relationships
See Also
age
hll
rum
pg_graphql
pg_jsonschema
jsquery
pg_hint_plan
hypopg

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
PIGSTY
0.0.1
18
17
16
15
14
13
pg_plan_filter-
RPM
PIGSTY
0.0.1
18
17
16
15
14
13
pg_plan_filter_$v*-
DEB
PIGSTY
0.0.1
18
17
16
15
14
13
postgresql-$v-pg-plan-filter-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el8.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el9.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el9.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el10.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el10.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d12.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d12.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d13.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d13.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u22.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u22.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u24.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u24.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PackageVersionOSORGSIZEFile URL
pg_plan_filter_180.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_180.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_180.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_180.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_180.0.1el10.x86_64pigsty10.4 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_180.0.1el10.aarch64pigsty10.6 KiBpg_plan_filter_18-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-18-pg-plan-filter0.0.1d12.x86_64pigsty9.9 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-plan-filter0.0.1d12.aarch64pigsty10.1 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-plan-filter0.0.1d13.x86_64pigsty9.9 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-plan-filter0.0.1u22.x86_64pigsty10.1 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-plan-filter0.0.1u22.aarch64pigsty10.1 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-plan-filter0.0.1u24.x86_64pigsty10.1 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-18-pg-plan-filter0.0.1u24.aarch64pigsty10.2 KiBpostgresql-18-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_plan_filter_170.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_170.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_170.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_170.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_170.0.1el10.x86_64pigsty10.5 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_170.0.1el10.aarch64pigsty10.7 KiBpg_plan_filter_17-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-17-pg-plan-filter0.0.1d12.x86_64pigsty9.9 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-plan-filter0.0.1d12.aarch64pigsty10.1 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-plan-filter0.0.1d13.x86_64pigsty9.9 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-plan-filter0.0.1u22.x86_64pigsty10.6 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-plan-filter0.0.1u22.aarch64pigsty10.6 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-plan-filter0.0.1u24.x86_64pigsty10.2 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-17-pg-plan-filter0.0.1u24.aarch64pigsty10.3 KiBpostgresql-17-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_plan_filter_160.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_160.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_160.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_160.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_160.0.1el10.x86_64pigsty10.5 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_160.0.1el10.aarch64pigsty10.7 KiBpg_plan_filter_16-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-16-pg-plan-filter0.0.1d12.x86_64pigsty9.9 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-plan-filter0.0.1d12.aarch64pigsty10.0 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-plan-filter0.0.1d13.x86_64pigsty9.9 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-plan-filter0.0.1u22.x86_64pigsty10.6 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-plan-filter0.0.1u22.aarch64pigsty10.6 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-plan-filter0.0.1u24.x86_64pigsty10.2 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-16-pg-plan-filter0.0.1u24.aarch64pigsty10.3 KiBpostgresql-16-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_plan_filter_150.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_150.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_150.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_150.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_150.0.1el10.x86_64pigsty10.5 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_150.0.1el10.aarch64pigsty10.7 KiBpg_plan_filter_15-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-15-pg-plan-filter0.0.1d12.x86_64pigsty9.9 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-plan-filter0.0.1d12.aarch64pigsty10.1 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-plan-filter0.0.1d13.x86_64pigsty9.9 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-plan-filter0.0.1u22.x86_64pigsty10.5 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-plan-filter0.0.1u22.aarch64pigsty10.6 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-plan-filter0.0.1u24.x86_64pigsty10.2 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-15-pg-plan-filter0.0.1u24.aarch64pigsty10.3 KiBpostgresql-15-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_plan_filter_140.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_140.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_140.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_140.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_140.0.1el10.x86_64pigsty10.5 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_140.0.1el10.aarch64pigsty10.7 KiBpg_plan_filter_14-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-14-pg-plan-filter0.0.1d12.x86_64pigsty9.9 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-plan-filter0.0.1d12.aarch64pigsty10.0 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-plan-filter0.0.1d13.x86_64pigsty9.8 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-plan-filter0.0.1u22.x86_64pigsty10.5 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-plan-filter0.0.1u22.aarch64pigsty10.6 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-plan-filter0.0.1u24.x86_64pigsty10.1 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-14-pg-plan-filter0.0.1u24.aarch64pigsty10.2 KiBpostgresql-14-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_plan_filter_130.0.1el8.x86_64pigsty10.8 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el8.x86_64.rpm
pg_plan_filter_130.0.1el8.aarch64pigsty11.0 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el8.aarch64.rpm
pg_plan_filter_130.0.1el9.x86_64pigsty10.5 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el9.x86_64.rpm
pg_plan_filter_130.0.1el9.aarch64pigsty10.5 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el9.aarch64.rpm
pg_plan_filter_130.0.1el10.x86_64pigsty10.5 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el10.x86_64.rpm
pg_plan_filter_130.0.1el10.aarch64pigsty10.7 KiBpg_plan_filter_13-0.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-13-pg-plan-filter0.0.1d12.x86_64pigsty9.8 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-plan-filter0.0.1d12.aarch64pigsty10.0 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-plan-filter0.0.1d13.x86_64pigsty9.8 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~trixie_amd64.deb
postgresql-13-pg-plan-filter0.0.1d13.aarch64pigsty10.1 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~trixie_arm64.deb
postgresql-13-pg-plan-filter0.0.1u22.x86_64pigsty10.4 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-plan-filter0.0.1u22.aarch64pigsty10.5 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-plan-filter0.0.1u24.x86_64pigsty10.1 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-13-pg-plan-filter0.0.1u24.aarch64pigsty10.2 KiBpostgresql-13-pg-plan-filter_0.0.1-1PIGSTY~noble_arm64.deb

Source

pig build pkg pg_plan_filter;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_plan_filter;		# install via package name, for the active PG version
pig install plan_filter;		# install by extension name, for the current active PG version

pig install plan_filter -v 18;   # install for PG 18
pig install plan_filter -v 17;   # install for PG 17
pig install plan_filter -v 16;   # install for PG 16
pig install plan_filter -v 15;   # install for PG 15
pig install plan_filter -v 14;   # install for PG 14
pig install plan_filter -v 13;   # install for PG 13

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'plan_filter';

This extension does not need CREATE EXTENSION DDL command

Last updated on