| From: | Florian Pflug <fgp(at)phlo(dot)org> |
|---|---|
| To: | PostgreSQL-development hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Patch to show individual statement latencies in pgbench output |
| Date: | 2010-06-12 15:07:05 |
| Message-ID: | CB32F315-DF47-48DC-8BCC-98C73612F78F@phlo.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the average latency of each individual statement. The idea is to be able to compare the latency of the COMMIT with the ones of the other statements.
This patch adds two new finds to the Command struct, elapsed and cnt, which accumulate the total time spent on each statement and the number of times it was executed. printResults essentially prings elapsed/cnt for each statement, followed by the statement itself.
Patch is attached.
best regards,
Florian Pflug
| Attachment | Content-Type | Size |
|---|---|---|
| pgbench_statementlatency.patch | application/octet-stream | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-06-12 15:49:45 | Re: Idea for getting rid of VACUUM FREEZE on cold pages |
| Previous Message | Pavel Baros | 2010-06-12 14:18:38 | GSoC - Materialized Views - is stale or fresh? |