Message-ID: <181170a8-cf42-9e00-84a8-84944f4d0558@gmail.com>
Date: Tue, 7 Dec 2021 09:12:58 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.3.0
Subject: Re: Transaction Size in PostgreSQL
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAGH8HirGbc_=EU3GYBWQYnofWU2y_ygjP=1gzp-j6wmE3CSMtQ@mail.gmail.com>
 <CAKFQuwajBNigQZ=mU3_hG_-3uNcAzk6j_hPRSH=YDRU_ZKcZUA@mail.gmail.com>
 <CAGH8HiqXBToqe_EVqCxPaV1ZP+vKA9hQDvLEFE-UYRkR+RzwEw@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: 
 <CAGH8HiqXBToqe_EVqCxPaV1ZP+vKA9hQDvLEFE-UYRkR+RzwEw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/181170a8-cf42-9e00-84a8-84944f4d0558%40gmail.com>
Precedence: bulk

On 12/7/21 00:13, Sivasamy Subramaniam wrote:
> 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.

You will have to build such tool into the application. Application will 
have to monitor pg_stat_xact_user_tables and send alert if the alert 
threshold is exceeded. That will make the application unnecessarily 
complex and will also impact the performance. This falls into the "no 
can do" category.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com