Postgres Pro
Downloads
Home   >   mailing lists

How to find all SQLs executed by a transaction id? - Mailing list pgsql-performance

From Patil, Ravi
Subject How to find all SQLs executed by a transaction id?
Date
Msg-id BL1P105MB0325CDBE05AB0DEF901280F58EF29@BL1P105MB0325.NAMP105.PROD.OUTLOOK.COM
Whole thread Raw
List pgsql-performance
Tree view

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

 

 

pgsql-performance by date:

Previous
From: Goti
Date:
Subject: Re: How to find the final transformed query in postgresql
Next
From: Sbob
Date:
Subject: significant jump in sql statement timing for on server vs a remote connection