[postgis-users] evaluation tools?

Biddy newskatze at riomhphost.net
Wed Jun 2 07:28:10 PDT 2010


Hi Christian,

thanks for the quick answer.
My result set for that query is empty though.

B.

Zitat von Christian Schwartze <christian.schwartze at uni-jena.de>:

>
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>







More information about the postgis-users mailing list