Extensions
index_advisor

index_advisor

index_advisor : Query index advisor

Overview

ID Extension Package Version Category License Language
2840
index_advisor
index_advisor
 0.2.0
FEAT
PostgreSQL
SQL
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
----d-r
No
No
No
Yes
yes
no
Relationships
See Also
hypopg
pg_qualstats
powa
pg_stat_statements
pg_hint_plan
auto_explain
pg_profile
pg_show_plans

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 0.2.0
18
17
16
15
14
13
 index_advisor -
RPM
PIGSTY
 0.2.0
18
17
16
15
14
13
 index_advisor_$v -
DEB
PIGSTY
 0.2.0
18
17
16
15
14
13
 postgresql-$v-index-advisor -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el8.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el10.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el10.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d12.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d12.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d13.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d13.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u22.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u22.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u24.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u24.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
Package Version OS ORG SIZE File URL
index_advisor_18 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_18-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_18 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_18-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_18 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_18-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_18 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_18-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_18 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_18-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_18 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_18-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-18-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-18-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-18-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-18-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-18-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-18-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-18-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-18-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-18-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
index_advisor_17 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_17-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_17 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_17-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_17 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_17-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_17 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_17-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_17 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_17-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_17 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_17-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-17-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-17-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-17-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-17-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-17-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-17-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-17-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
index_advisor_16 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_16-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_16 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_16-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_16 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_16-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_16 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_16-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_16 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_16-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_16 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_16-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-16-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-16-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-16-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-16-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-16-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-16-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-16-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
index_advisor_15 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_15-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_15 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_15-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_15 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_15-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_15 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_15-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_15 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_15-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_15 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_15-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-15-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-15-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-15-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-15-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-15-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-15-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-15-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
index_advisor_14 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_14-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_14 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_14-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_14 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_14-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_14 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_14-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_14 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_14-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_14 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_14-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-14-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-14-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-14-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-14-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-14-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-14-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-14-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
index_advisor_13 0.2.0 el8.x86_64 pigsty 10.2 KiB index_advisor_13-0.2.0-1PIGSTY.el8.x86_64.rpm
index_advisor_13 0.2.0 el8.aarch64 pigsty 10.2 KiB index_advisor_13-0.2.0-1PIGSTY.el8.aarch64.rpm
index_advisor_13 0.2.0 el9.x86_64 pigsty 10.1 KiB index_advisor_13-0.2.0-1PIGSTY.el9.x86_64.rpm
index_advisor_13 0.2.0 el9.aarch64 pigsty 10.1 KiB index_advisor_13-0.2.0-1PIGSTY.el9.aarch64.rpm
index_advisor_13 0.2.0 el10.x86_64 pigsty 10.2 KiB index_advisor_13-0.2.0-1PIGSTY.el10.x86_64.rpm
index_advisor_13 0.2.0 el10.aarch64 pigsty 10.2 KiB index_advisor_13-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-13-index-advisor 0.2.0 d12.x86_64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-index-advisor 0.2.0 d12.aarch64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-index-advisor 0.2.0 d13.x86_64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-13-index-advisor 0.2.0 d13.aarch64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-13-index-advisor 0.2.0 u22.x86_64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-13-index-advisor 0.2.0 u22.aarch64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-13-index-advisor 0.2.0 u24.x86_64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-13-index-advisor 0.2.0 u24.aarch64 pigsty 5.6 KiB postgresql-13-index-advisor_0.2.0-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/supabase/index_advisor
 Source Tarball
index_advisor-0.2.0.tar.gz
 
pig build pkg index_advisor;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

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

pig install index_advisor -v 18;   # install for PG 18
pig install index_advisor -v 17;   # install for PG 17
pig install index_advisor -v 16;   # install for PG 16
pig install index_advisor -v 15;   # install for PG 15
pig install index_advisor -v 14;   # install for PG 14
pig install index_advisor -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION index_advisor;
Last updated on
hypopgplan_filter