Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A25C163240E for ; Fri, 16 Jan 2009 19:45:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03164-07 for ; Fri, 16 Jan 2009 19:45:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp142.sat.emailsrvr.com (smtp142.sat.emailsrvr.com [66.216.121.142]) by mail.postgresql.org (Postfix) with ESMTP id D9B2D63240D for ; Fri, 16 Jan 2009 19:45:38 -0400 (AST) Received: from relay4.relay.sat.mlsrvr.com (localhost [127.0.0.1]) by relay4.relay.sat.mlsrvr.com (SMTP Server) with ESMTP id A2729115F5A; Fri, 16 Jan 2009 18:45:37 -0500 (EST) Received: by relay4.relay.sat.mlsrvr.com (Authenticated sender: ejones-AT-engineyard.com) with ESMTPSA id 556D4115538; Fri, 16 Jan 2009 18:45:37 -0500 (EST) Cc: pgsql-admin@postgresql.org Message-Id: <749A76C4-D425-4B55-9337-AD1D02E9DF01@engineyard.com> From: Erik Jones To: Kevin Kempter In-Reply-To: <200901140947.36863.kevink@consistentstate.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v929.2) Subject: Re: query to find out # of buffer hits vs. # of disk reads ? Date: Fri, 16 Jan 2009 15:45:31 -0800 References: <200901140947.36863.kevink@consistentstate.com> X-Mailer: Apple Mail (2.929.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200901/57 X-Sequence-Number: 31104 On Jan 14, 2009, at 8:47 AM, Kevin Kempter wrote: > Hi all; > > Anyone know what system catalogs I need to query to find out # of > disk reads > and # of memory / buffercache reads ? See blks_hit and blks_read on the pg_stat_database view. Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k