Store plan advice by query ID and automatically apply it during PostgreSQL query planning
pgext.cloud · Source code · Website · Documentation · License text · Control file
| Package | postgresql |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 19 |
| Repository | PostgreSQL contrib |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | pg_plan_advice, pg_stash_advice |
| Latest commit | 2026-07-06 |
| Catalogue updated | 2026-09-19 |
| pg_plan_advice | Describe and constrain planner choices with plan advice |
| planinstr | Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. |
| pargres | Prototype parallel query execution module for shared-nothing PostgreSQL clusters |
| pg_table_range | Planning-time partition pruning by per-partition data ranges, including non-key columns. |
| mv_rewrite | Query rewriting extension that transparently rewrites queries to use lower-cost materialized views. |
| pg_bofh | Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. |
| optpaths | Planner hook extension for adding paths and removing self joins |
| pathprobe | PostgreSQL planner path probing extension for planner-aware SQL agents |
| sql_saga_native | Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. |
| pg_plan_advice | Describe and constrain planner choices with plan advice |