Re: New SQL counter statistics view (pg_stat_sql)

<div dir="ltr"><div class="gmail_extra"><br /><div class="gmail_quote">On Wed, Aug 24, 2016 at 10:07 AM, Gavin Flower
<spandir="ltr"><<a href="mailto:GavinFlower@archidevsys.co.nz"
target="_blank">GavinFlower@archidevsys.co.nz</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0
00 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 24/08/16 12:02, neha khatri wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""> >Andres
Freund<<a href="mailto:andres@anarazel.de" target="_blank">andres@anarazel.de</a> <mailto:<a
href="mailto:andres@anarazel.de"target="_blank">andres@anarazel.de</a>>> writes:<br /> >> On 2016-08-22
13:54:43-0400, Robert Haas wrote:<br /></span><span class=""> >> On Sat, Aug 20, 2016 at 11:17 AM, Tom Lane
<<ahref="mailto:tgl@sss.pgh.pa.us" target="_blank">tgl@sss.pgh.pa.us</a> <mailto:<a
href="mailto:tgl@sss.pgh.pa.us"target="_blank">tgl@sss.pgh.pa.us</a>>> wrote:<br /> >>>> I'm inclined
tosuggest you forget this approach and propose a single<br /> >>>> counter for "SQL commands executed",
whichavoids all of the above<br /> >>>> definitional problems.  People who need more detail than that
are<br/> >>>> probably best advised to look to contrib/pg_stat_statements, anyway.<br /><br /> >>>
Idisagree.  I think SQL commands executed, lumping absolutely<br /> >>> everything together, really isn't much
use.<br/><br /> >> I'm inclined to agree. I think that's a quite useful stat when looking<br /> >> at an
installationone previously didn't have a lot of interaction with.<br /><br /> >Well, let's at least have an "other"
categoryso you can add up the<br /> >counters and get a meaningful total.<br /><br /> How would that meaningful
totalmight help a user. What can a user might analyse with the counter in 'other' category.<br /><br /><br /><br
/></span></blockquote>The user could then judge if there were a significant number of examples not covered in the other
categories- this may, or may not, be a problem; depending on the use case.<br /><br /><br /> Cheers,<br /> Gavin<br
/><br/></blockquote></div>For the user to be able to judge that whether the number in the 'other' category is a problem
ornot, the user is also required to know what all might fall under the 'other' category. It may not be good to say that
_anything_that is not part of the already defined category is part of 'other'. Probably, 'other' should also be a set
ofpredefined operations.</div><div class="gmail_extra"><br /></div><div class="gmail_extra">Neha</div></div>