Re: [postgis-users] statistics on a spatial index
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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] statistics on a spatial index
Is there any other mail list or group where I could get the answers to these questions? On Thu, Jun 9, 2011 at 2:08 PM, Oleksiy Karpenko oleksiy.karpe...@gmail.com 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? Regards, Oleksiy Karpenko ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] statistics on a spatial index
You can use explain function to get some information from any query on PostgreSQL Kind regards Jose El 13/06/2011 15:46, Oleksiy Karpenko oleksiy.karpe...@gmail.com escribió: Is there any other mail list or group where I could get the answers to these questions? On Thu, Jun 9, 2011 at 2:08 PM, Oleksiy Karpenko oleksiy.karpe...@gmail.com 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? Regards, Oleksiy Karpenko ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] statistics on a spatial index
You may want to ask on Postgresql's Admin or Performance mailing lists. -bborie On 06/13/2011 06:46 AM, Oleksiy Karpenko wrote: Is there any other mail list or group where I could get the answers to these questions? On Thu, Jun 9, 2011 at 2:08 PM, Oleksiy Karpenko oleksiy.karpe...@gmail.com 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? Regards, Oleksiy Karpenko ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] statistics on a spatial index
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? Regards, Oleksiy Karpenko ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users