Suggest missing indexes and extended statistics online
pgext.cloud · Source code · Documentation · License text · Control file
| Package | online_advisor |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | Preloaded |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | online_advisor |
| Stars | 19 |
| Latest commit | 2026-03-18 |
| Latest release | 2025-06-04 |
| Catalogue updated | 2026-08-30 |
| pg_qualstats | An extension collecting statistics about quals |
| hypopg | Hypothetical indexes for PostgreSQL |
| index_advisor | Query index advisor |
| pg_hint_plan | Give PostgreSQL ability to manually force some decisions in execution plans. |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| plan_filter | filter statements by their execution plans. |
| pg_relusage | Log all the queries that reference a particular column |
| pg_track_optimizer | Track planning decisions in comparison with execution reality |
| pg_strom | PG-Strom - big-data processing acceleration using GPU and NVME |
| pg_orca | ORCA query optimizer as a PostgreSQL extension |