Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <karl@denninger.net>) id 1T3uRM-0006KR-37
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 19:48:40 +0000
Received: from wsip-70-169-168-7.pn.at.cox.net ([70.169.168.7]
	helo=FS.denninger.net) by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <karl@denninger.net>) id 1T3uRK-00018Q-0G
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 19:48:39 +0000
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by FS.denninger.net (8.14.4/8.13.1) with ESMTP id q7LJmZFd096607
	for <pgsql-performance@postgresql.org>;
	Tue, 21 Aug 2012 14:48:35 -0500 (CDT)
	(envelope-from karl@denninger.net)
Received: from [127.0.0.1] [192.168.1.40] by Spamblock-sys (LOCAL);
	Tue Aug 21 14:48:35 2012
Message-ID: <5033E60A.1030808@denninger.net>
Date: Tue, 21 Aug 2012 14:48:26 -0500
From: Karl Denninger <karl@denninger.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
To: Stephen Frost <sfrost@snowman.net>
CC: Rick Otten <rotten@manta.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: average query performance measuring
References: <362605510214004CB3313A03D3D697DE5508FF27@cmhvm005>
	<20120821185316.GN1267@tamriel.snowman.net>
In-Reply-To: <20120821185316.GN1267@tamriel.snowman.net>
X-Enigmail-Version: 1.4.3
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigC03B52E64EA03D1A16543729"
X-Antivirus: avast! (VPS 120821-0, 08/21/2012), Outbound message
X-Antivirus-Status: Clean
X-Pg-Spam-Score: -0.9 (/)
X-Archive-Number: 201208/140
X-Sequence-Number: 47678

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigC03B52E64EA03D1A16543729
Content-Type: multipart/alternative;
 boundary="------------030102000703020809050802"

This is a multi-part message in MIME format.
--------------030102000703020809050802
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


On 8/21/2012 1:53 PM, Stephen Frost wrote:
> * Rick Otten (rotten@manta.com) wrote:
>> It seems like we almost have everything we need to track this in the s=
tats tables, but not quite.  I was hoping the folks on this list would ha=
ve some tips on how to get query performance trends over time out of each=
 node in my cluster.
> I'm afraid the best answer to this is, honestly, "upgrade to 9.2 once
> it's out"..
>
> http://pgeoghegan.blogspot.com/2012/03/much-improved-statement-statisti=
cs.html
>
> If what's described there doesn't match what you're looking for, then
> please let us know what else you'd like, so we can further improve
> things in that area..
>
> 	Thanks,
>
> 		Stephen

That looks EXTREMELY useful and I'm looking forward to checking it out
in 9.2; I have asked a similar question about profiling actual queries
in the past and basically it came down to "turn on explain or run a
separate explain yourself since the app knows what's similar and what's
not", which of course has hideous performance implications (as the query
basically executes twice.)


--=20
-- Karl Denninger
/The Market Ticker =AE/ <http://market-ticker.org>
Cuda Systems LLC

--------------030102000703020809050802
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3DISO-8859-1"
      http-equiv=3D"Content-Type">
  </head>
  <body bgcolor=3D"#FFFFFF" text=3D"#000000">
    <br>
    <div class=3D"moz-cite-prefix">On 8/21/2012 1:53 PM, Stephen Frost
      wrote:<br>
    </div>
    <blockquote cite=3D"mid:20120821185316.GN1267@tamriel.snowman.net"
      type=3D"cite">
      <pre wrap=3D"">* Rick Otten (<a class=3D"moz-txt-link-abbreviated" =
href=3D"mailto:rotten@manta.com">rotten@manta.com</a>) wrote:
</pre>
      <blockquote type=3D"cite">
        <pre wrap=3D"">It seems like we almost have everything we need to=
 track this in the stats tables, but not quite.  I was hoping the folks o=
n this list would have some tips on how to get query performance trends o=
ver time out of each node in my cluster.
</pre>
      </blockquote>
      <pre wrap=3D"">
I'm afraid the best answer to this is, honestly, "upgrade to 9.2 once
it's out"..

<a class=3D"moz-txt-link-freetext" href=3D"http://pgeoghegan.blogspot.com=
/2012/03/much-improved-statement-statistics.html">http://pgeoghegan.blogs=
pot.com/2012/03/much-improved-statement-statistics.html</a>

If what's described there doesn't match what you're looking for, then
please let us know what else you'd like, so we can further improve
things in that area..

	Thanks,

		Stephen</pre>
    </blockquote>
    <br>
    That looks EXTREMELY useful and I'm looking forward to checking it
    out in 9.2; I have asked a similar question about profiling actual
    queries in the past and basically it came down to "turn on explain
    or run a separate explain yourself since the app knows what's
    similar and what's not", which of course has hideous performance
    implications (as the query basically executes twice.)<br>
    <br>
    <br>
    <div class=3D"moz-signature">-- <br>
      -- Karl Denninger<br>
      <a href=3D"http://market-ticker.org"><i>The Market Ticker &reg;</i>=
</a><br>
      Cuda Systems LLC</div>
  </body>
</html>

--------------030102000703020809050802--

--------------enigC03B52E64EA03D1A16543729
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJQM+YOAAoJEGAtiW4Ft0U9cEcIAJlaiaEeMO5LJYgndcaznOIv
qXQAK8p8VogLFDZwzc0v1hY7AlEXQ70m+KJJwISnPJAPxosFwJtOOLu4AbNsZUYe
xmYxLMpJ3YSVjPOsV+NXM67dEHUcnivXHUPsx8A4gZ9Bp7EQmXqfjn2453Qq9zUp
7teXcGA31tjR8mR/Mo6ZBA2kjWkKBvF3bh0McVExTR0vmVxR6sQcoGIOhdgfCsAz
oS5kFQGixE42jCdOCJYIrvpmfThmL6h+2zyRPlqNwQfxSXb3jn1J+0hpSVreVKRV
XWPqYOMOH2207nfYRYVgDK4clBEpb/34/7JL3iR1k1EN9ni4I4AJeY428ut48lY=
=dHmV
-----END PGP SIGNATURE-----

--------------enigC03B52E64EA03D1A16543729--