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 1T3tZn-0003IY-Ir
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 18:53:19 +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 1T3tZl-0000GP-Af
	for pgsql-performance@postgresql.org; Tue, 21 Aug 2012 18:53:19 +0000
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 865F622BA5; Tue, 21 Aug 2012 14:53:16 -0400 (EDT)
Date: Tue, 21 Aug 2012 14:53:16 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Rick Otten <rotten@manta.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: average query performance measuring
Message-ID: <20120821185316.GN1267@tamriel.snowman.net>
References: <362605510214004CB3313A03D3D697DE5508FF27@cmhvm005>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="oxHyVmqrEuGbbnJG"
Content-Disposition: inline
In-Reply-To: <362605510214004CB3313A03D3D697DE5508FF27@cmhvm005>
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: 14:52:15 up 177 days, 57 min,  8 users,  load average: 0.20, 0.17,
	0.14
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201208/139
X-Sequence-Number: 47677


--oxHyVmqrEuGbbnJG
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

* Rick Otten (rotten@manta.com) wrote:
> It seems like we almost have everything we need to track this in the stats tables, but not quite.  I was hoping the folks on this list would have 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-statistics.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

--oxHyVmqrEuGbbnJG
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

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

iEYEARECAAYFAlAz2RwACgkQrzgMPqB3kihJXACdHK60gnRUUqzylkBiCzNDY2Ei
w+QAn0SpZ5R+mzZ5LG912bL+jWlU+xoW
=ojkd
-----END PGP SIGNATURE-----

--oxHyVmqrEuGbbnJG--