Re: Determine Transactions Per Second

От:

Jeff Davis <pgsql@j-davis.com>

Дата:

16 августа 2006 г. в 14:39:11

On Wed, 2006-08-16 at 10:24 -0400, John R. Allgood wrote:
>     I am needing to determine the tps for a production application
> running on PostgreSQL 7.4.7. I know you can use pg_bench and create a
> new database to determine an estimate of tps. Is there a way I can get
> this info out of my production database.
> 

Look in the pg_stat_database or pg_stat_get_db_xact_commit(oid) (where
oid is the oid of the database).

This number is reset when the statistics are reset, so it may not be the
number of transactions since the database was created. But you can use
it to test TPS easily.

Regards,
	Jeff Davis

Determine Transactions Per Second

От:

"John R. Allgood" <john@turbocorp.com>

Дата:

16 августа 2006 г. в 11:46:37

Hello

    I am needing to determine the tps for a production application
running on PostgreSQL 7.4.7. I know you can use pg_bench and create a
new database to determine an estimate of tps. Is there a way I can get
this info out of my production database.

Thanks

-- 
"What I've done, of course, is total garbage."
		-- R. Willard, Pure Math 430a