Re: Add min and max execute statement time in pg_stat_statement - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Add min and max execute statement time in pg_stat_statement
Date
Msg-id 54E29FF4.5070304@dunslane.net
Whole thread Raw
In response to Re: Add min and max execute statement time in pg_stat_statement  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: Add min and max execute statement time in pg_stat_statement  (Andrew Dunstan <andrew@dunslane.net>)
Re: Add min and max execute statement time in pg_stat_statement  (Petr Jelinek <petr@2ndquadrant.com>)
List pgsql-hackers
On 02/16/2015 08:48 PM, Petr Jelinek wrote:
> On 17/02/15 01:57, Peter Geoghegan wrote:
>> On Mon, Feb 16, 2015 at 4:44 PM, Petr Jelinek <petr@2ndquadrant.com> 
>> wrote:
>>> We definitely want this feature, I wished to have this info many times.
>>
>> I would still like to see a benchmark.
>>
>>
>
> Average of 3 runs of read-only pgbench on my system all with 
> pg_stat_statement activated:
> HEAD:  20631
> SQRT:  20533
> SQRTD: 20592
>
>


So using sqrtd the cost is 0.18%. I think that's acceptable.

cheers

andrew



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Add min and max execute statement time in pg_stat_statement
Next
From: Andrew Dunstan
Date:
Subject: Re: Add min and max execute statement time in pg_stat_statement