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

From Alvaro Herrera
Subject Re: Add min and max execute statement time in pg_stat_statement
Date
Msg-id 20131021220926.GC4987@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Add min and max execute statement time in pg_stat_statement  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: Add min and max execute statement time in pg_stat_statement
List pgsql-hackers
Gavin Flower wrote:

> One way it could be done, but even this would consume far too much
> storage and processing power (hence totally impractical), would be
> to 'simply' store a counter for each value found and increment it
> for each occurence...

An histogram?  Sounds like a huge lot of code complexity to me.  Not
sure the gain is enough.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Piotr Marcinczyk
Date:
Subject: Add \i option to bring in the specified file as a quoted literal
Next
From: Mark Kirkwood
Date:
Subject: Re: [PoC] pgstattuple2: block sampling to reduce physical read