Re: pg_stat_statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_stat_statements
Date
Msg-id 14698.1213386467@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_stat_statements  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Fri, 2008-06-13 at 17:33 +0900, ITAGAKI Takahiro wrote:
>> We can write sql statements in server logs and gather them using some
>> tools (pgfouine and pqa) even now, but statement logging has
>> unignorable overhead.

> I would prefer to look at ways to reduce the current overhead rather
> than change to another system entirely. 

It's also the case that adding to the stats collector is hardly going to
have "ignorable" overhead.  (And you're dreaming if you think you can do
it like pg_stat_activity, because this can't be a fixed-size array with
a trivial indexing scheme.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses
Next
From: "Dickson S. Guedes"
Date:
Subject: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses