From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PATCH: pgbench - aggregation of info written into log |
Date: | 2012-08-24 21:44:24 |
Message-ID: | b1a0ba81a3ff3735ba62d165cb672d53.squirrel@sq.gransy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 24 Srpen 2012, 23:25, Tomas Vondra wrote:
> 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).
I've forgot to mention that just like the other patch, this is meant for
cases when you really don't need the raw per-transaction info, but
per-second summary is just enough. This is helpful especially when the
test produces a lot of transaction, thus huge log files etc.
So you can either log all the transactions and then post-process the huge
files, or completely skip that and just log the summaries.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2012-08-24 22:10:43 | Re: plperl sigfpe reset can crash the server |
Previous Message | Andres Freund | 2012-08-24 21:40:45 | Re: plperl sigfpe reset can crash the server |