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.
