| From: | Gurjeet Singh <gurjeet(at)singh(dot)im> |
|---|---|
| To: | PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Patch to send transaction commit/rollback stats to the stats collector unconditionally. |
| Date: | 2014-03-19 19:01:34 |
| Message-ID: | CABwTF4Wg03L2qH91m0spjk-p1=NCsf4WE5u6yvKpdgyoKRE9og@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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,
--
Gurjeet Singh http://gurjeet.singh.im/
| Attachment | Content-Type | Size |
|---|---|---|
| report_xact_stats_unconditionally.patch | text/x-diff | 1005 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2014-03-19 19:58:40 | Re: jsonb status |
| Previous Message | Christian Kruse | 2014-03-19 18:32:48 | Re: Patch: show relation and tuple infos of a lock to acquire |