[HACKERS] Patch to show individual statement latencies in pgbench output
in [PgSql]
|
Prev: [HACKERS] GSoC - Materialized Views - is stale or fresh?
Next: pg_regress --use-existing does not appear in--help
From: Florian Pflug on 12 Jun 2010 11:07 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 |