Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 810A99FB971 for ; Mon, 14 May 2007 16:08:32 -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 83777-08 for ; Mon, 14 May 2007 16:05:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247]) by postgresql.org (Postfix) with ESMTP id CF6989FA5FA for ; Mon, 14 May 2007 16:02:04 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d17so439561and for ; Mon, 14 May 2007 12:02:03 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=T4L7xWhSoqB7D5sitOz/CXH3PPQK2rqiDugCXMs8bCDecoKADHZWM7zRwA4kY58RuF9qKrGwb61M0nl6mO37pLQUVK1QPi3cDFUbG/9E1VQFJbUOolmdaJsMWnir/p4/pGigLMJI0Wk3IWc9Mr24gMzg6Aid56IEBhiBa+FN1qI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=CiDQNxehunKtZmtA4pcuYH5HZEmlAEH5Oc1CV6gEYIXGixKmM88LKsMeB42xrjbyvHwGoknqnu5YowyQf7DroKEnLfdlIDtXebauoWhP5Fqw0wiuX1KFJ7a1HTr7of1HoUxOx1tWaQynr9+GRVUj8R2KzDAXzlY+cNjvPyRfob8= Received: by 10.100.35.17 with SMTP id i17mr4795300ani.1179169323637; Mon, 14 May 2007 12:02:03 -0700 (PDT) Received: by 10.100.6.20 with HTTP; Mon, 14 May 2007 12:02:03 -0700 (PDT) Message-ID: Date: Mon, 14 May 2007 12:02:03 -0700 From: "Y Sidhu" To: "Jim C. Nasby" Subject: Re: pg_stats how-to? Cc: pgsql-performance@postgresql.org In-Reply-To: <20070514183615.GW69517@nasby.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7215_25179918.1179169323484" References: <4647B0A9.7080304@gmail.com> <20070514162610.GO69517@nasby.net> <20070514174558.GS69517@decibel.org> <20070514183615.GW69517@nasby.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/256 X-Sequence-Number: 24646 ------=_Part_7215_25179918.1179169323484 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 ------=_Part_7215_25179918.1179169323484 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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

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 <decibel@decibel.org> 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 ------=_Part_7215_25179918.1179169323484--