pg_hint_plan

添加强制指定执行计划的能力

概览

扩展包名	版本	分类	许可证	语言
`pg_hint_plan`	`1.8.0`	FEAT	BSD-3-Clause	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
2780	`pg_hint_plan`	否	是	是	是	否	否	`hint_plan`

相关扩展	`hypopg` `online_advisor` `pg_qualstats` `index_advisor` `pg_stat_plans` `plan_filter` `pg_strom` `pg_orca` `pg_regresql` `pg_track_optimizer`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PGDG	`1.8.0`	1817161514	`pg_hint_plan`	-
RPM	PGDG	`1.8.0`	1817161514	`pg_hint_plan_$v`	-
DEB	PGDG	`1.8.0`	1817161514	`postgresql-$v-pg-hint-plan`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 1.8.0 el8.x86_64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.8.0 · 55.3KiB	PGDG 1.7.1 el8.x86_64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-1PGDG.rhel8.x86_64.rpm PGDG · 1.7.1 · 53.2KiB pg_hint_plan_17-1.7.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.7.0 · 51.4KiB	PGDG 1.6.2 el8.x86_64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.2 · 45.8KiB pg_hint_plan_16-1.6.1-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.1 · 44.2KiB pg_hint_plan_16-1.6.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 42.6KiB	PGDG 1.5.3 el8.x86_64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-1PGDG.rhel8.x86_64.rpm PGDG · 1.5.3 · 45.3KiB pg_hint_plan_15-1.5.2-1PGDG.rhel8.x86_64.rpm PGDG · 1.5.2 · 43.7KiB pg_hint_plan_15-1.5.1-1PGDG.rhel8.x86_64.rpm PGDG · 1.5.1 · 48.9KiB	PGDG 1.4.4 el8.x86_64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-1PGDG.rhel8.x86_64.rpm PGDG · 1.4.4 · 44.6KiB pg_hint_plan_14-1.4.3-1PGDG.rhel8.x86_64.rpm PGDG · 1.4.3 · 43.3KiB pg_hint_plan_14-1.4.2-1PGDG.rhel8.x86_64.rpm PGDG · 1.4.2 · 42.0KiB
el8.aarch64	PGDG 1.8.0 el8.aarch64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.8.0 · 51.7KiB	PGDG 1.7.1 el8.aarch64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-1PGDG.rhel8.aarch64.rpm PGDG · 1.7.1 · 50.0KiB pg_hint_plan_17-1.7.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.7.0 · 48.2KiB	PGDG 1.6.2 el8.aarch64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.2 · 43.4KiB pg_hint_plan_16-1.6.1-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.1 · 41.8KiB pg_hint_plan_16-1.6.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 40.2KiB	PGDG 1.5.3 el8.aarch64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-1PGDG.rhel8.aarch64.rpm PGDG · 1.5.3 · 43.0KiB pg_hint_plan_15-1.5.2-1PGDG.rhel8.aarch64.rpm PGDG · 1.5.2 · 41.5KiB pg_hint_plan_15-1.5.1-1PGDG.rhel8.aarch64.rpm PGDG · 1.5.1 · 46.6KiB	PGDG 1.4.4 el8.aarch64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-1PGDG.rhel8.aarch64.rpm PGDG · 1.4.4 · 42.3KiB pg_hint_plan_14-1.4.3-1PGDG.rhel8.aarch64.rpm PGDG · 1.4.3 · 41.0KiB pg_hint_plan_14-1.4.2-1PGDG.rhel8.aarch64.rpm PGDG · 1.4.2 · 39.7KiB
el9.x86_64	PGDG 1.8.0 el9.x86_64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-5PGDG.rhel9.8.x86_64.rpm PGDG · 1.8.0 · 54.6KiB pg_hint_plan_18-1.8.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.8.0 · 54.4KiB	PGDG 1.7.1 el9.x86_64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-5PGDG.rhel9.8.x86_64.rpm PGDG · 1.7.1 · 52.9KiB pg_hint_plan_17-1.7.1-1PGDG.rhel9.x86_64.rpm PGDG · 1.7.1 · 52.6KiB pg_hint_plan_17-1.7.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.7.0 · 50.7KiB	PGDG 1.6.2 el9.x86_64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-5PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.2 · 46.8KiB pg_hint_plan_16-1.6.2-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.2 · 46.5KiB pg_hint_plan_16-1.6.1-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.1 · 44.9KiB pg_hint_plan_16-1.6.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 43.2KiB	PGDG 1.5.3 el9.x86_64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-5PGDG.rhel9.8.x86_64.rpm PGDG · 1.5.3 · 46.3KiB pg_hint_plan_15-1.5.3-1PGDG.rhel9.x86_64.rpm PGDG · 1.5.3 · 46.0KiB pg_hint_plan_15-1.5.2-1PGDG.rhel9.x86_64.rpm PGDG · 1.5.2 · 44.7KiB pg_hint_plan_15-1.5.1-1PGDG.rhel9.x86_64.rpm PGDG · 1.5.1 · 49.4KiB	PGDG 1.4.4 el9.x86_64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-5PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.4 · 45.7KiB pg_hint_plan_14-1.4.4-1PGDG.rhel9.x86_64.rpm PGDG · 1.4.4 · 45.4KiB pg_hint_plan_14-1.4.3-1PGDG.rhel9.x86_64.rpm PGDG · 1.4.3 · 44.2KiB pg_hint_plan_14-1.4.2-1PGDG.rhel9.x86_64.rpm PGDG · 1.4.2 · 42.8KiB
el9.aarch64	PGDG 1.8.0 el9.aarch64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-5PGDG.rhel9.8.aarch64.rpm PGDG · 1.8.0 · 53.0KiB pg_hint_plan_18-1.8.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.8.0 · 52.5KiB	PGDG 1.7.1 el9.aarch64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-5PGDG.rhel9.8.aarch64.rpm PGDG · 1.7.1 · 51.0KiB pg_hint_plan_17-1.7.1-1PGDG.rhel9.aarch64.rpm PGDG · 1.7.1 · 50.6KiB pg_hint_plan_17-1.7.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.7.0 · 49.0KiB	PGDG 1.6.2 el9.aarch64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-5PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.2 · 45.4KiB pg_hint_plan_16-1.6.2-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.2 · 45.0KiB pg_hint_plan_16-1.6.1-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.1 · 43.5KiB pg_hint_plan_16-1.6.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 41.6KiB	PGDG 1.5.3 el9.aarch64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-5PGDG.rhel9.8.aarch64.rpm PGDG · 1.5.3 · 44.9KiB pg_hint_plan_15-1.5.3-1PGDG.rhel9.aarch64.rpm PGDG · 1.5.3 · 44.5KiB pg_hint_plan_15-1.5.2-1PGDG.rhel9.aarch64.rpm PGDG · 1.5.2 · 43.1KiB pg_hint_plan_15-1.5.1-1PGDG.rhel9.aarch64.rpm PGDG · 1.5.1 · 47.8KiB	PGDG 1.4.4 el9.aarch64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-5PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.4 · 44.3KiB pg_hint_plan_14-1.4.4-1PGDG.rhel9.aarch64.rpm PGDG · 1.4.4 · 43.9KiB pg_hint_plan_14-1.4.3-1PGDG.rhel9.aarch64.rpm PGDG · 1.4.3 · 42.7KiB pg_hint_plan_14-1.4.2-1PGDG.rhel9.aarch64.rpm PGDG · 1.4.2 · 41.2KiB
el10.x86_64	PGDG 1.8.0 el10.x86_64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-5PGDG.rhel10.2.x86_64.rpm PGDG · 1.8.0 · 55.5KiB pg_hint_plan_18-1.8.0-1PGDG.rhel10.x86_64.rpm PGDG · 1.8.0 · 55.5KiB	PGDG 1.7.1 el10.x86_64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-5PGDG.rhel10.2.x86_64.rpm PGDG · 1.7.1 · 53.7KiB pg_hint_plan_17-1.7.1-1PGDG.rhel10.x86_64.rpm PGDG · 1.7.1 · 53.6KiB pg_hint_plan_17-1.7.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.7.0 · 52.0KiB	PGDG 1.6.2 el10.x86_64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-5PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.2 · 47.7KiB pg_hint_plan_16-1.6.2-1PGDG.rhel10.x86_64.rpm PGDG · 1.6.2 · 47.7KiB pg_hint_plan_16-1.6.1-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.1 · 46.2KiB	PGDG 1.5.3 el10.x86_64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-5PGDG.rhel10.2.x86_64.rpm PGDG · 1.5.3 · 47.4KiB pg_hint_plan_15-1.5.3-1PGDG.rhel10.x86_64.rpm PGDG · 1.5.3 · 47.4KiB pg_hint_plan_15-1.5.2-3PGDG.rhel10.x86_64.rpm PGDG · 1.5.2 · 46.2KiB	PGDG 1.4.4 el10.x86_64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-5PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.4 · 46.8KiB pg_hint_plan_14-1.4.4-1PGDG.rhel10.x86_64.rpm PGDG · 1.4.4 · 46.8KiB pg_hint_plan_14-1.4.3-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.3 · 45.6KiB
el10.aarch64	PGDG 1.8.0 el10.aarch64.pg18 : pg_hint_plan_18 pg_hint_plan_18-1.8.0-5PGDG.rhel10.2.aarch64.rpm PGDG · 1.8.0 · 53.7KiB pg_hint_plan_18-1.8.0-1PGDG.rhel10.aarch64.rpm PGDG · 1.8.0 · 53.7KiB	PGDG 1.7.1 el10.aarch64.pg17 : pg_hint_plan_17 pg_hint_plan_17-1.7.1-5PGDG.rhel10.2.aarch64.rpm PGDG · 1.7.1 · 52.1KiB pg_hint_plan_17-1.7.1-1PGDG.rhel10.aarch64.rpm PGDG · 1.7.1 · 52.1KiB pg_hint_plan_17-1.7.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.7.0 · 50.4KiB	PGDG 1.6.2 el10.aarch64.pg16 : pg_hint_plan_16 pg_hint_plan_16-1.6.2-5PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.2 · 46.0KiB pg_hint_plan_16-1.6.2-1PGDG.rhel10.aarch64.rpm PGDG · 1.6.2 · 46.0KiB pg_hint_plan_16-1.6.1-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.1 · 44.5KiB	PGDG 1.5.3 el10.aarch64.pg15 : pg_hint_plan_15 pg_hint_plan_15-1.5.3-5PGDG.rhel10.2.aarch64.rpm PGDG · 1.5.3 · 45.5KiB pg_hint_plan_15-1.5.3-1PGDG.rhel10.aarch64.rpm PGDG · 1.5.3 · 45.5KiB pg_hint_plan_15-1.5.2-3PGDG.rhel10.aarch64.rpm PGDG · 1.5.2 · 44.2KiB	PGDG 1.4.4 el10.aarch64.pg14 : pg_hint_plan_14 pg_hint_plan_14-1.4.4-5PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.4 · 44.8KiB pg_hint_plan_14-1.4.4-1PGDG.rhel10.aarch64.rpm PGDG · 1.4.4 · 44.9KiB pg_hint_plan_14-1.4.3-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.3 · 43.7KiB
d12.x86_64	PGDG 1.8.0 d12.x86_64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg12+1_amd64.deb PGDG · 1.8.0 · 132.8KiB	PGDG 1.7.1 d12.x86_64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg12+1_amd64.deb PGDG · 1.7.1 · 128.0KiB	PGDG 1.6.2 d12.x86_64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg12+1_amd64.deb PGDG · 1.6.2 · 104.6KiB	PGDG 1.5.3 d12.x86_64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg12+1_amd64.deb PGDG · 1.5.3 · 104.4KiB	PGDG 1.4.4 d12.x86_64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg12+1_amd64.deb PGDG · 1.4.4 · 104.1KiB
d12.aarch64	PGDG 1.8.0 d12.aarch64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg12+1_arm64.deb PGDG · 1.8.0 · 128.8KiB	PGDG 1.7.1 d12.aarch64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg12+1_arm64.deb PGDG · 1.7.1 · 123.9KiB	PGDG 1.6.2 d12.aarch64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg12+1_arm64.deb PGDG · 1.6.2 · 101.6KiB	PGDG 1.5.3 d12.aarch64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg12+1_arm64.deb PGDG · 1.5.3 · 101.2KiB	PGDG 1.4.4 d12.aarch64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg12+1_arm64.deb PGDG · 1.4.4 · 100.8KiB
d13.x86_64	PGDG 1.8.0 d13.x86_64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg13+1_amd64.deb PGDG · 1.8.0 · 133.2KiB	PGDG 1.7.1 d13.x86_64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_amd64.deb PGDG · 1.7.1 · 128.4KiB	PGDG 1.6.2 d13.x86_64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg13+1_amd64.deb PGDG · 1.6.2 · 104.8KiB	PGDG 1.5.3 d13.x86_64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg13+1_amd64.deb PGDG · 1.5.3 · 104.8KiB	PGDG 1.4.4 d13.x86_64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg13+1_amd64.deb PGDG · 1.4.4 · 104.5KiB
d13.aarch64	PGDG 1.8.0 d13.aarch64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg13+1_arm64.deb PGDG · 1.8.0 · 128.8KiB	PGDG 1.7.1 d13.aarch64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_arm64.deb PGDG · 1.7.1 · 124.3KiB	PGDG 1.6.2 d13.aarch64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg13+1_arm64.deb PGDG · 1.6.2 · 101.9KiB	PGDG 1.5.3 d13.aarch64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg13+1_arm64.deb PGDG · 1.5.3 · 101.7KiB	PGDG 1.4.4 d13.aarch64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg13+1_arm64.deb PGDG · 1.4.4 · 101.1KiB
u22.x86_64	PGDG 1.8.0 u22.x86_64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg22.04+1_amd64.deb PGDG · 1.8.0 · 133.8KiB	PGDG 1.7.1 u22.x86_64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg22.04+1_amd64.deb PGDG · 1.7.1 · 140.9KiB	PGDG 1.6.2 u22.x86_64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg22.04+1_amd64.deb PGDG · 1.6.2 · 117.2KiB	PGDG 1.5.3 u22.x86_64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg22.04+1_amd64.deb PGDG · 1.5.3 · 117.1KiB	PGDG 1.4.4 u22.x86_64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg22.04+1_amd64.deb PGDG · 1.4.4 · 116.6KiB
u22.aarch64	PGDG 1.8.0 u22.aarch64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg22.04+1_arm64.deb PGDG · 1.8.0 · 129.8KiB	PGDG 1.7.1 u22.aarch64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg22.04+1_arm64.deb PGDG · 1.7.1 · 137.2KiB	PGDG 1.6.2 u22.aarch64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg22.04+1_arm64.deb PGDG · 1.6.2 · 114.4KiB	PGDG 1.5.3 u22.aarch64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg22.04+1_arm64.deb PGDG · 1.5.3 · 114.0KiB	PGDG 1.4.4 u22.aarch64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg22.04+1_arm64.deb PGDG · 1.4.4 · 113.5KiB
u24.x86_64	PGDG 1.8.0 u24.x86_64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg24.04+1_amd64.deb PGDG · 1.8.0 · 131.7KiB	PGDG 1.7.1 u24.x86_64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg24.04+1_amd64.deb PGDG · 1.7.1 · 126.7KiB	PGDG 1.6.2 u24.x86_64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg24.04+1_amd64.deb PGDG · 1.6.2 · 104.4KiB	PGDG 1.5.3 u24.x86_64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg24.04+1_amd64.deb PGDG · 1.5.3 · 104.4KiB	PGDG 1.4.4 u24.x86_64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg24.04+1_amd64.deb PGDG · 1.4.4 · 104.4KiB
u24.aarch64	PGDG 1.8.0 u24.aarch64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg24.04+1_arm64.deb PGDG · 1.8.0 · 128.0KiB	PGDG 1.7.1 u24.aarch64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg24.04+1_arm64.deb PGDG · 1.7.1 · 123.4KiB	PGDG 1.6.2 u24.aarch64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg24.04+1_arm64.deb PGDG · 1.6.2 · 101.7KiB	PGDG 1.5.3 u24.aarch64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg24.04+1_arm64.deb PGDG · 1.5.3 · 101.4KiB	PGDG 1.4.4 u24.aarch64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg24.04+1_arm64.deb PGDG · 1.4.4 · 101.1KiB
u26.x86_64	PGDG 1.8.0 u26.x86_64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg26.04+1_amd64.deb PGDG · 1.8.0 · 130.1KiB	PGDG 1.7.1 u26.x86_64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg26.04+1_amd64.deb PGDG · 1.7.1 · 125.2KiB	PGDG 1.6.2 u26.x86_64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg26.04+1_amd64.deb PGDG · 1.6.2 · 103.3KiB	PGDG 1.5.3 u26.x86_64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg26.04+1_amd64.deb PGDG · 1.5.3 · 103.1KiB	PGDG 1.4.4 u26.x86_64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg26.04+1_amd64.deb PGDG · 1.4.4 · 102.9KiB
u26.aarch64	PGDG 1.8.0 u26.aarch64.pg18 : postgresql-18-pg-hint-plan postgresql-18-pg-hint-plan_1.8.0-3.pgdg26.04+1_arm64.deb PGDG · 1.8.0 · 126.0KiB	PGDG 1.7.1 u26.aarch64.pg17 : postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan_1.7.1-1.pgdg26.04+1_arm64.deb PGDG · 1.7.1 · 121.6KiB	PGDG 1.6.2 u26.aarch64.pg16 : postgresql-16-pg-hint-plan postgresql-16-pg-hint-plan_1.6.2-1.pgdg26.04+1_arm64.deb PGDG · 1.6.2 · 100.0KiB	PGDG 1.5.3 u26.aarch64.pg15 : postgresql-15-pg-hint-plan postgresql-15-pg-hint-plan_1.5.3-1.pgdg26.04+1_arm64.deb PGDG · 1.5.3 · 99.5KiB	PGDG 1.4.4 u26.aarch64.pg14 : postgresql-14-pg-hint-plan postgresql-14-pg-hint-plan_1.4.4-1.pgdg26.04+1_arm64.deb PGDG · 1.4.4 · 99.3KiB

安装

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

BASH

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

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

安装

BASH

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

pig

BASH

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

dnf

BASH

dnf install -y pg_hint_plan_18       # PG 18
dnf install -y pg_hint_plan_17       # PG 17
dnf install -y pg_hint_plan_16       # PG 16
dnf install -y pg_hint_plan_15       # PG 15
dnf install -y pg_hint_plan_14       # PG 14

apt

BASH

apt install -y postgresql-18-pg-hint-plan   # PG 18
apt install -y postgresql-17-pg-hint-plan   # PG 17
apt install -y postgresql-16-pg-hint-plan   # PG 16
apt install -y postgresql-15-pg-hint-plan   # PG 15
apt install -y postgresql-14-pg-hint-plan   # PG 14

预加载配置：

BASH

shared_preload_libraries = 'pg_hint_plan';

创建扩展：

SQL

CREATE EXTENSION pg_hint_plan;

用法

pg_hint_plan: 赋予 PostgreSQL 手动干预执行计划的能力

pg_hint_plan 通过 SQL 注释提示覆盖 PostgreSQL 查询规划器的决策，允许你强制指定扫描方法、连接策略和连接顺序。

提示语法

提示嵌入在以 /*+ 开头、*/ 结尾的 SQL 注释中：

SQL

/*+
  HashJoin(a b)
  SeqScan(a)
*/
SELECT *
FROM pgbench_branches b
JOIN pgbench_accounts a ON b.bid = a.bid
ORDER BY a.aid;

扫描方法提示

提示	描述
`SeqScan(table)`	强制顺序扫描
`IndexScan(table [index...])`	强制索引扫描（可选限定特定索引）
`IndexOnlyScan(table [index...])`	强制仅索引扫描
`BitmapScan(table [index...])`	强制位图扫描
`TidScan(table)`	强制 TID 扫描
`NoSeqScan(table)`	禁止顺序扫描
`NoIndexScan(table)`	禁止索引扫描和仅索引扫描
`NoIndexOnlyScan(table)`	禁止仅索引扫描
`NoBitmapScan(table)`	禁止位图扫描
`NoTidScan(table)`	禁止 TID 扫描
`IndexScanRegexp(table [regexp...])`	使用正则表达式匹配索引名的强制索引扫描
`DisableIndex(table index...)`	在规划期间禁用特定索引

连接方法提示

提示	描述
`NestLoop(t1 t2 [t3...])`	强制嵌套循环连接
`HashJoin(t1 t2 [t3...])`	强制哈希连接
`MergeJoin(t1 t2 [t3...])`	强制归并连接
`NoNestLoop(t1 t2 [t3...])`	禁止嵌套循环连接
`NoHashJoin(t1 t2 [t3...])`	禁止哈希连接
`NoMergeJoin(t1 t2 [t3...])`	禁止归并连接
`Memoize(t1 t2 [t3...])`	允许缓存内层结果
`NoMemoize(t1 t2 [t3...])`	禁止缓存

连接顺序提示

SQL

-- 简单的左深连接顺序
/*+ Leading(a b c) */

-- 带嵌套的显式连接树
/*+ Leading((a (b c))) */

行数修正

SQL

/*+ Rows(a b #100) */    -- 设置为绝对数量
/*+ Rows(a b +100) */    -- 增加估计值
/*+ Rows(a b -100) */    -- 减少估计值
/*+ Rows(a b *2.0) */    -- 倍乘估计值

并行查询控制

SQL

/*+ Parallel(table 4 hard) */   -- 强制 4 个并行工作进程
/*+ Parallel(table 0 hard) */   -- 禁用并行

GUC 参数覆盖

SQL

/*+ Set(random_page_cost 1.0) Set(seq_page_cost 1.0) */
SELECT * FROM my_table WHERE id = 42;

GUC 配置

参数	描述	默认值
`pg_hint_plan.enable_hint`	全局启用或禁用提示	on
`pg_hint_plan.enable_hint_table`	启用基于查询的提示表	off
`pg_hint_plan.debug_print`	打印已应用提示的调试信息	off
`pg_hint_plan.parse_messages`	提示解析消息的日志级别	INFO
`pg_hint_plan.message_level`	调试消息的日志级别	LOG

意见反馈

这个页面对您有帮助吗？

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

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