Re: Transaction Size in PostgreSQL

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 Mon, Dec 6, 2021 at 8:04 PM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Monday, December 6, 2021, Sivasamy Subramaniam <sivasamyinfo(at)gmail(dot)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.