Skip to content

A little tool to display your postgres BTree indexes in an html using pageinspect data

Notifications You must be signed in to change notification settings

louiseGrandjonc/pageinspect_inspector

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 

Repository files navigation

PageInspect inspector

Hello and welcome,

For some reason you're here wondering if you can use this tool to visualize the internal structure of an index of yours.

It requires python3.6.*. You'll also have to install pageinspect (https://www.postgresql.org/docs/10/static/pageinspect.html) extension. If you want to use this tool for GiST indexes, you'll have to install gevel (http://www.sai.msu.su/~megera/wiki/Gevel) postgres extensions.

You can clone this and then run

python setup.py develop

The command line is then

python inspector/command.py --host <host> --port <port> --db <your_db> --user <youruser> --index <index_name> --path <your_path>

It will generate a wonderful html. The path is the path of the html file to be saved.

Right now it only works with BTree and GiST. I will add BRIN index eventually :)

About

A little tool to display your postgres BTree indexes in an html using pageinspect data

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published