pgbench progress with timestamp

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: pgbench progress with timestamp
Date: 2015-08-23 11:25:37
Message-ID: alpine.DEB.2.10.1508231317510.29146@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

It is not easy to compare events on a pgbench runs (oops, the tps is down)
with for instance events in postgres log, so as to figure out what may
have cause a given glitch.

This patches adds an option to replace the "time since pgbench run
started" with a timestamp in the progress report so that it is easier to
compare timelines.

Use milliseconds for consistency with the '%n' log_prefix patch currently
submitted by Tomas Vondra in the CF.

sh> ./pgbench -P 1 -N -T 100 -c 2
starting vacuum...end.
progress: 1.0 s, 546.0 tps, lat 3.619 ms stddev 4.426
progress: 2.0 s, 575.0 tps, lat 3.480 ms stddev 1.705

sh> ./pgbench -P 1 --progress-timestamp -N -T 100 -c 2
starting vacuum...end.
progress: 1440328800.064 s, 549.0 tps, lat 3.602 ms stddev 1.698
progress: 1440328801.064 s, 570.0 tps, lat 3.501 ms stddev 1.704


Attachment Content-Type Size
pgbench-progress-timestamp-1.patch text/x-diff 3.3 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-08-23 13:21:09 Re: New functions
Previous Message Fabien COELHO 2015-08-23 07:28:14 Re: PATCH: numeric timestamp in log_line_prefix