pg_show_plans

show query plans of all currently running SQL statements

Overview

Package	Version	Category	License	Language
`pg_show_plans`	`2.1.8`	STAT	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
6210	`pg_show_plans`	No	Yes	Yes	Yes	No	Yes	-

Related	`pg_stat_plans` `auto_explain` `explain_ui` `pg_stat_statements` `pg_store_plans` `pg_overexplain` `pg_qualstats` `online_advisor` `pgrowlocks` `pg_wait_sampling`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PGDG	`2.1.8`	1817161514	`pg_show_plans`	-
RPM	PGDG	`2.1.8`	1817161514	`pg_show_plans_$v`	-
DEB	PGDG	`2.1.8`	1817161514	`postgresql-$v-show-plans`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 2.1.8 el8.x86_64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel8.10.x86_64.rpm PGDG · 2.1.8 · 19.6KiB pg_show_plans_18-2.1.6-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.6 · 19.2KiB	PGDG 2.1.8 el8.x86_64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel8.10.x86_64.rpm PGDG · 2.1.8 · 19.6KiB pg_show_plans_17-2.1.6-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.6 · 19.2KiB pg_show_plans_17-2.1.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.3 · 19.0KiB pg_show_plans_17-2.1.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.2 · 18.8KiB	PGDG 2.1.8 el8.x86_64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel8.10.x86_64.rpm PGDG · 2.1.8 · 19.6KiB pg_show_plans_16-2.1.6-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.6 · 19.2KiB pg_show_plans_16-2.1.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.3 · 19.0KiB pg_show_plans_16-2.1.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.2 · 18.8KiB pg_show_plans_16-2.1.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.0 · 18.6KiB	PGDG 2.1.8 el8.x86_64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel8.10.x86_64.rpm PGDG · 2.1.8 · 19.6KiB pg_show_plans_15-2.1.6-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.6 · 19.2KiB pg_show_plans_15-2.1.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.3 · 19.0KiB pg_show_plans_15-2.1.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.2 · 18.8KiB pg_show_plans_15-2.1.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.0 · 18.6KiB	PGDG 2.1.8 el8.x86_64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel8.10.x86_64.rpm PGDG · 2.1.8 · 19.6KiB pg_show_plans_14-2.1.6-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.6 · 19.1KiB pg_show_plans_14-2.1.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.3 · 19.0KiB pg_show_plans_14-2.1.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.2 · 18.7KiB pg_show_plans_14-2.1.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.1.0 · 18.5KiB
el8.aarch64	PGDG 2.1.8 el8.aarch64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel8.10.aarch64.rpm PGDG · 2.1.8 · 19.5KiB pg_show_plans_18-2.1.6-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.6 · 19.1KiB	PGDG 2.1.8 el8.aarch64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel8.10.aarch64.rpm PGDG · 2.1.8 · 19.5KiB pg_show_plans_17-2.1.6-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.6 · 19.1KiB pg_show_plans_17-2.1.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.3 · 18.9KiB pg_show_plans_17-2.1.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.2 · 18.7KiB	PGDG 2.1.8 el8.aarch64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel8.10.aarch64.rpm PGDG · 2.1.8 · 19.5KiB pg_show_plans_16-2.1.6-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.6 · 19.1KiB pg_show_plans_16-2.1.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.3 · 18.9KiB pg_show_plans_16-2.1.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.2 · 18.7KiB pg_show_plans_16-2.1.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.0 · 18.5KiB	PGDG 2.1.8 el8.aarch64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel8.10.aarch64.rpm PGDG · 2.1.8 · 19.5KiB pg_show_plans_15-2.1.6-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.6 · 19.1KiB pg_show_plans_15-2.1.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.3 · 18.9KiB pg_show_plans_15-2.1.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.2 · 18.7KiB pg_show_plans_15-2.1.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.0 · 18.5KiB	PGDG 2.1.8 el8.aarch64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel8.10.aarch64.rpm PGDG · 2.1.8 · 19.4KiB pg_show_plans_14-2.1.6-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.6 · 19.0KiB pg_show_plans_14-2.1.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.3 · 18.8KiB pg_show_plans_14-2.1.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.2 · 18.6KiB pg_show_plans_14-2.1.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.1.0 · 18.4KiB
el9.x86_64	PGDG 2.1.8 el9.x86_64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_18-2.1.8-1PGDG.rhel9.7.x86_64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_18-2.1.8-1PGDG.rhel9.6.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_18-2.1.6-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.6 · 19.8KiB pg_show_plans_18-2.1.6-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.6 · 19.7KiB	PGDG 2.1.8 el9.x86_64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_17-2.1.8-1PGDG.rhel9.7.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_17-2.1.8-1PGDG.rhel9.6.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_17-2.1.6-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.6 · 19.9KiB pg_show_plans_17-2.1.6-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_17-2.1.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.3 · 19.5KiB pg_show_plans_17-2.1.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.2 · 19.3KiB	PGDG 2.1.8 el9.x86_64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_16-2.1.8-1PGDG.rhel9.7.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_16-2.1.8-1PGDG.rhel9.6.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_16-2.1.6-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.6 · 19.9KiB pg_show_plans_16-2.1.6-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_16-2.1.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.3 · 19.5KiB pg_show_plans_16-2.1.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.2 · 19.3KiB pg_show_plans_16-2.1.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.0 · 19.0KiB	PGDG 2.1.8 el9.x86_64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_15-2.1.8-1PGDG.rhel9.7.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_15-2.1.8-1PGDG.rhel9.6.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_15-2.1.6-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.6 · 19.9KiB pg_show_plans_15-2.1.6-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_15-2.1.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.3 · 19.5KiB pg_show_plans_15-2.1.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.2 · 19.3KiB pg_show_plans_15-2.1.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.0 · 19.0KiB	PGDG 2.1.8 el9.x86_64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_14-2.1.8-1PGDG.rhel9.7.x86_64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_14-2.1.8-1PGDG.rhel9.6.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_14-2.1.6-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.1.6 · 19.8KiB pg_show_plans_14-2.1.6-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.6 · 19.6KiB pg_show_plans_14-2.1.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.3 · 19.4KiB pg_show_plans_14-2.1.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.2 · 19.2KiB pg_show_plans_14-2.1.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.1.0 · 19.0KiB
el9.aarch64	PGDG 2.1.8 el9.aarch64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.8 · 19.7KiB pg_show_plans_18-2.1.8-1PGDG.rhel9.7.aarch64.rpm PGDG · 2.1.8 · 19.7KiB pg_show_plans_18-2.1.8-1PGDG.rhel9.6.aarch64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_18-2.1.6-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_18-2.1.6-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.6 · 19.4KiB	PGDG 2.1.8 el9.aarch64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_17-2.1.8-1PGDG.rhel9.7.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_17-2.1.8-1PGDG.rhel9.6.aarch64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_17-2.1.6-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_17-2.1.6-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.6 · 19.4KiB pg_show_plans_17-2.1.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.3 · 19.4KiB pg_show_plans_17-2.1.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.2 · 19.2KiB	PGDG 2.1.8 el9.aarch64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_16-2.1.8-1PGDG.rhel9.7.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_16-2.1.8-1PGDG.rhel9.6.aarch64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_16-2.1.6-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_16-2.1.6-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.6 · 19.4KiB pg_show_plans_16-2.1.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.3 · 19.4KiB pg_show_plans_16-2.1.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.2 · 19.2KiB pg_show_plans_16-2.1.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.0 · 19.0KiB	PGDG 2.1.8 el9.aarch64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_15-2.1.8-1PGDG.rhel9.7.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_15-2.1.8-1PGDG.rhel9.6.aarch64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_15-2.1.6-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.6 · 19.8KiB pg_show_plans_15-2.1.6-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.6 · 19.4KiB pg_show_plans_15-2.1.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.3 · 19.4KiB pg_show_plans_15-2.1.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.2 · 19.2KiB pg_show_plans_15-2.1.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.0 · 19.0KiB	PGDG 2.1.8 el9.aarch64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.8 · 19.7KiB pg_show_plans_14-2.1.8-1PGDG.rhel9.7.aarch64.rpm PGDG · 2.1.8 · 19.7KiB pg_show_plans_14-2.1.8-1PGDG.rhel9.6.aarch64.rpm PGDG · 2.1.8 · 19.8KiB pg_show_plans_14-2.1.6-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.1.6 · 19.7KiB pg_show_plans_14-2.1.6-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.6 · 19.4KiB pg_show_plans_14-2.1.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.3 · 19.3KiB pg_show_plans_14-2.1.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.2 · 19.1KiB pg_show_plans_14-2.1.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.1.0 · 18.9KiB
el10.x86_64	PGDG 2.1.8 el10.x86_64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_18-2.1.8-1PGDG.rhel10.1.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_18-2.1.8-1PGDG.rhel10.0.x86_64.rpm PGDG · 2.1.8 · 20.4KiB pg_show_plans_18-2.1.6-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_18-2.1.6-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.6 · 20.0KiB	PGDG 2.1.8 el10.x86_64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_17-2.1.8-1PGDG.rhel10.1.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_17-2.1.8-1PGDG.rhel10.0.x86_64.rpm PGDG · 2.1.8 · 20.4KiB pg_show_plans_17-2.1.6-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_17-2.1.6-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_17-2.1.3-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.3 · 19.9KiB	PGDG 2.1.8 el10.x86_64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_16-2.1.8-1PGDG.rhel10.1.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_16-2.1.8-1PGDG.rhel10.0.x86_64.rpm PGDG · 2.1.8 · 20.4KiB pg_show_plans_16-2.1.6-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_16-2.1.6-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_16-2.1.3-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.3 · 19.9KiB	PGDG 2.1.8 el10.x86_64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_15-2.1.8-1PGDG.rhel10.1.x86_64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_15-2.1.8-1PGDG.rhel10.0.x86_64.rpm PGDG · 2.1.8 · 20.4KiB pg_show_plans_15-2.1.6-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_15-2.1.6-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_15-2.1.3-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.3 · 19.9KiB	PGDG 2.1.8 el10.x86_64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_14-2.1.8-1PGDG.rhel10.1.x86_64.rpm PGDG · 2.1.8 · 19.9KiB pg_show_plans_14-2.1.8-1PGDG.rhel10.0.x86_64.rpm PGDG · 2.1.8 · 20.3KiB pg_show_plans_14-2.1.6-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.1.6 · 19.9KiB pg_show_plans_14-2.1.6-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_14-2.1.3-1PGDG.rhel10.x86_64.rpm PGDG · 2.1.3 · 19.8KiB
el10.aarch64	PGDG 2.1.8 el10.aarch64.pg18 : pg_show_plans_18 pg_show_plans_18-2.1.8-1PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_18-2.1.8-1PGDG.rhel10.1.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_18-2.1.8-1PGDG.rhel10.0.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_18-2.1.6-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_18-2.1.6-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.6 · 20.1KiB	PGDG 2.1.8 el10.aarch64.pg17 : pg_show_plans_17 pg_show_plans_17-2.1.8-1PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_17-2.1.8-1PGDG.rhel10.1.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_17-2.1.8-1PGDG.rhel10.0.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_17-2.1.6-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_17-2.1.6-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_17-2.1.3-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.3 · 20.0KiB	PGDG 2.1.8 el10.aarch64.pg16 : pg_show_plans_16 pg_show_plans_16-2.1.8-1PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_16-2.1.8-1PGDG.rhel10.1.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_16-2.1.8-1PGDG.rhel10.0.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_16-2.1.6-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_16-2.1.6-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_16-2.1.3-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.3 · 19.9KiB	PGDG 2.1.8 el10.aarch64.pg15 : pg_show_plans_15 pg_show_plans_15-2.1.8-1PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_15-2.1.8-1PGDG.rhel10.1.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_15-2.1.8-1PGDG.rhel10.0.aarch64.rpm PGDG · 2.1.8 · 20.1KiB pg_show_plans_15-2.1.6-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_15-2.1.6-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.6 · 20.1KiB pg_show_plans_15-2.1.3-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.3 · 19.9KiB	PGDG 2.1.8 el10.aarch64.pg14 : pg_show_plans_14 pg_show_plans_14-2.1.8-1PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_14-2.1.8-1PGDG.rhel10.1.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_14-2.1.8-1PGDG.rhel10.0.aarch64.rpm PGDG · 2.1.8 · 20.0KiB pg_show_plans_14-2.1.6-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.1.6 · 19.9KiB pg_show_plans_14-2.1.6-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.6 · 20.0KiB pg_show_plans_14-2.1.3-1PGDG.rhel10.aarch64.rpm PGDG · 2.1.3 · 19.8KiB
d12.x86_64	PGDG 2.1.8 d12.x86_64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg12+1_amd64.deb PGDG · 2.1.8 · 23.1KiB postgresql-18-show-plans_2.1.7-1.pgdg12+1_amd64.deb PGDG · 2.1.7 · 23.2KiB	PGDG 2.1.8 d12.x86_64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg12+1_amd64.deb PGDG · 2.1.8 · 23.3KiB postgresql-17-show-plans_2.1.7-1.pgdg12+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d12.x86_64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg12+1_amd64.deb PGDG · 2.1.8 · 23.3KiB postgresql-16-show-plans_2.1.7-1.pgdg12+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d12.x86_64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg12+1_amd64.deb PGDG · 2.1.8 · 23.3KiB postgresql-15-show-plans_2.1.7-1.pgdg12+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d12.x86_64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg12+1_amd64.deb PGDG · 2.1.8 · 23.1KiB postgresql-14-show-plans_2.1.7-1.pgdg12+1_amd64.deb PGDG · 2.1.7 · 23.1KiB
d12.aarch64	PGDG 2.1.8 d12.aarch64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg12+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-18-show-plans_2.1.7-1.pgdg12+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d12.aarch64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg12+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-17-show-plans_2.1.7-1.pgdg12+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d12.aarch64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg12+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-16-show-plans_2.1.7-1.pgdg12+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d12.aarch64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg12+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-15-show-plans_2.1.7-1.pgdg12+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d12.aarch64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg12+1_arm64.deb PGDG · 2.1.8 · 22.7KiB postgresql-14-show-plans_2.1.7-1.pgdg12+1_arm64.deb PGDG · 2.1.7 · 22.8KiB
d13.x86_64	PGDG 2.1.8 d13.x86_64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg13+1_amd64.deb PGDG · 2.1.8 · 23.2KiB postgresql-18-show-plans_2.1.7-1.pgdg13+1_amd64.deb PGDG · 2.1.7 · 23.2KiB	PGDG 2.1.8 d13.x86_64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg13+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-17-show-plans_2.1.7-1.pgdg13+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d13.x86_64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg13+1_amd64.deb PGDG · 2.1.8 · 23.3KiB postgresql-16-show-plans_2.1.7-1.pgdg13+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d13.x86_64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg13+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-15-show-plans_2.1.7-1.pgdg13+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 d13.x86_64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg13+1_amd64.deb PGDG · 2.1.8 · 23.1KiB postgresql-14-show-plans_2.1.7-1.pgdg13+1_amd64.deb PGDG · 2.1.7 · 23.1KiB
d13.aarch64	PGDG 2.1.8 d13.aarch64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg13+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-18-show-plans_2.1.7-1.pgdg13+1_arm64.deb PGDG · 2.1.7 · 23.1KiB	PGDG 2.1.8 d13.aarch64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg13+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-17-show-plans_2.1.7-1.pgdg13+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d13.aarch64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg13+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-16-show-plans_2.1.7-1.pgdg13+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 d13.aarch64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg13+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-15-show-plans_2.1.7-1.pgdg13+1_arm64.deb PGDG · 2.1.7 · 23.1KiB	PGDG 2.1.8 d13.aarch64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg13+1_arm64.deb PGDG · 2.1.8 · 22.8KiB postgresql-14-show-plans_2.1.7-1.pgdg13+1_arm64.deb PGDG · 2.1.7 · 22.9KiB
u22.x86_64	PGDG 2.1.8 u22.x86_64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg22.04+1_amd64.deb PGDG · 2.1.8 · 23.6KiB postgresql-18-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb PGDG · 2.1.7 · 23.6KiB	PGDG 2.1.8 u22.x86_64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg22.04+1_amd64.deb PGDG · 2.1.8 · 27.1KiB postgresql-17-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb PGDG · 2.1.7 · 27.1KiB	PGDG 2.1.8 u22.x86_64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg22.04+1_amd64.deb PGDG · 2.1.8 · 27.0KiB postgresql-16-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb PGDG · 2.1.7 · 27.1KiB	PGDG 2.1.8 u22.x86_64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg22.04+1_amd64.deb PGDG · 2.1.8 · 27.0KiB postgresql-15-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb PGDG · 2.1.7 · 27.0KiB	PGDG 2.1.8 u22.x86_64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg22.04+1_amd64.deb PGDG · 2.1.8 · 26.8KiB postgresql-14-show-plans_2.1.7-1.pgdg22.04+1_amd64.deb PGDG · 2.1.7 · 26.8KiB
u22.aarch64	PGDG 2.1.8 u22.aarch64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg22.04+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-18-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 u22.aarch64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg22.04+1_arm64.deb PGDG · 2.1.8 · 26.3KiB postgresql-17-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb PGDG · 2.1.7 · 26.3KiB	PGDG 2.1.8 u22.aarch64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg22.04+1_arm64.deb PGDG · 2.1.8 · 26.3KiB postgresql-16-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb PGDG · 2.1.7 · 26.2KiB	PGDG 2.1.8 u22.aarch64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg22.04+1_arm64.deb PGDG · 2.1.8 · 26.3KiB postgresql-15-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb PGDG · 2.1.7 · 26.3KiB	PGDG 2.1.8 u22.aarch64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg22.04+1_arm64.deb PGDG · 2.1.8 · 26.0KiB postgresql-14-show-plans_2.1.7-1.pgdg22.04+1_arm64.deb PGDG · 2.1.7 · 26.0KiB
u24.x86_64	PGDG 2.1.8 u24.x86_64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg24.04+1_amd64.deb PGDG · 2.1.8 · 23.3KiB postgresql-18-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 u24.x86_64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg24.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-17-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u24.x86_64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg24.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-16-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u24.x86_64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg24.04+1_amd64.deb PGDG · 2.1.8 · 23.5KiB postgresql-15-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u24.x86_64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg24.04+1_amd64.deb PGDG · 2.1.8 · 23.2KiB postgresql-14-show-plans_2.1.7-1.pgdg24.04+1_amd64.deb PGDG · 2.1.7 · 23.2KiB
u24.aarch64	PGDG 2.1.8 u24.aarch64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg24.04+1_arm64.deb PGDG · 2.1.8 · 23.0KiB postgresql-18-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb PGDG · 2.1.7 · 23.1KiB	PGDG 2.1.8 u24.aarch64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg24.04+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-17-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 u24.aarch64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg24.04+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-16-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 u24.aarch64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg24.04+1_arm64.deb PGDG · 2.1.8 · 23.1KiB postgresql-15-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb PGDG · 2.1.7 · 23.0KiB	PGDG 2.1.8 u24.aarch64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg24.04+1_arm64.deb PGDG · 2.1.8 · 22.8KiB postgresql-14-show-plans_2.1.7-1.pgdg24.04+1_arm64.deb PGDG · 2.1.7 · 22.9KiB
u26.x86_64	PGDG 2.1.8 u26.x86_64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg26.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-18-show-plans_2.1.7-1.pgdg26.04+1_amd64.deb PGDG · 2.1.7 · 23.3KiB	PGDG 2.1.8 u26.x86_64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg26.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-17-show-plans_2.1.7-1.pgdg26.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u26.x86_64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg26.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-16-show-plans_2.1.7-1.pgdg26.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u26.x86_64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg26.04+1_amd64.deb PGDG · 2.1.8 · 23.4KiB postgresql-15-show-plans_2.1.7-1.pgdg26.04+1_amd64.deb PGDG · 2.1.7 · 23.4KiB	PGDG 2.1.8 u26.x86_64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg26.04+1_amd64.deb PGDG · 2.1.8 · 23.1KiB postgresql-14-show-plans_2.1.7-1.pgdg26.04+1_amd64.deb PGDG · 2.1.7 · 23.1KiB
u26.aarch64	PGDG 2.1.8 u26.aarch64.pg18 : postgresql-18-show-plans postgresql-18-show-plans_2.1.8-1.pgdg26.04+1_arm64.deb PGDG · 2.1.8 · 22.7KiB postgresql-18-show-plans_2.1.7-1.pgdg26.04+1_arm64.deb PGDG · 2.1.7 · 22.6KiB	PGDG 2.1.8 u26.aarch64.pg17 : postgresql-17-show-plans postgresql-17-show-plans_2.1.8-1.pgdg26.04+1_arm64.deb PGDG · 2.1.8 · 22.7KiB postgresql-17-show-plans_2.1.7-1.pgdg26.04+1_arm64.deb PGDG · 2.1.7 · 22.7KiB	PGDG 2.1.8 u26.aarch64.pg16 : postgresql-16-show-plans postgresql-16-show-plans_2.1.8-1.pgdg26.04+1_arm64.deb PGDG · 2.1.8 · 22.7KiB postgresql-16-show-plans_2.1.7-1.pgdg26.04+1_arm64.deb PGDG · 2.1.7 · 22.7KiB	PGDG 2.1.8 u26.aarch64.pg15 : postgresql-15-show-plans postgresql-15-show-plans_2.1.8-1.pgdg26.04+1_arm64.deb PGDG · 2.1.8 · 22.7KiB postgresql-15-show-plans_2.1.7-1.pgdg26.04+1_arm64.deb PGDG · 2.1.7 · 22.7KiB	PGDG 2.1.8 u26.aarch64.pg14 : postgresql-14-show-plans postgresql-14-show-plans_2.1.8-1.pgdg26.04+1_arm64.deb PGDG · 2.1.8 · 22.5KiB postgresql-14-show-plans_2.1.7-1.pgdg26.04+1_arm64.deb PGDG · 2.1.7 · 22.4KiB

Install

You can install pg_show_plans directly. First, make sure the PGDG repository is added and enabled:

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

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_show_plans;          # Install for current active PG version

pig

pig ext install -y pg_show_plans -v 18  # PG 18
pig ext install -y pg_show_plans -v 17  # PG 17
pig ext install -y pg_show_plans -v 16  # PG 16
pig ext install -y pg_show_plans -v 15  # PG 15
pig ext install -y pg_show_plans -v 14  # PG 14

dnf

dnf install -y pg_show_plans_18       # PG 18
dnf install -y pg_show_plans_17       # PG 17
dnf install -y pg_show_plans_16       # PG 16
dnf install -y pg_show_plans_15       # PG 15
dnf install -y pg_show_plans_14       # PG 14

apt

apt install -y postgresql-18-show-plans   # PG 18
apt install -y postgresql-17-show-plans   # PG 17
apt install -y postgresql-16-show-plans   # PG 16
apt install -y postgresql-15-show-plans   # PG 15
apt install -y postgresql-14-show-plans   # PG 14

Preload:

shared_preload_libraries = 'pg_show_plans';

Create Extension:

CREATE EXTENSION pg_show_plans;

Usage

pg_show_plans: show query plans of running SQL statements

pg_show_plans displays the execution plans of all currently running SQL statements in real time. Plans are stored in a shared memory hash table.

Viewing Running Plans

-- Show plans of all currently running queries
SELECT * FROM pg_show_plans;

-- Show plans along with their query text
SELECT * FROM pg_show_plans_q;

The views return:

Column	Type	Description
`pid`	integer	Server process ID
`level`	integer	Query nest level (0 = top level)
`userid`	oid	User OID
`dbid`	oid	Database OID
`plan`	text	Query plan text
`query`	text	Query string (only in `pg_show_plans_q`)

Nested Queries

When a function invokes SQL statements, they appear at deeper nesting levels:

SELECT * FROM pg_show_plans;
  pid  | level | userid | dbid  |                       plan
-------+-------+--------+-------+-----------------------------------------------
 11504 |     0 |     10 | 16384 | Function Scan on print_item  (cost=...)
 11504 |     1 |     10 | 16384 | Result  (cost=0.00..0.01 rows=1 width=4)

GUC Parameters

Parameter	Default	Description
`pg_show_plans.plan_format`	`text`	Output format: `text`, `json`, `yaml`, `xml`
`pg_show_plans.max_plan_length`	16384	Max plan length in bytes (affects shared memory)
`pg_show_plans.is_enabled`	`true`	Enable or disable the extension at runtime

pg_show_plans

Overview

Version

Install

Usage

Viewing Running Plans

Nested Queries

GUC Parameters

Was this page helpful?