Re: PATCH: pgbench - aggregation of info written into log

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: PATCH: pgbench - aggregation of info written into log
Дата
Msg-id b1a0ba81a3ff3735ba62d165cb672d53.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на PATCH: pgbench - aggregation of info written into log  ("Tomas Vondra" <tv@fuzzy.cz>)
Список 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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: plperl sigfpe reset can crash the server
Следующее
От: Andres Freund
Дата:
Сообщение: Re: plperl sigfpe reset can crash the server