[postgis-users] evaluation tools?

[Christian Schwartze]

Perhaps, one starting point may be:

    select relpages from pg_class where relname='<your_table_name>_pk'

Christian


--------------------------------------------------
From: "Biddy" <newskatze at riomhphost.net>
Sent: Wednesday, June 02, 2010 4:13 PM
To: <postgis-users at postgis.refractions.net>
Subject: [postgis-users] evaluation tools?

> Hi everyone,
> 
> I was wondering what is the best way in postgis to get  
> performance/benchmark infos about your database.
> 
> For example, where do I find how much physical space my index takes up  
> or the actual table? And how do you best record how long a typical  
> query takes - let's say I let it run for a 100 times over various  
> parts of the dataset from a little java program, how do I best collect  
> the times it took to execute the queries?
> 
> Thanks,
> B.
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users