pg_hint_plan

Give PostgreSQL ability to manually force some decisions in execution plans.

Overview

Package	Version	Category	License	Language
`pg_hint_plan`	`1.8.0`	FEAT	BSD-3-Clause	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
2780	`pg_hint_plan`	No	Yes	Yes	Yes	No	No	`hint_plan`

Related	`hypopg` `online_advisor` `pg_qualstats` `index_advisor` `pg_stat_plans` `plan_filter` `pg_strom` `pg_orca` `pg_regresql` `pg_track_optimizer`

Version

Type	Repo	Version	PG Ver	Package	Deps
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

Install

You can install pg_hint_plan 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_hint_plan;          # Install for current active PG version

pig

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

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

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

Preload:

shared_preload_libraries = 'pg_hint_plan';

Create Extension:

CREATE EXTENSION pg_hint_plan;

Usage

pg_hint_plan: Give PostgreSQL ability to manually force some decisions in execution plans

pg_hint_plan overrides the PostgreSQL query planner’s decisions using SQL comment hints, allowing you to force specific scan methods, join strategies, and join orders.

Hint Syntax

Hints are embedded in SQL comments prefixed with /*+ and closed with */:

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

Scan Method Hints

Hint	Description
`SeqScan(table)`	Force sequential scan
`IndexScan(table [index...])`	Force index scan (optionally restrict to specific indexes)
`IndexOnlyScan(table [index...])`	Force index-only scan
`BitmapScan(table [index...])`	Force bitmap scan
`TidScan(table)`	Force TID scan
`NoSeqScan(table)`	Prevent sequential scan
`NoIndexScan(table)`	Prevent index scan and index-only scan
`NoIndexOnlyScan(table)`	Prevent index-only scan
`NoBitmapScan(table)`	Prevent bitmap scan
`NoTidScan(table)`	Prevent TID scan
`IndexScanRegexp(table [regexp...])`	Force index scan with regex-matched index names
`DisableIndex(table index...)`	Disable specific indexes during planning

Join Method Hints

Hint	Description
`NestLoop(t1 t2 [t3...])`	Force nested loop join
`HashJoin(t1 t2 [t3...])`	Force hash join
`MergeJoin(t1 t2 [t3...])`	Force merge join
`NoNestLoop(t1 t2 [t3...])`	Prevent nested loop join
`NoHashJoin(t1 t2 [t3...])`	Prevent hash join
`NoMergeJoin(t1 t2 [t3...])`	Prevent merge join
`Memoize(t1 t2 [t3...])`	Allow memoization of inner result
`NoMemoize(t1 t2 [t3...])`	Prevent memoization

Join Order Hints

-- Simple left-deep join order
/*+ Leading(a b c) */

-- Explicit join tree with nesting
/*+ Leading((a (b c))) */

Row Number Correction

/*+ Rows(a b #100) */    -- Set to absolute number
/*+ Rows(a b +100) */    -- Add to estimate
/*+ Rows(a b -100) */    -- Subtract from estimate
/*+ Rows(a b *2.0) */    -- Multiply estimate

Parallel Query Control

/*+ Parallel(table 4 hard) */   -- Force 4 parallel workers
/*+ Parallel(table 0 hard) */   -- Disable parallelism

GUC Parameter Override

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

GUC Configuration

Parameter	Description	Default
`pg_hint_plan.enable_hint`	Enable or disable hints globally	on
`pg_hint_plan.enable_hint_table`	Enable hint table for query-based hints	off
`pg_hint_plan.debug_print`	Print debug info for applied hints	off
`pg_hint_plan.parse_messages`	Log level for hint parsing messages	INFO
`pg_hint_plan.message_level`	Log level for debug messages	LOG

pg_hint_plan

Overview

Version

Install

Usage

Hint Syntax

Scan Method Hints

Join Method Hints

Join Order Hints

Row Number Correction

Parallel Query Control

GUC Parameter Override

GUC Configuration

Was this page helpful?