Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DC26B9FBC21 for ; Mon, 14 May 2007 16:13:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 56047-09 for ; Mon, 14 May 2007 16:11:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 18A9C9FB960 for ; Mon, 14 May 2007 16:07:51 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 25014564DC; Mon, 14 May 2007 14:07:50 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 14 May 2007 14:07:48 -0500 Date: Mon, 14 May 2007 14:07:48 -0500 From: "Jim C. Nasby" To: Y Sidhu Cc: pgsql-performance@postgresql.org Subject: Re: pg_stats how-to? Message-ID: <20070514190748.GY69517@nasby.net> References: <4647B0A9.7080304@gmail.com> <20070514162610.GO69517@nasby.net> <20070514174558.GS69517@decibel.org> <20070514183615.GW69517@nasby.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070514:ysidhu@gmail.com::HJmrmq7bUqNrMjiL:01R6B X-Hashcash: 1:20:070514:pgsql-performance@postgresql.org::A5WCFWmm/PYUDh7Y:00000 0000000000000000000000001epq X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/257 X-Sequence-Number: 24647 On Mon, May 14, 2007 at 12:02:03PM -0700, Y Sidhu wrote: > I am sorry about this Jim, please understand that I am a newbie and am > trying to solve long vacuum time problems and get a handle on speeding up > queries/reports. I was pointed to pg_stats and that's where I am at now. I Well, I have no idea what that person was trying to convey then. What are you trying to look up? Better yet, what's your actual problem? > have added this into my conf file: > stats_start_collector TRUE stats_reset_on_server_start FALSE > stats_command_string TRUE > However, these being production servers, I have not enabled these: > stats_row_level stats_block_level FYI, stats_command_string has a far larger performance overhead than any of the other stats commands prior to 8.2. > Yes, I have re-started the server(s). It seems like I query tables to get > the info. If so, are there any queries written that I can use? > > Thanks for following up on this with me. > > Yudhvir > > === > On 5/14/07, Jim C. Nasby wrote: > > > >On Mon, May 14, 2007 at 11:09:21AM -0700, Y Sidhu wrote: > >> The stats_block_level and stats_row_level are NOT enabled. The question > >is > >> how to use pg_stats. Do I access/see them via the ANALYZE command? or > >using > >> SQL. I cannot find any document which will get me started on this. > > > >Ok, we're both confused I think... I thought you were talking about the > >pg_stat* views, which depend on the statistics collector (that's what > >the stats_* parameters control). > > > >That actually has nothing at all to do with pg_stats or pg_statistics. > >Those deal with statistics about the data in the database, and not about > >statistics from the engine (which is what the pg_stat* views do...). > > > >If you want to know about pg_stats, take a look at > >http://www.postgresql.org/docs/8.2/interactive/view-pg-stats.html ... > >but normally you shouldn't need to worry yourself about that. Are you > >trying to debug something? > > > >Information about the backend statistics can be found at > >http://www.postgresql.org/docs/8.2/interactive/monitoring.html > >-- > >Jim Nasby decibel@decibel.org > >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) > > > > > > -- > Yudhvir Singh Sidhu > 408 375 3134 cell -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)