On 7/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Interesting, Hubert.Where/how do you get the data for:- number of transactions per second
periodically (every 5 minutes) i do:select sum(xact_commit) + sum(xact_rollback) from pg_stat_databaseand then just check against previous value, and
There is a menu item under Display called System
Objects. Enable this, restart PgAdmin. Then when you connect youll
have all schemas/objects listed.
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of adey
Sent: 07 July 2006 1:26 am
To: pgsql-admin@postgresql.org;
Is there a query which can be issued which will return the size of a
database?
I see that in pgadmin you can get the values on a per table manner.
I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that information.
TIA,
Benjamin
On 7/7/06, Benjamin Krajmalnik [EMAIL PROTECTED] wrote:
Is there a query which can be issued which will return the size of adatabase?I see that in pgadmin you can get the values on a per table manner.I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that
If you have 8.1.x you can do something like this:
SELECT pg_size_pretty(database_size('database name'));
example:
SELECT pg_size_pretty(database_size('testdb'));
If you have another version of postgres, check out the dbsize contrib module.
On Fri, 7 Jul 2006, Benjamin Krajmalnik wrote:
Is