Komzpa/gevel_postgis.md

Last active May 7, 2021 00:35

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Komzpa/f9e1c241d1d2a27cf5a4f985f646f8a6.js"></script>
Save Komzpa/f9e1c241d1d2a27cf5a4f985f646f8a6 to your computer and use it in GitHub Desktop.

Download ZIP

Visualize PostGIS index using Gevel in Postgres 9.6

Raw

gevel_postgis.md

Visualize PostGIS index using Gevel in Postgres 9.6:

git clone git://sigaev.ru/gevel
cd gevel
git checkout bd8b8b031a8049a6e7c18c00946bfbd99d75d27f
USE_PGXS=1 make
sudo USE_PGXS=1 make install
psql -f /usr/share/postgresql/9.6/contrib/gevel.sql

psql

drop table if exists idx_vis; 
create table idx_vis as (select level, replace(a::text, '2DF', '')::box2d::geometry as geom from gist_print('idx') as t(level int, valid bool, a box2df));

salahelfarissi commented Apr 7, 2021

Hi,
I tried installing gevel on ubuntu,
USE_PGXS=1 make
gives errors regarding some *.h files,
also am I supposed to install gist_rtree module on top of my database before installing gevel

Thank you for your time.

Author

Komzpa commented Apr 7, 2021

@salahelfarissi please check you're using latest development versions of Postgres or a matching version of gevel. since it's a dev tool you're expected to be able to handle the issues yourself.