Extensions
pg_show_plans

pg_show_plans

pg_show_plans : show query plans of all currently running SQL statements

Overview

ID Extension Package Version Category License Language
6210
pg_show_plans
pg_show_plans
 2.1.7
STAT
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_store_plans
explain_ui
auto_explain
pg_stat_statements
pg_hint_plan
pg_stat_monitor
pg_qualstats
pre_prepare

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 2.1.7
18
17
16
15
14
13
 pg_show_plans -
RPM
PGDG
 2.1.7
18
17
16
15
14
13
 pg_show_plans_$v* -
DEB
PGDG
 2.1.7
18
17
16
15
14
13
 postgresql-$v-show-plans -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
el8.aarch64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
el9.x86_64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
el9.aarch64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
el10.x86_64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
el10.aarch64
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
PGDG 2.1.6
d12.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
d12.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
d13.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
d13.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
u22.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
u22.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
u24.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
u24.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.2
Package Version OS ORG SIZE File URL
pg_show_plans_18 2.1.6 el8.x86_64 pgdg 19.2 KiB pg_show_plans_18-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_18 2.1.6 el8.aarch64 pgdg 19.1 KiB pg_show_plans_18-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_18 2.1.6 el9.x86_64 pgdg 19.7 KiB pg_show_plans_18-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_18 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_18-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_18 2.1.6 el10.x86_64 pgdg 20.0 KiB pg_show_plans_18-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_18 2.1.6 el10.aarch64 pgdg 20.1 KiB pg_show_plans_18-2.1.6-1PGDG.rhel10.aarch64.rpm
postgresql-18-show-plans 2.1.7 d12.x86_64 pgdg 23.2 KiB postgresql-18-show-plans_2.1.7-1.pgdg12+1_amd64.deb
postgresql-18-show-plans 2.1.7 d12.aarch64 pgdg 23.0 KiB postgresql-18-show-plans_2.1.7-1.pgdg12+1_arm64.deb
postgresql-18-show-plans 2.1.7 d13.x86_64 pgdg 23.2 KiB postgresql-18-show-plans_2.1.7-1.pgdg13+1_amd64.deb
postgresql-18-show-plans 2.1.7 d13.aarch64 pgdg 23.1 KiB postgresql-18-show-plans_2.1.7-1.pgdg13+1_arm64.deb
postgresql-18-show-plans 2.1.7 u22.x86_64 pgdg 23.6 KiB postgresql-18-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb
postgresql-18-show-plans 2.1.7 u22.aarch64 pgdg 23.0 KiB postgresql-18-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb
postgresql-18-show-plans 2.1.7 u24.x86_64 pgdg 23.3 KiB postgresql-18-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb
postgresql-18-show-plans 2.1.7 u24.aarch64 pgdg 23.1 KiB postgresql-18-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_show_plans_17 2.1.6 el8.x86_64 pgdg 19.2 KiB pg_show_plans_17-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_17 2.1.3 el8.x86_64 pgdg 19.0 KiB pg_show_plans_17-2.1.3-1PGDG.rhel8.x86_64.rpm
pg_show_plans_17 2.1.2 el8.x86_64 pgdg 18.8 KiB pg_show_plans_17-2.1.2-1PGDG.rhel8.x86_64.rpm
pg_show_plans_17 2.1.6 el8.aarch64 pgdg 19.1 KiB pg_show_plans_17-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_17 2.1.3 el8.aarch64 pgdg 18.9 KiB pg_show_plans_17-2.1.3-1PGDG.rhel8.aarch64.rpm
pg_show_plans_17 2.1.2 el8.aarch64 pgdg 18.7 KiB pg_show_plans_17-2.1.2-1PGDG.rhel8.aarch64.rpm
pg_show_plans_17 2.1.6 el9.x86_64 pgdg 19.7 KiB pg_show_plans_17-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_17 2.1.3 el9.x86_64 pgdg 19.5 KiB pg_show_plans_17-2.1.3-1PGDG.rhel9.x86_64.rpm
pg_show_plans_17 2.1.2 el9.x86_64 pgdg 19.3 KiB pg_show_plans_17-2.1.2-1PGDG.rhel9.x86_64.rpm
pg_show_plans_17 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_17-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_17 2.1.3 el9.aarch64 pgdg 19.4 KiB pg_show_plans_17-2.1.3-1PGDG.rhel9.aarch64.rpm
pg_show_plans_17 2.1.2 el9.aarch64 pgdg 19.2 KiB pg_show_plans_17-2.1.2-1PGDG.rhel9.aarch64.rpm
pg_show_plans_17 2.1.6 el10.x86_64 pgdg 20.1 KiB pg_show_plans_17-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_17 2.1.3 el10.x86_64 pgdg 19.9 KiB pg_show_plans_17-2.1.3-1PGDG.rhel10.x86_64.rpm
pg_show_plans_17 2.1.6 el10.aarch64 pgdg 20.1 KiB pg_show_plans_17-2.1.6-1PGDG.rhel10.aarch64.rpm
pg_show_plans_17 2.1.3 el10.aarch64 pgdg 20.0 KiB pg_show_plans_17-2.1.3-1PGDG.rhel10.aarch64.rpm
postgresql-17-show-plans 2.1.7 d12.x86_64 pgdg 23.3 KiB postgresql-17-show-plans_2.1.7-1.pgdg12+1_amd64.deb
postgresql-17-show-plans 2.1.7 d12.aarch64 pgdg 23.0 KiB postgresql-17-show-plans_2.1.7-1.pgdg12+1_arm64.deb
postgresql-17-show-plans 2.1.7 d13.x86_64 pgdg 23.3 KiB postgresql-17-show-plans_2.1.7-1.pgdg13+1_amd64.deb
postgresql-17-show-plans 2.1.7 d13.aarch64 pgdg 23.0 KiB postgresql-17-show-plans_2.1.7-1.pgdg13+1_arm64.deb
postgresql-17-show-plans 2.1.7 u22.x86_64 pgdg 27.1 KiB postgresql-17-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb
postgresql-17-show-plans 2.1.7 u22.aarch64 pgdg 26.3 KiB postgresql-17-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb
postgresql-17-show-plans 2.1.7 u24.x86_64 pgdg 23.4 KiB postgresql-17-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb
postgresql-17-show-plans 2.1.7 u24.aarch64 pgdg 23.0 KiB postgresql-17-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_show_plans_16 2.1.6 el8.x86_64 pgdg 19.2 KiB pg_show_plans_16-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_16 2.1.3 el8.x86_64 pgdg 19.0 KiB pg_show_plans_16-2.1.3-1PGDG.rhel8.x86_64.rpm
pg_show_plans_16 2.1.2 el8.x86_64 pgdg 18.8 KiB pg_show_plans_16-2.1.2-1PGDG.rhel8.x86_64.rpm
pg_show_plans_16 2.1.0 el8.x86_64 pgdg 18.6 KiB pg_show_plans_16-2.1.0-1PGDG.rhel8.x86_64.rpm
pg_show_plans_16 2.1.6 el8.aarch64 pgdg 19.1 KiB pg_show_plans_16-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_16 2.1.3 el8.aarch64 pgdg 18.9 KiB pg_show_plans_16-2.1.3-1PGDG.rhel8.aarch64.rpm
pg_show_plans_16 2.1.2 el8.aarch64 pgdg 18.7 KiB pg_show_plans_16-2.1.2-1PGDG.rhel8.aarch64.rpm
pg_show_plans_16 2.1.0 el8.aarch64 pgdg 18.5 KiB pg_show_plans_16-2.1.0-1PGDG.rhel8.aarch64.rpm
pg_show_plans_16 2.1.6 el9.x86_64 pgdg 19.7 KiB pg_show_plans_16-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_16 2.1.3 el9.x86_64 pgdg 19.5 KiB pg_show_plans_16-2.1.3-1PGDG.rhel9.x86_64.rpm
pg_show_plans_16 2.1.2 el9.x86_64 pgdg 19.3 KiB pg_show_plans_16-2.1.2-1PGDG.rhel9.x86_64.rpm
pg_show_plans_16 2.1.0 el9.x86_64 pgdg 19.0 KiB pg_show_plans_16-2.1.0-1PGDG.rhel9.x86_64.rpm
pg_show_plans_16 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_16-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_16 2.1.3 el9.aarch64 pgdg 19.4 KiB pg_show_plans_16-2.1.3-1PGDG.rhel9.aarch64.rpm
pg_show_plans_16 2.1.2 el9.aarch64 pgdg 19.2 KiB pg_show_plans_16-2.1.2-1PGDG.rhel9.aarch64.rpm
pg_show_plans_16 2.1.0 el9.aarch64 pgdg 19.0 KiB pg_show_plans_16-2.1.0-1PGDG.rhel9.aarch64.rpm
pg_show_plans_16 2.1.6 el10.x86_64 pgdg 20.1 KiB pg_show_plans_16-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_16 2.1.3 el10.x86_64 pgdg 19.9 KiB pg_show_plans_16-2.1.3-1PGDG.rhel10.x86_64.rpm
pg_show_plans_16 2.1.6 el10.aarch64 pgdg 20.1 KiB pg_show_plans_16-2.1.6-1PGDG.rhel10.aarch64.rpm
pg_show_plans_16 2.1.3 el10.aarch64 pgdg 19.9 KiB pg_show_plans_16-2.1.3-1PGDG.rhel10.aarch64.rpm
postgresql-16-show-plans 2.1.7 d12.x86_64 pgdg 23.3 KiB postgresql-16-show-plans_2.1.7-1.pgdg12+1_amd64.deb
postgresql-16-show-plans 2.1.7 d12.aarch64 pgdg 23.0 KiB postgresql-16-show-plans_2.1.7-1.pgdg12+1_arm64.deb
postgresql-16-show-plans 2.1.7 d13.x86_64 pgdg 23.3 KiB postgresql-16-show-plans_2.1.7-1.pgdg13+1_amd64.deb
postgresql-16-show-plans 2.1.7 d13.aarch64 pgdg 23.0 KiB postgresql-16-show-plans_2.1.7-1.pgdg13+1_arm64.deb
postgresql-16-show-plans 2.1.7 u22.x86_64 pgdg 27.1 KiB postgresql-16-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb
postgresql-16-show-plans 2.1.7 u22.aarch64 pgdg 26.2 KiB postgresql-16-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb
postgresql-16-show-plans 2.1.7 u24.x86_64 pgdg 23.4 KiB postgresql-16-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb
postgresql-16-show-plans 2.1.7 u24.aarch64 pgdg 23.0 KiB postgresql-16-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_show_plans_15 2.1.6 el8.x86_64 pgdg 19.2 KiB pg_show_plans_15-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_15 2.1.3 el8.x86_64 pgdg 19.0 KiB pg_show_plans_15-2.1.3-1PGDG.rhel8.x86_64.rpm
pg_show_plans_15 2.1.2 el8.x86_64 pgdg 18.8 KiB pg_show_plans_15-2.1.2-1PGDG.rhel8.x86_64.rpm
pg_show_plans_15 2.1.0 el8.x86_64 pgdg 18.6 KiB pg_show_plans_15-2.1.0-1PGDG.rhel8.x86_64.rpm
pg_show_plans_15 2.1.6 el8.aarch64 pgdg 19.1 KiB pg_show_plans_15-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_15 2.1.3 el8.aarch64 pgdg 18.9 KiB pg_show_plans_15-2.1.3-1PGDG.rhel8.aarch64.rpm
pg_show_plans_15 2.1.2 el8.aarch64 pgdg 18.7 KiB pg_show_plans_15-2.1.2-1PGDG.rhel8.aarch64.rpm
pg_show_plans_15 2.1.0 el8.aarch64 pgdg 18.5 KiB pg_show_plans_15-2.1.0-1PGDG.rhel8.aarch64.rpm
pg_show_plans_15 2.1.6 el9.x86_64 pgdg 19.7 KiB pg_show_plans_15-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_15 2.1.3 el9.x86_64 pgdg 19.5 KiB pg_show_plans_15-2.1.3-1PGDG.rhel9.x86_64.rpm
pg_show_plans_15 2.1.2 el9.x86_64 pgdg 19.3 KiB pg_show_plans_15-2.1.2-1PGDG.rhel9.x86_64.rpm
pg_show_plans_15 2.1.0 el9.x86_64 pgdg 19.0 KiB pg_show_plans_15-2.1.0-1PGDG.rhel9.x86_64.rpm
pg_show_plans_15 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_15-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_15 2.1.3 el9.aarch64 pgdg 19.4 KiB pg_show_plans_15-2.1.3-1PGDG.rhel9.aarch64.rpm
pg_show_plans_15 2.1.2 el9.aarch64 pgdg 19.2 KiB pg_show_plans_15-2.1.2-1PGDG.rhel9.aarch64.rpm
pg_show_plans_15 2.1.0 el9.aarch64 pgdg 19.0 KiB pg_show_plans_15-2.1.0-1PGDG.rhel9.aarch64.rpm
pg_show_plans_15 2.1.6 el10.x86_64 pgdg 20.1 KiB pg_show_plans_15-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_15 2.1.3 el10.x86_64 pgdg 19.9 KiB pg_show_plans_15-2.1.3-1PGDG.rhel10.x86_64.rpm
pg_show_plans_15 2.1.6 el10.aarch64 pgdg 20.1 KiB pg_show_plans_15-2.1.6-1PGDG.rhel10.aarch64.rpm
pg_show_plans_15 2.1.3 el10.aarch64 pgdg 19.9 KiB pg_show_plans_15-2.1.3-1PGDG.rhel10.aarch64.rpm
postgresql-15-show-plans 2.1.7 d12.x86_64 pgdg 23.3 KiB postgresql-15-show-plans_2.1.7-1.pgdg12+1_amd64.deb
postgresql-15-show-plans 2.1.7 d12.aarch64 pgdg 23.0 KiB postgresql-15-show-plans_2.1.7-1.pgdg12+1_arm64.deb
postgresql-15-show-plans 2.1.7 d13.x86_64 pgdg 23.3 KiB postgresql-15-show-plans_2.1.7-1.pgdg13+1_amd64.deb
postgresql-15-show-plans 2.1.7 d13.aarch64 pgdg 23.1 KiB postgresql-15-show-plans_2.1.7-1.pgdg13+1_arm64.deb
postgresql-15-show-plans 2.1.7 u22.x86_64 pgdg 27.0 KiB postgresql-15-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb
postgresql-15-show-plans 2.1.7 u22.aarch64 pgdg 26.3 KiB postgresql-15-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb
postgresql-15-show-plans 2.1.7 u24.x86_64 pgdg 23.4 KiB postgresql-15-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb
postgresql-15-show-plans 2.1.7 u24.aarch64 pgdg 23.0 KiB postgresql-15-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_show_plans_14 2.1.6 el8.x86_64 pgdg 19.1 KiB pg_show_plans_14-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_14 2.1.3 el8.x86_64 pgdg 19.0 KiB pg_show_plans_14-2.1.3-1PGDG.rhel8.x86_64.rpm
pg_show_plans_14 2.1.2 el8.x86_64 pgdg 18.7 KiB pg_show_plans_14-2.1.2-1PGDG.rhel8.x86_64.rpm
pg_show_plans_14 2.1.0 el8.x86_64 pgdg 18.5 KiB pg_show_plans_14-2.1.0-1PGDG.rhel8.x86_64.rpm
pg_show_plans_14 2.1.6 el8.aarch64 pgdg 19.0 KiB pg_show_plans_14-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_14 2.1.3 el8.aarch64 pgdg 18.8 KiB pg_show_plans_14-2.1.3-1PGDG.rhel8.aarch64.rpm
pg_show_plans_14 2.1.2 el8.aarch64 pgdg 18.6 KiB pg_show_plans_14-2.1.2-1PGDG.rhel8.aarch64.rpm
pg_show_plans_14 2.1.0 el8.aarch64 pgdg 18.4 KiB pg_show_plans_14-2.1.0-1PGDG.rhel8.aarch64.rpm
pg_show_plans_14 2.1.6 el9.x86_64 pgdg 19.6 KiB pg_show_plans_14-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_14 2.1.3 el9.x86_64 pgdg 19.4 KiB pg_show_plans_14-2.1.3-1PGDG.rhel9.x86_64.rpm
pg_show_plans_14 2.1.2 el9.x86_64 pgdg 19.2 KiB pg_show_plans_14-2.1.2-1PGDG.rhel9.x86_64.rpm
pg_show_plans_14 2.1.0 el9.x86_64 pgdg 19.0 KiB pg_show_plans_14-2.1.0-1PGDG.rhel9.x86_64.rpm
pg_show_plans_14 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_14-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_14 2.1.3 el9.aarch64 pgdg 19.3 KiB pg_show_plans_14-2.1.3-1PGDG.rhel9.aarch64.rpm
pg_show_plans_14 2.1.2 el9.aarch64 pgdg 19.1 KiB pg_show_plans_14-2.1.2-1PGDG.rhel9.aarch64.rpm
pg_show_plans_14 2.1.0 el9.aarch64 pgdg 18.9 KiB pg_show_plans_14-2.1.0-1PGDG.rhel9.aarch64.rpm
pg_show_plans_14 2.1.6 el10.x86_64 pgdg 20.0 KiB pg_show_plans_14-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_14 2.1.3 el10.x86_64 pgdg 19.8 KiB pg_show_plans_14-2.1.3-1PGDG.rhel10.x86_64.rpm
pg_show_plans_14 2.1.6 el10.aarch64 pgdg 20.0 KiB pg_show_plans_14-2.1.6-1PGDG.rhel10.aarch64.rpm
pg_show_plans_14 2.1.3 el10.aarch64 pgdg 19.8 KiB pg_show_plans_14-2.1.3-1PGDG.rhel10.aarch64.rpm
postgresql-14-show-plans 2.1.7 d12.x86_64 pgdg 23.1 KiB postgresql-14-show-plans_2.1.7-1.pgdg12+1_amd64.deb
postgresql-14-show-plans 2.1.7 d12.aarch64 pgdg 22.8 KiB postgresql-14-show-plans_2.1.7-1.pgdg12+1_arm64.deb
postgresql-14-show-plans 2.1.7 d13.x86_64 pgdg 23.1 KiB postgresql-14-show-plans_2.1.7-1.pgdg13+1_amd64.deb
postgresql-14-show-plans 2.1.7 d13.aarch64 pgdg 22.9 KiB postgresql-14-show-plans_2.1.7-1.pgdg13+1_arm64.deb
postgresql-14-show-plans 2.1.7 u22.x86_64 pgdg 26.8 KiB postgresql-14-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb
postgresql-14-show-plans 2.1.7 u22.aarch64 pgdg 26.0 KiB postgresql-14-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb
postgresql-14-show-plans 2.1.7 u24.x86_64 pgdg 23.2 KiB postgresql-14-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb
postgresql-14-show-plans 2.1.7 u24.aarch64 pgdg 22.9 KiB postgresql-14-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_show_plans_13 2.1.6 el8.x86_64 pgdg 19.1 KiB pg_show_plans_13-2.1.6-1PGDG.rhel8.x86_64.rpm
pg_show_plans_13 2.1.3 el8.x86_64 pgdg 18.9 KiB pg_show_plans_13-2.1.3-1PGDG.rhel8.x86_64.rpm
pg_show_plans_13 2.1.2 el8.x86_64 pgdg 18.6 KiB pg_show_plans_13-2.1.2-1PGDG.rhel8.x86_64.rpm
pg_show_plans_13 2.1.0 el8.x86_64 pgdg 18.4 KiB pg_show_plans_13-2.1.0-1PGDG.rhel8.x86_64.rpm
pg_show_plans_13 2.1.6 el8.aarch64 pgdg 19.0 KiB pg_show_plans_13-2.1.6-1PGDG.rhel8.aarch64.rpm
pg_show_plans_13 2.1.3 el8.aarch64 pgdg 18.8 KiB pg_show_plans_13-2.1.3-1PGDG.rhel8.aarch64.rpm
pg_show_plans_13 2.1.2 el8.aarch64 pgdg 18.6 KiB pg_show_plans_13-2.1.2-1PGDG.rhel8.aarch64.rpm
pg_show_plans_13 2.1.0 el8.aarch64 pgdg 18.4 KiB pg_show_plans_13-2.1.0-1PGDG.rhel8.aarch64.rpm
pg_show_plans_13 2.1.6 el9.x86_64 pgdg 19.6 KiB pg_show_plans_13-2.1.6-1PGDG.rhel9.x86_64.rpm
pg_show_plans_13 2.1.3 el9.x86_64 pgdg 19.4 KiB pg_show_plans_13-2.1.3-1PGDG.rhel9.x86_64.rpm
pg_show_plans_13 2.1.2 el9.x86_64 pgdg 19.2 KiB pg_show_plans_13-2.1.2-1PGDG.rhel9.x86_64.rpm
pg_show_plans_13 2.1.0 el9.x86_64 pgdg 19.0 KiB pg_show_plans_13-2.1.0-1PGDG.rhel9.x86_64.rpm
pg_show_plans_13 2.1.6 el9.aarch64 pgdg 19.4 KiB pg_show_plans_13-2.1.6-1PGDG.rhel9.aarch64.rpm
pg_show_plans_13 2.1.3 el9.aarch64 pgdg 19.3 KiB pg_show_plans_13-2.1.3-1PGDG.rhel9.aarch64.rpm
pg_show_plans_13 2.1.2 el9.aarch64 pgdg 19.1 KiB pg_show_plans_13-2.1.2-1PGDG.rhel9.aarch64.rpm
pg_show_plans_13 2.1.0 el9.aarch64 pgdg 18.9 KiB pg_show_plans_13-2.1.0-1PGDG.rhel9.aarch64.rpm
pg_show_plans_13 2.1.6 el10.x86_64 pgdg 20.0 KiB pg_show_plans_13-2.1.6-1PGDG.rhel10.x86_64.rpm
pg_show_plans_13 2.1.3 el10.x86_64 pgdg 19.8 KiB pg_show_plans_13-2.1.3-1PGDG.rhel10.x86_64.rpm
pg_show_plans_13 2.1.6 el10.aarch64 pgdg 20.0 KiB pg_show_plans_13-2.1.6-1PGDG.rhel10.aarch64.rpm
pg_show_plans_13 2.1.3 el10.aarch64 pgdg 19.8 KiB pg_show_plans_13-2.1.3-1PGDG.rhel10.aarch64.rpm
postgresql-13-show-plans 2.1.2 d12.x86_64 pgdg 26.1 KiB postgresql-13-show-plans_2.1.2-2.pgdg120+1_amd64.deb
postgresql-13-show-plans 2.1.2 d12.aarch64 pgdg 25.6 KiB postgresql-13-show-plans_2.1.2-2.pgdg120+1_arm64.deb
postgresql-13-show-plans 2.1.2 d13.x86_64 pgdg 26.2 KiB postgresql-13-show-plans_2.1.2-2.pgdg130+1_amd64.deb
postgresql-13-show-plans 2.1.2 d13.aarch64 pgdg 25.6 KiB postgresql-13-show-plans_2.1.2-2.pgdg130+1_arm64.deb
postgresql-13-show-plans 2.1.2 u22.x86_64 pgdg 26.4 KiB postgresql-13-show-plans_2.1.2-2.pgdg22.04+1_amd64.deb
postgresql-13-show-plans 2.1.2 u22.aarch64 pgdg 25.5 KiB postgresql-13-show-plans_2.1.2-2.pgdg22.04+1_arm64.deb
postgresql-13-show-plans 2.1.2 u24.x86_64 pgdg 23.1 KiB postgresql-13-show-plans_2.1.2-2.pgdg24.04+1_amd64.deb
postgresql-13-show-plans 2.1.2 u24.aarch64 pgdg 22.5 KiB postgresql-13-show-plans_2.1.2-2.pgdg24.04+1_arm64.deb

Source

Repository
github.com/cybertec-postgresql/pg_show_plans
 Source Tarball
pg_show_plans-2.1.7.tar.gz
 
pig build pkg pg_show_plans;		# build spec not ready

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install pg_show_plans;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION pg_show_plans;
Last updated on
pg_tracingpg_stat_kcache