select open change scope Open full search

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

Extensions / Monitoring

pg_track_optimizer

Track planning decisions in comparison with execution reality

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

Overview

Packagepg_track_optimizer
Version0.9.2
PostgreSQL versions17 · 18
RepositoryPIGSTY
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_track_optimizer
Stars33
Latest commit2026-08-28
Latest release2026-03-19
Catalogue updated2026-08-30

Related extensions

See also

online_advisorSuggest missing indexes and extended statistics online
pg_qualstatsAn extension collecting statistics about quals
hypopgHypothetical indexes for PostgreSQL
index_advisorQuery index advisor
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_relusageLog all the queries that reference a particular column
pg_stromPG-Strom - big-data processing acceleration using GPU and NVME
pg_orcaORCA query optimizer as a PostgreSQL extension