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 по дате отправления: