| From: | "Patil, Ravi" <Ravi(dot)Patil(at)FMR(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Cc: | "Patil, Ravi" <Ravi(dot)Patil(at)FMR(dot)com> |
| Subject: | How to find all SQLs executed by a transaction id? |
| Date: | 2022-04-19 12:35:21 |
| Message-ID: | BL1P105MB0325CDBE05AB0DEF901280F58EF29@BL1P105MB0325.NAMP105.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello All,
I am working on workload testing on a PostgreSQL database.
Use case: Run workload of 5000 to 11000 transactions and a transaction should have Inserts, Selects, Updates and Selects
I am using HammerDB, an open source tool to generate work load, and my question here is how to generate workload metrics by transactions per second.
Question: Is there a way to get a metrics of queries executed by transactions and the execution times of each SQL with a transaction?
Thanks,
Ravi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sbob | 2022-04-19 21:00:09 | significant jump in sql statement timing for on server vs a remote connection |
| Previous Message | Goti | 2022-04-18 14:31:11 | Re: How to find the final transformed query in postgresql |