Thread: Determine Transactions Per Second

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

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