Patch to show individual statement latencies in pgbench output - Mailing list pgsql-hackers

From Florian Pflug
Subject Patch to show individual statement latencies in pgbench output
Date
Msg-id CB32F315-DF47-48DC-8BCC-98C73612F78F@phlo.org
Whole thread Raw
Responses Re: Patch to show individual statement latencies in pgbench output  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
Hi

To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the
averagelatency of each individual statement. The idea is to be able to compare the latency of the COMMIT with the ones
ofthe other statements. 

This patch adds two new finds to the Command struct, elapsed and cnt, which accumulate the total time spent on each
statementand the number of times it was executed. printResults essentially prings elapsed/cnt for each statement,
followedby the statement itself. 

Patch is attached.

best regards,
Florian Pflug

Attachment

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: hstore ==> and deprecate =>
Next
From: Bruce Momjian
Date:
Subject: Re: Idea for getting rid of VACUUM FREEZE on cold pages