Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E83609FB48E for ; Sun, 13 May 2007 22:45:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 48182-04 for ; Sun, 13 May 2007 22:45:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.237]) by postgresql.org (Postfix) with ESMTP id E97429FB22A for ; Sun, 13 May 2007 22:45:48 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so1711024nze for ; Sun, 13 May 2007 18:45:47 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=agQOwYqWEa1zbcLNnyLrE3iqfCcgDatEYrSpvPK6d4CaEO0lAMqh2iYazxMRWwsrMNxqogku+7Ok1xT6GHeHgeicyhkAZeC65V39vdUeS7+oYqynqRnuAH/V4BURyuZMhT8Dah3MMjTWzvdCU/E9XDmL59RiPdXPTdp6w7W2Y+Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=XlSydWRdN2tBGUAu9Fyi5Czeu7ZtoGhSEegmvJN/sanb2HDgCz8u2xdgpHOPe4tsOsh7OL8sE5L3zufbzx3FAvhLoEr1Kfq7cn+btHju3MEcepvkU24t+2ruccsNQWyFcRL4QW+/V6gUAfOsbfpgrEP8tSAXldEhe9N/wfj2VXg= Received: by 10.65.116.10 with SMTP id t10mr9283727qbm.1179107147121; Sun, 13 May 2007 18:45:47 -0700 (PDT) Received: from ?192.168.3.170? ( [68.79.189.145]) by mx.google.com with ESMTP id e15sm12175071qbe.2007.05.13.18.45.45; Sun, 13 May 2007 18:45:46 -0700 (PDT) Subject: Re: pg_stats how-to? From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-performance@postgresql.org In-Reply-To: <4647B0A9.7080304@gmail.com> References: <4647B0A9.7080304@gmail.com> Content-Type: text/plain Date: Sun, 13 May 2007 21:44:42 -0400 Message-Id: <1179107082.4558.4.camel@aleph.whitemice.org> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/248 X-Sequence-Number: 24638 > Anyone know of a pg_stats howto? I'd appreciate any direction. Let me know if you find one! :) It isn't a HOWTO, but I have collected some notes regarding the performance views in a document - http://docs.opengroupware.org/Members/whitemice/wmogag/file_view - see the chapter on PostgreSQL. Hopefully this will continue to expand. The information is pretty scattered [ coming from a DB2 / Informix background there there are specific performance guide], try - http://book.itzero.com/read/others/0508/Sams.PostgreSQL.2nd.Edition.Jul.2005_html/0672327562/ch04lev1sec2.html http://www.postgresql.org/docs/8.0/interactive/monitoring-stats.html Also just trolling on this list is useful. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org