Re: New SQL counter statistics view (pg_stat_sql) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: New SQL counter statistics view (pg_stat_sql)
Date
Msg-id 28917.1471897626@sss.pgh.pa.us
Whole thread Raw
In response to Re: New SQL counter statistics view (pg_stat_sql)  (Andres Freund <andres@anarazel.de>)
Responses Re: New SQL counter statistics view (pg_stat_sql)  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: New SQL counter statistics view (pg_stat_sql)  (neha khatri <nehakhatri5@gmail.com>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2016-08-22 13:54:43 -0400, Robert Haas wrote:
>> On Sat, Aug 20, 2016 at 11:17 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> I'm inclined to suggest you forget this approach and propose a single
>>> counter for "SQL commands executed", which avoids all of the above
>>> definitional problems.  People who need more detail than that are
>>> probably best advised to look to contrib/pg_stat_statements, anyway.

>> I disagree.  I think SQL commands executed, lumping absolutely
>> everything together, really isn't much use.

> I'm inclined to agree. I think that's a quite useful stat when looking
> at an installation one previously didn't have a lot of interaction with.

Well, let's at least have an "other" category so you can add up the
counters and get a meaningful total.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: distinct estimate of a hard-coded VALUES list
Next
From: Robert Haas
Date:
Subject: Re: Logical decoding of sequence advances, part II