PATCH: pgbench - aggregation of info written into log - Mailing list pgsql-hackers

From Tomas Vondra
Subject PATCH: pgbench - aggregation of info written into log
Date
Msg-id 3ff90ff746ea4963f76e458235598228.squirrel@sq.gransy.com
Whole thread Raw
Responses Re: PATCH: pgbench - aggregation of info written into log
Re: PATCH: pgbench - aggregation of info written into log
List pgsql-hackers
Hi,

this patch adds support for aggregation of info written into the log.
Instead of info about each transaction, a summary for time intervals (with
custom length) is written into the log. All you need to do is add "-A
seconds", e.g.

  $ pgbench -T 3600 -A 10 -l db

which will produce log with 10-second summaries, containing interval start
timestamp, number of transactions, sum of latencies, sum of 2nd power of
latencies, min and max latency (it's done this way to allow handling of
multiple logs produced by "-j" option).

This patch is a bit less polished (and more complex) than the other
pgbench patch I've sent a while back, and I'm not sure how to handle the
Windows branch. That needs to be fixed during the commit fest.

kind regards
Tomas
Attachment

pgsql-hackers by date:

Previous
From: "Tomas Vondra"
Date:
Subject: PATCH: pgbench - random sampling of transaction written into log
Next
From: Andres Freund
Date:
Subject: Re: plperl sigfpe reset can crash the server