Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 35BA79FB253 for ; Mon, 14 May 2007 15:09:29 -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 47248-03 for ; Mon, 14 May 2007 15:09:16 -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.246]) by postgresql.org (Postfix) with ESMTP id 07F0D9FB1D4 for ; Mon, 14 May 2007 15:09:22 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d17so434761and for ; Mon, 14 May 2007 11:09:22 -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:in-reply-to:mime-version:content-type:references; b=g3huWav3pBztrSRECOVTK9OU2KitXD3OjHxT08v7M4aIoPUW3+O/+2N03KDXCG8SKgw1RXY1aYYdO9Wa6Bff2fiUigwRMg8ebhnMNCmUFws7OTw988UxYQg/ZOtK5TOK9VooRPwrtenPgOE4MuVi4DRCbYjzlYTlCKseJTxRujE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=NqH/ivMEpUWHHeO7caZwN4v6LCpGnbsKJGGJbmpensnQ+LOYdVK6cdQujWM7xvqaLLJr4JMG9T//s6+fDXTn5HOdBH2Y+aH8B5vCEKP014fLfPfpMaz76j17HgAU8pIMOtSsuBpJoaC/Wd+iRN6zU4n86kfHiTODfvfM82XyRqQ= Received: by 10.100.178.7 with SMTP id a7mr4772660anf.1179166162062; Mon, 14 May 2007 11:09:22 -0700 (PDT) Received: by 10.100.6.20 with HTTP; Mon, 14 May 2007 11:09:21 -0700 (PDT) Message-ID: Date: Mon, 14 May 2007 11:09:21 -0700 From: "Y Sidhu" To: "Jim C. Nasby" , pgsql-performance@postgresql.org Subject: Re: pg_stats how-to? In-Reply-To: <20070514174558.GS69517@decibel.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5715_2992026.1179166161957" References: <4647B0A9.7080304@gmail.com> <20070514162610.GO69517@nasby.net> <20070514174558.GS69517@decibel.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/254 X-Sequence-Number: 24644 ------=_Part_5715_2992026.1179166161957 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. Yudhvir -------------- On 5/14/07, Jim C. Nasby wrote: > > Please include the list in your replies... > > Ok, so you've got stats collection turned on. What's the question then? > And are stats_block_level and stats_row_level also enabled? > > On Mon, May 14, 2007 at 09:28:46AM -0700, Y Sidhu wrote: > > yes > > > > Yudhvir > > === > > > > On 5/14/07, Jim C. Nasby wrote: > > > > > >Have you either re-loaded the config or restarted the server since > > >making those changes? > > > > > >On Mon, May 14, 2007 at 09:16:54AM -0700, Y Sidhu wrote: > > >> I am trying to use them. I have set these values in my conf file: > > >> stats_start_collector TRUE stats_reset_on_server_start FALSE > > >> stats_command_string TRUE > > >> now what? > > >> > > >> Yudhvir > > >> ========== > > >> > > >> On 5/13/07, Shoaib Mir wrote: > > >> > > > >> >Can you be a little more specific? What exactly are you trying to > > >achieve > > >> >with pg_stats? > > >> > > > >> >You can always get help for documentation at --> > > >> >http://www.postgresql.org/docs/8.2/static/view-pg-stats.html > > >> > > > >> > > > >> >-- > > >> >Shoaib Mir > > >> >EnterpriseDB (www.enterprisedb.com) > > >> > > > >> >On 5/13/07, Yudhvir Singh Sidhu < ysidhu@gmail.com> wrote: > > >> >> > > >> >> Anyone know of a pg_stats howto? I'd appreciate any direction. > > >> >> > > >> >> Yudhvir > > >> >> > > >> >> ---------------------------(end of > > >broadcast)--------------------------- > > >> >> TIP 1: if posting/reading through Usenet, please send an > appropriate > > >> >> subscribe-nomail command to majordomo@postgresql.org so > that > > >your > > >> >> message can get through to the mailing list cleanly > > >> >> > > >> > > > >> > > > >> > > >> > > >> -- > > >> Yudhvir Singh Sidhu > > >> 408 375 3134 cell > > > > > >-- > > >Jim Nasby decibel@decibel.org > > >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) > > > > > > > > > > > -- > > Yudhvir Singh Sidhu > > 408 375 3134 cell > > -- > Jim C. Nasby, Database Architect decibel@decibel.org > Give your computer some brain candy! www.distributed.net Team #1828 > > Windows: "Where do you want to go today?" > Linux: "Where do you want to go tomorrow?" > FreeBSD: "Are you guys coming, or what?" > -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_5715_2992026.1179166161957 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.

Yudhvir
--------------

On 5/14/07, Jim C. Nasby <decibel@decibel.org> wrote:
Please include the list in your replies...

Ok, so you've got stats collection turned on. What's the question then?
And are stats_block_level and stats_row_level also enabled?

On Mon, May 14, 2007 at 09:28:46AM -0700, Y Sidhu wrote:
> yes
>
> Yudhvir
> ===
>
> On 5/14/07, Jim C. Nasby <decibel@decibel.org> wrote:
> >
> >Have you either re-loaded the config or restarted the server since
> >making those changes?
> >
> >On Mon, May 14, 2007 at 09:16:54AM -0700, Y Sidhu wrote:
> >> I am trying to use them. I have set these values in my conf file:
> >>  stats_start_collector TRUE  stats_reset_on_server_start FALSE
> >> stats_command_string TRUE
> >> now what?
> >>
> >> Yudhvir
> >> ==========
> >>
> >> On 5/13/07, Shoaib Mir < shoaibmir@gmail.com> wrote:
> >> >
> >> >Can you be a little more specific? What exactly are you trying to
> >achieve
> >> >with pg_stats?
> >> >
> >> >You can always get help for documentation at -->
> >> >http://www.postgresql.org/docs/8.2/static/view-pg-stats.html
> >> >
> >> >
> >> >--
> >> >Shoaib Mir
> >> >EnterpriseDB (www.enterprisedb.com)
> >> >
> >> >On 5/13/07, Yudhvir Singh Sidhu < ysidhu@gmail.com> wrote:
> >> >>
> >> >> Anyone know of a pg_stats howto? I'd appreciate any direction.
> >> >>
> >> >> Yudhvir
> >> >>
> >> >> ---------------------------(end of
> >broadcast)---------------------------
> >> >> TIP 1: if posting/reading through Usenet, please send an appropriate
> >> >>        subscribe-nomail command to majordomo@postgresql.org so that
> >your
> >> >>        message can get through to the mailing list cleanly
> >> >>
> >> >
> >> >
> >>
> >>
> >> --
> >> Yudhvir Singh Sidhu
> >> 408 375 3134 cell
> >
> >--
> >Jim Nasby                                      decibel@decibel.org
> >EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
> >
>
>
>
> --
> Yudhvir Singh Sidhu
> 408 375 3134 cell

--
Jim C. Nasby, Database Architect                decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_5715_2992026.1179166161957--