[postgis-users] evaluation tools?

[Paragon Corporation]

Biddy,

If you are using pgAdmin III 

Navigate to
Your database
     your schema
          tables
	Then click the statistics tab on the right side

It gives a nice summary of the size of each table in that schema

-- This article we wrote may be helpful to you too
http://www.postgresonline.com/journal/index.php?/archives/110-Determining-si
ze-of-database,-schema,-tables,-and-geometry.html

Leo and Regina
http://www.postgis.us 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Biddy
Sent: Wednesday, June 02, 2010 10:28 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] evaluation tools?

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
>




_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users