Transaction size meaning, for example - any transaction over 1GB in size? I am looking to set up an alert if any massive data changes are happening in a single transaction. I can do it for long running transactions or query but trying to figure out any easy way to calculate the amount of data changes per transaction.
On Monday, December 6, 2021, Sivasamy Subramaniam <sivasamyinfo@gmail.com> wrote:
I need a query or a way to find the transaction size in postgreSQL. Can any one provide SQL or a method to figure this out?
That doesn’t exist, or is even particularly well defined, that I know of. You may want to phrase your question using more detail. Though I suspect your best avenue would be WAL decoding (but that’s well outside my experience).
David J.
--
Thank you,
Siva.