[postgis-users] statistics on a spatial index

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Tue Jun 14 23:17:54 PDT 2011


On 09/06/11 20:08, Oleksiy Karpenko wrote:

> Hi,
>
> How can I obtain various statistics on an existing index in the
> database? For example, number of levels, average MBR size by each
> dimension, and so on?

If you wish to start looking at the R-Tree structure then I would start 
by looking at Oleg and Teodor's gevel utility:

http://www.sai.msu.su/~megera/postgres/gist/

One day we should probably think about adding something like this into 
the main codebase...


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs



More information about the postgis-users mailing list