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.
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).
