Patch to send transaction commit/rollback stats to the stats collector unconditionally. - Mailing list pgsql-hackers

From Gurjeet Singh
Subject Patch to send transaction commit/rollback stats to the stats collector unconditionally.
Date
Msg-id CABwTF4Wg03L2qH91m0spjk-p1=NCsf4WE5u6yvKpdgyoKRE9og@mail.gmail.com
Whole thread Raw
Responses Re: Patch to send transaction commit/rollback stats to the stats collector unconditionally.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Please find attached the patch to send transaction commit/rollback stats to stats collector unconditionally.

Without this patch, the transactions that do not read from/write to a database table do not get reported to the stats collector until the client disconnects. Hence the transaction counts in pg_stat_database do not increment gradually as one would expect them to. But when such a backend disconnects, the counts jump dramatically, giving the impression that the database processed a lot of transactions (potentially thousands) in an instant.

Best regards,
Attachment

pgsql-hackers by date:

Previous
From: Christian Kruse
Date:
Subject: Re: Patch: show relation and tuple infos of a lock to acquire
Next
From: Peter Geoghegan
Date:
Subject: Re: jsonb status