select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Features

index_advisor

Query index advisor

pgext.cloud · Source code · Website · License text · Control file

Overview

Packageindex_advisor
Version0.2.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
RelocatableYes
Stars1,706
Latest commit2024-04-14
Latest release2024-04-03
Catalogue updated2026-08-30

Related extensions

Requires

hypopgHypothetical indexes for PostgreSQL

See also

hypopgHypothetical indexes for PostgreSQL
online_advisorSuggest missing indexes and extended statistics online
pg_qualstatsAn extension collecting statistics about quals
pg_hint_planGive PostgreSQL ability to manually force some decisions in execution plans.
pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
plan_filterfilter statements by their execution plans.
pg_track_optimizerTrack planning decisions in comparison with execution reality
pg_stromPG-Strom - big-data processing acceleration using GPU and NVME
pg_orcaORCA query optimizer as a PostgreSQL extension
pg_relusageLog all the queries that reference a particular column