From: Y Sidhu <ysidhu@gmail.com>
To: Jim C. Nasby <decibel@decibel.org>
To: pgsql-performance@postgresql.org
Subject: Re: pg_stats how-to?
Date: Mon, 14 May 2007 11:09:21 -0700
Message-ID: <b09064f30705141109m7c2f57an802f8fe0485a65bb@mail.gmail.com> (raw)
In-Reply-To: <20070514174558.GS69517@decibel.org>
References: <4647B0A9.7080304@gmail.com>
<bf54be870705131751g32e29447l4ec3a2bfabca10e6@mail.gmail.com>
<b09064f30705140916o7c1d1a24h2bdabd3714df2187@mail.gmail.com>
<20070514162610.GO69517@nasby.net>
<b09064f30705140928x6b44f03dtdb93ebd18e7cdaca@mail.gmail.com>
<20070514174558.GS69517@decibel.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ysidhu@gmail.com, decibel@decibel.org
Subject: Re: pg_stats how-to?
In-Reply-To: <b09064f30705141109m7c2f57an802f8fe0485a65bb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox