| 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: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| 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
   ...
-- 
Fabien.
| Attachment | Content-Type | Size | 
|---|---|---|
| pgbench-progress-timestamp-1.patch | text/x-diff | 3.3 KB | 
| 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 |