Extensions
pg_hint_plan

pg_hint_plan

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

Overview

ID Extension Package Version Category License Language
2780
pg_hint_plan
pg_hint_plan
 1.8.0
FEAT
BSD 3-Clause
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
Schemas hint_plan
See Also
pg_show_plans
pg_store_plans
pg_stat_statements
hypopg
pg_qualstats
auto_explain
index_advisor
pg_profile

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.8.0
18
17
16
15
14
 pg_hint_plan -
RPM
PGDG
 1.8.0
18
17
16
15
14
 pg_hint_plan_$v -
DEB
PGDG
 1.8.0
18
17
16
15
14
 postgresql-$v-pg-hint-plan -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
el8.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
el9.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
el9.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
el10.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
el10.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
d12.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
d12.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
d13.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
d13.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
u22.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
u22.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
u24.x86_64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
u24.aarch64
PGDG 1.8.0
PGDG 1.7.1
PGDG 1.6.2
PGDG 1.5.3
PGDG 1.4.4
Package Version OS ORG SIZE File URL
pg_hint_plan_18 1.8.0 el8.x86_64 pgdg 55.3 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_18 1.8.0 el8.aarch64 pgdg 51.7 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_18 1.8.0 el9.x86_64 pgdg 54.4 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_18 1.8.0 el9.aarch64 pgdg 52.5 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_18 1.8.0 el10.x86_64 pgdg 55.5 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel10.x86_64.rpm
pg_hint_plan_18 1.8.0 el10.aarch64 pgdg 53.7 KiB pg_hint_plan_18-1.8.0-1PGDG.rhel10.aarch64.rpm
postgresql-18-pg-hint-plan 1.8.0 d12.x86_64 pgdg 132.8 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg12+1_amd64.deb
postgresql-18-pg-hint-plan 1.8.0 d12.aarch64 pgdg 128.8 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg12+1_arm64.deb
postgresql-18-pg-hint-plan 1.8.0 d13.x86_64 pgdg 133.2 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg13+1_amd64.deb
postgresql-18-pg-hint-plan 1.8.0 d13.aarch64 pgdg 128.8 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg13+1_arm64.deb
postgresql-18-pg-hint-plan 1.8.0 u22.x86_64 pgdg 133.8 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg22.04+1_amd64.deb
postgresql-18-pg-hint-plan 1.8.0 u22.aarch64 pgdg 129.8 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg22.04+1_arm64.deb
postgresql-18-pg-hint-plan 1.8.0 u24.x86_64 pgdg 131.7 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg24.04+1_amd64.deb
postgresql-18-pg-hint-plan 1.8.0 u24.aarch64 pgdg 128.0 KiB postgresql-18-pg-hint-plan_1.8.0-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_hint_plan_17 1.7.1 el8.x86_64 pgdg 53.2 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_17 1.7.0 el8.x86_64 pgdg 51.4 KiB pg_hint_plan_17-1.7.0-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_17 1.7.1 el8.aarch64 pgdg 50.0 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_17 1.7.0 el8.aarch64 pgdg 48.2 KiB pg_hint_plan_17-1.7.0-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_17 1.7.1 el9.x86_64 pgdg 52.6 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_17 1.7.0 el9.x86_64 pgdg 50.7 KiB pg_hint_plan_17-1.7.0-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_17 1.7.1 el9.aarch64 pgdg 50.6 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_17 1.7.0 el9.aarch64 pgdg 49.0 KiB pg_hint_plan_17-1.7.0-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_17 1.7.1 el10.x86_64 pgdg 53.6 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel10.x86_64.rpm
pg_hint_plan_17 1.7.0 el10.x86_64 pgdg 52.0 KiB pg_hint_plan_17-1.7.0-3PGDG.rhel10.x86_64.rpm
pg_hint_plan_17 1.7.1 el10.aarch64 pgdg 52.1 KiB pg_hint_plan_17-1.7.1-1PGDG.rhel10.aarch64.rpm
pg_hint_plan_17 1.7.0 el10.aarch64 pgdg 50.4 KiB pg_hint_plan_17-1.7.0-3PGDG.rhel10.aarch64.rpm
postgresql-17-pg-hint-plan 1.7.1 d12.x86_64 pgdg 128.0 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg12+1_amd64.deb
postgresql-17-pg-hint-plan 1.7.1 d12.aarch64 pgdg 123.9 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg12+1_arm64.deb
postgresql-17-pg-hint-plan 1.7.1 d13.x86_64 pgdg 128.4 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_amd64.deb
postgresql-17-pg-hint-plan 1.7.1 d13.aarch64 pgdg 124.3 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg13+1_arm64.deb
postgresql-17-pg-hint-plan 1.7.1 u22.x86_64 pgdg 140.9 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg22.04+1_amd64.deb
postgresql-17-pg-hint-plan 1.7.1 u22.aarch64 pgdg 137.2 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg22.04+1_arm64.deb
postgresql-17-pg-hint-plan 1.7.1 u24.x86_64 pgdg 126.7 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg24.04+1_amd64.deb
postgresql-17-pg-hint-plan 1.7.1 u24.aarch64 pgdg 123.4 KiB postgresql-17-pg-hint-plan_1.7.1-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_hint_plan_16 1.6.2 el8.x86_64 pgdg 45.8 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_16 1.6.1 el8.x86_64 pgdg 44.2 KiB pg_hint_plan_16-1.6.1-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_16 1.6.0 el8.x86_64 pgdg 42.6 KiB pg_hint_plan_16-1.6.0-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_16 1.6.2 el8.aarch64 pgdg 43.4 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_16 1.6.1 el8.aarch64 pgdg 41.8 KiB pg_hint_plan_16-1.6.1-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_16 1.6.0 el8.aarch64 pgdg 40.2 KiB pg_hint_plan_16-1.6.0-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_16 1.6.2 el9.x86_64 pgdg 46.5 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_16 1.6.1 el9.x86_64 pgdg 44.9 KiB pg_hint_plan_16-1.6.1-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_16 1.6.0 el9.x86_64 pgdg 43.2 KiB pg_hint_plan_16-1.6.0-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_16 1.6.2 el9.aarch64 pgdg 45.0 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_16 1.6.1 el9.aarch64 pgdg 43.5 KiB pg_hint_plan_16-1.6.1-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_16 1.6.0 el9.aarch64 pgdg 41.6 KiB pg_hint_plan_16-1.6.0-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_16 1.6.2 el10.x86_64 pgdg 47.7 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel10.x86_64.rpm
pg_hint_plan_16 1.6.1 el10.x86_64 pgdg 46.2 KiB pg_hint_plan_16-1.6.1-3PGDG.rhel10.x86_64.rpm
pg_hint_plan_16 1.6.2 el10.aarch64 pgdg 46.0 KiB pg_hint_plan_16-1.6.2-1PGDG.rhel10.aarch64.rpm
pg_hint_plan_16 1.6.1 el10.aarch64 pgdg 44.5 KiB pg_hint_plan_16-1.6.1-3PGDG.rhel10.aarch64.rpm
postgresql-16-pg-hint-plan 1.6.2 d12.x86_64 pgdg 104.6 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg12+1_amd64.deb
postgresql-16-pg-hint-plan 1.6.2 d12.aarch64 pgdg 101.6 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg12+1_arm64.deb
postgresql-16-pg-hint-plan 1.6.2 d13.x86_64 pgdg 104.8 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg13+1_amd64.deb
postgresql-16-pg-hint-plan 1.6.2 d13.aarch64 pgdg 101.9 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg13+1_arm64.deb
postgresql-16-pg-hint-plan 1.6.2 u22.x86_64 pgdg 117.2 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg22.04+1_amd64.deb
postgresql-16-pg-hint-plan 1.6.2 u22.aarch64 pgdg 114.4 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg22.04+1_arm64.deb
postgresql-16-pg-hint-plan 1.6.2 u24.x86_64 pgdg 104.4 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg24.04+1_amd64.deb
postgresql-16-pg-hint-plan 1.6.2 u24.aarch64 pgdg 101.7 KiB postgresql-16-pg-hint-plan_1.6.2-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_hint_plan_15 1.5.3 el8.x86_64 pgdg 45.3 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_15 1.5.2 el8.x86_64 pgdg 43.7 KiB pg_hint_plan_15-1.5.2-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_15 1.5.1 el8.x86_64 pgdg 48.9 KiB pg_hint_plan_15-1.5.1-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_15 1.5.3 el8.aarch64 pgdg 43.0 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_15 1.5.2 el8.aarch64 pgdg 41.5 KiB pg_hint_plan_15-1.5.2-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_15 1.5.1 el8.aarch64 pgdg 46.6 KiB pg_hint_plan_15-1.5.1-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_15 1.5.3 el9.x86_64 pgdg 46.0 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_15 1.5.2 el9.x86_64 pgdg 44.7 KiB pg_hint_plan_15-1.5.2-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_15 1.5.1 el9.x86_64 pgdg 49.4 KiB pg_hint_plan_15-1.5.1-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_15 1.5.3 el9.aarch64 pgdg 44.5 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_15 1.5.2 el9.aarch64 pgdg 43.1 KiB pg_hint_plan_15-1.5.2-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_15 1.5.1 el9.aarch64 pgdg 47.8 KiB pg_hint_plan_15-1.5.1-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_15 1.5.3 el10.x86_64 pgdg 47.4 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel10.x86_64.rpm
pg_hint_plan_15 1.5.2 el10.x86_64 pgdg 46.2 KiB pg_hint_plan_15-1.5.2-3PGDG.rhel10.x86_64.rpm
pg_hint_plan_15 1.5.3 el10.aarch64 pgdg 45.5 KiB pg_hint_plan_15-1.5.3-1PGDG.rhel10.aarch64.rpm
pg_hint_plan_15 1.5.2 el10.aarch64 pgdg 44.2 KiB pg_hint_plan_15-1.5.2-3PGDG.rhel10.aarch64.rpm
postgresql-15-pg-hint-plan 1.5.3 d12.x86_64 pgdg 104.4 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg12+1_amd64.deb
postgresql-15-pg-hint-plan 1.5.3 d12.aarch64 pgdg 101.2 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg12+1_arm64.deb
postgresql-15-pg-hint-plan 1.5.3 d13.x86_64 pgdg 104.8 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg13+1_amd64.deb
postgresql-15-pg-hint-plan 1.5.3 d13.aarch64 pgdg 101.7 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg13+1_arm64.deb
postgresql-15-pg-hint-plan 1.5.3 u22.x86_64 pgdg 117.1 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg22.04+1_amd64.deb
postgresql-15-pg-hint-plan 1.5.3 u22.aarch64 pgdg 114.0 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg22.04+1_arm64.deb
postgresql-15-pg-hint-plan 1.5.3 u24.x86_64 pgdg 104.4 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg24.04+1_amd64.deb
postgresql-15-pg-hint-plan 1.5.3 u24.aarch64 pgdg 101.4 KiB postgresql-15-pg-hint-plan_1.5.3-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_hint_plan_14 1.4.4 el8.x86_64 pgdg 44.6 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_14 1.4.3 el8.x86_64 pgdg 43.3 KiB pg_hint_plan_14-1.4.3-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_14 1.4.2 el8.x86_64 pgdg 42.0 KiB pg_hint_plan_14-1.4.2-1PGDG.rhel8.x86_64.rpm
pg_hint_plan_14 1.4.4 el8.aarch64 pgdg 42.3 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_14 1.4.3 el8.aarch64 pgdg 41.0 KiB pg_hint_plan_14-1.4.3-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_14 1.4.2 el8.aarch64 pgdg 39.7 KiB pg_hint_plan_14-1.4.2-1PGDG.rhel8.aarch64.rpm
pg_hint_plan_14 1.4.4 el9.x86_64 pgdg 45.4 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_14 1.4.3 el9.x86_64 pgdg 44.2 KiB pg_hint_plan_14-1.4.3-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_14 1.4.2 el9.x86_64 pgdg 42.8 KiB pg_hint_plan_14-1.4.2-1PGDG.rhel9.x86_64.rpm
pg_hint_plan_14 1.4.4 el9.aarch64 pgdg 43.9 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_14 1.4.3 el9.aarch64 pgdg 42.7 KiB pg_hint_plan_14-1.4.3-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_14 1.4.2 el9.aarch64 pgdg 41.2 KiB pg_hint_plan_14-1.4.2-1PGDG.rhel9.aarch64.rpm
pg_hint_plan_14 1.4.4 el10.x86_64 pgdg 46.8 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel10.x86_64.rpm
pg_hint_plan_14 1.4.3 el10.x86_64 pgdg 45.6 KiB pg_hint_plan_14-1.4.3-3PGDG.rhel10.x86_64.rpm
pg_hint_plan_14 1.4.4 el10.aarch64 pgdg 44.9 KiB pg_hint_plan_14-1.4.4-1PGDG.rhel10.aarch64.rpm
pg_hint_plan_14 1.4.3 el10.aarch64 pgdg 43.7 KiB pg_hint_plan_14-1.4.3-3PGDG.rhel10.aarch64.rpm
postgresql-14-pg-hint-plan 1.4.4 d12.x86_64 pgdg 104.1 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg12+1_amd64.deb
postgresql-14-pg-hint-plan 1.4.4 d12.aarch64 pgdg 100.8 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg12+1_arm64.deb
postgresql-14-pg-hint-plan 1.4.4 d13.x86_64 pgdg 104.5 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg13+1_amd64.deb
postgresql-14-pg-hint-plan 1.4.4 d13.aarch64 pgdg 101.1 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg13+1_arm64.deb
postgresql-14-pg-hint-plan 1.4.4 u22.x86_64 pgdg 116.6 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg22.04+1_amd64.deb
postgresql-14-pg-hint-plan 1.4.4 u22.aarch64 pgdg 113.5 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg22.04+1_arm64.deb
postgresql-14-pg-hint-plan 1.4.4 u24.x86_64 pgdg 104.4 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg24.04+1_amd64.deb
postgresql-14-pg-hint-plan 1.4.4 u24.aarch64 pgdg 101.1 KiB postgresql-14-pg-hint-plan_1.4.4-1.pgdg24.04+1_arm64.deb

Source

Repository
github.com/ossc-db/pg_hint_plan
 Source Tarball
pg_hint_plan-REL18_1_8_0.tar.gz

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_hint_plan;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION pg_hint_plan;
Last updated on
jsqueryhypopg