Give PostgreSQL ability to manually force some decisions in execution plans.
pgext.cloud · Source code · License text · Control file · PGXN
| Package | pg_hint_plan |
|---|---|
| Version | 1.8.0 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PGDG |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | pg_hint_plan |
| Schema | hint_plan |
| Stars | 913 |
| Latest commit | 2026-07-25 |
| Latest release | 2025-08-19 |
| Catalogue updated | 2026-08-30 |
| pg_plan_advsr | Automated execution plan tuning extension |
| hypopg | Hypothetical indexes for PostgreSQL |
| online_advisor | Suggest missing indexes and extended statistics online |
| pg_qualstats | An extension collecting statistics about quals |
| index_advisor | Query index advisor |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| plan_filter | filter statements by their execution plans. |
| pg_strom | PG-Strom - big-data processing acceleration using GPU and NVME |
| pg_orca | ORCA query optimizer as a PostgreSQL extension |
| pg_regresql | Trust pg_class statistics for planning instead of physical relation size |
| pg_track_optimizer | Track planning decisions in comparison with execution reality |