pg_track_optimizer

Extensions

pg_track_optimizer

pg_track_optimizer : Track planning decisions in comparison with execution reality

Overview

ID	Extension	Package	Version	Category	License	Language
6270	pg_track_optimizer	pg_track_optimizer	`0.9.1`	STAT	MIT	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd-r	No	Yes	Yes	Yes	yes	no

Relationships
See Also	pg_track_settings pg_show_plans powa pg_stat_statements pg_store_plans auto_explain pg_stat_kcache pg_qualstats

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`0.9.1`	18 17 16 15 14 13	`pg_track_optimizer`	-
RPM	PIGSTY	`0.9.1`	18 17 16 15 14 13	`pg_track_optimizer_$v`	-
DEB	PIGSTY	`0.9.1`	18 17 16 15 14 13	`postgresql-$v-pg-track-optimizer`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
el8.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
el9.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
el9.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
el10.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
el10.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
d12.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
d12.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
d13.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
d13.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
u22.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
u22.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
u24.x86_64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS
u24.aarch64	PIGSTY 0.9.1	PIGSTY 0.9.1	MISS	MISS	MISS	MISS

Package	Version	OS	ORG	SIZE	File URL
`pg_track_optimizer_18`	`0.9.1`	el8.x86_64	pigsty	35.2 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el8.x86_64.rpm
`pg_track_optimizer_18`	`0.9.1`	el8.aarch64	pigsty	34.4 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el8.aarch64.rpm
`pg_track_optimizer_18`	`0.9.1`	el9.x86_64	pigsty	34.9 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el9.x86_64.rpm
`pg_track_optimizer_18`	`0.9.1`	el9.aarch64	pigsty	34.6 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el9.aarch64.rpm
`pg_track_optimizer_18`	`0.9.1`	el10.x86_64	pigsty	34.9 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el10.x86_64.rpm
`pg_track_optimizer_18`	`0.9.1`	el10.aarch64	pigsty	35.0 KiB	pg_track_optimizer_18-0.9.1-1PIGSTY.el10.aarch64.rpm
`postgresql-18-pg-track-optimizer`	`0.9.1`	d12.x86_64	pigsty	57.8 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~bookworm_amd64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	d12.aarch64	pigsty	56.9 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~bookworm_arm64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	d13.x86_64	pigsty	57.9 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~trixie_amd64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	d13.aarch64	pigsty	57.1 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~trixie_arm64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	u22.x86_64	pigsty	62.6 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~jammy_amd64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	u22.aarch64	pigsty	62.0 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~jammy_arm64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	u24.x86_64	pigsty	60.4 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~noble_amd64.deb
`postgresql-18-pg-track-optimizer`	`0.9.1`	u24.aarch64	pigsty	59.8 KiB	postgresql-18-pg-track-optimizer_0.9.1-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_track_optimizer_17`	`0.9.1`	el8.x86_64	pigsty	35.2 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el8.x86_64.rpm
`pg_track_optimizer_17`	`0.9.1`	el8.aarch64	pigsty	34.4 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el8.aarch64.rpm
`pg_track_optimizer_17`	`0.9.1`	el9.x86_64	pigsty	34.9 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el9.x86_64.rpm
`pg_track_optimizer_17`	`0.9.1`	el9.aarch64	pigsty	34.6 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el9.aarch64.rpm
`pg_track_optimizer_17`	`0.9.1`	el10.x86_64	pigsty	34.8 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el10.x86_64.rpm
`pg_track_optimizer_17`	`0.9.1`	el10.aarch64	pigsty	35.0 KiB	pg_track_optimizer_17-0.9.1-1PIGSTY.el10.aarch64.rpm
`postgresql-17-pg-track-optimizer`	`0.9.1`	d12.x86_64	pigsty	57.6 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~bookworm_amd64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	d12.aarch64	pigsty	56.8 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~bookworm_arm64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	d13.x86_64	pigsty	57.8 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~trixie_amd64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	d13.aarch64	pigsty	56.9 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~trixie_arm64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	u22.x86_64	pigsty	69.2 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~jammy_amd64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	u22.aarch64	pigsty	68.4 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~jammy_arm64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	u24.x86_64	pigsty	60.3 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~noble_amd64.deb
`postgresql-17-pg-track-optimizer`	`0.9.1`	u24.aarch64	pigsty	59.6 KiB	postgresql-17-pg-track-optimizer_0.9.1-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/danolivo/pg_track_optimizer

Source Tarball

pg_track_optimizer-0.9.1.tar.gz

pig build pkg pg_track_optimizer;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_track_optimizer;		# install via package name, for the active PG version

pig install pg_track_optimizer -v 18;   # install for PG 18
pig install pg_track_optimizer -v 17;   # install for PG 17

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_track_optimizer';

Create this extension with:

CREATE EXTENSION pg_track_optimizer;

Last updated on 2026-02-13

pg_track_settings pg_wait_sampling