| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | "John R(dot) Allgood" <john(at)turbocorp(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Determine Transactions Per Second |
| Date: | 2006-08-16 17:36:54 |
| Message-ID: | 1155749814.24073.3.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-08-16 17:38:41 | Re: [NOVICE] DB insert Error |
| Previous Message | Guy Rouillier | 2006-08-16 16:37:23 | Re: [NOVICE] DB insert Error |