pg_show_plans

打印所有当前正在运行查询的执行计划

概览

扩展包名	版本	分类	许可证	语言
`pg_show_plans`	`2.1.8`	STAT	PostgreSQL	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
6210	`pg_show_plans`	否	是	是	是	否	是	-

相关扩展	`pg_stat_plans` `auto_explain` `explain_ui` `pg_stat_statements` `pg_store_plans` `pg_overexplain` `pg_qualstats` `online_advisor` `pgrowlocks` `pg_wait_sampling`

版本

类型	仓库	版本	PG 大版本	包名	依赖
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

安装

您可以直接安装 pg_show_plans 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install pg_show_plans;          # 当前活跃 PG 版本安装

pig

BASH

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

BASH

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

BASH

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

预加载配置：

BASH

shared_preload_libraries = 'pg_show_plans';

创建扩展：

SQL

CREATE EXTENSION pg_show_plans;

用法

pg_show_plans: 显示正在运行的 SQL 语句的查询计划

pg_show_plans 实时显示所有正在运行的 SQL 语句的执行计划。计划存储在共享内存哈希表中。

查看运行中的计划

SQL

-- 查看所有正在运行的查询的计划
SELECT * FROM pg_show_plans;

-- 查看计划及其查询文本
SELECT * FROM pg_show_plans_q;

视图返回以下列：

列名	类型	描述
`pid`	integer	服务器进程 ID
`level`	integer	查询嵌套层级（0 = 顶层）
`userid`	oid	用户 OID
`dbid`	oid	数据库 OID
`plan`	text	查询计划文本
`query`	text	查询字符串（仅在 `pg_show_plans_q` 中）

嵌套查询

当函数调用 SQL 语句时，它们会出现在更深的嵌套层级中：

SQL

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 参数

参数	默认值	描述
`pg_show_plans.plan_format`	`text`	输出格式：`text`、`json`、`yaml`、`xml`
`pg_show_plans.max_plan_length`	16384	最大计划长度（字节，影响共享内存）
`pg_show_plans.is_enabled`	`true`	在运行时启用或禁用扩展

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。