Patch to show individual statement latencies in pgbench output

Поиск
Список
Период
Сортировка
От Florian Pflug
Тема Patch to show individual statement latencies in pgbench output
Дата
Msg-id CB32F315-DF47-48DC-8BCC-98C73612F78F@phlo.org
обсуждение исходный текст
Ответы Re: Patch to show individual statement latencies in pgbench output  (Greg Smith <greg@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: hstore ==> and deprecate =>
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Idea for getting rid of VACUUM FREEZE on cold pages