Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sfrost@tamriel.snowman.net>) id 1T3v2c-0003SE-L7
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 20:27:10 +0000
Received: from cl-174.chi-02.us.sixxs.net ([2001:4978:f:ad::2]
	helo=tamriel.snowman.net)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sfrost@tamriel.snowman.net>) id 1T3v2Z-0001kg-TU
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 20:27:10 +0000
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 8D1FB22BA9; Tue, 21 Aug 2012 16:27:02 -0400 (EDT)
Date: Tue, 21 Aug 2012 16:27:02 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Karl Denninger <karl@denninger.net>
Cc: Rick Otten <rotten@manta.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: average query performance measuring
Message-ID: <20120821202702.GO1267@tamriel.snowman.net>
References: <362605510214004CB3313A03D3D697DE5508FF27@cmhvm005>
	<20120821185316.GN1267@tamriel.snowman.net>
	<5033E60A.1030808@denninger.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="Jz/0U8nE/X0aUGdz"
Content-Disposition: inline
In-Reply-To: <5033E60A.1030808@denninger.net>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/3.2.0-1-amd64 (x86_64)
X-Uptime: 16:25:20 up 177 days,  2:30,  8 users,  load average: 0.16, 0.08,
	0.09
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201208/143
X-Sequence-Number: 47681


--Jz/0U8nE/X0aUGdz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Karl,

* Karl Denninger (karl@denninger.net) wrote:
> 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.)

Just to clarify one thing- if your application is currently using
prepared queries for everything, you can probably use the existing
contrib module.  The difference is that, with 9.2, it'll actually do
normalization of non-PREPARED queries and will include some additional
statistics and information.

	Thanks,

		Stephen

--Jz/0U8nE/X0aUGdz
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlAz7xYACgkQrzgMPqB3kij1IgCfYFVkKB9lzan3O31I+zxND+bq
wXMAoJDLKsreaja5ZcK+eaq39+im7+BF
=vi5H
-----END PGP SIGNATURE-----

--Jz/0U8nE/X0aUGdz--