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.
So if you truncate a 4GB table you want to know about it? I’m reasonably confident PostgreSQL does not have the tools needed to accomplish your goal at 100%. You can possibly pick up some subset though if you really want…
David J.