Re: pg_stats how-to?

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(at)decibel(dot)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(at)decibel(dot)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(at)gmail(dot)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(at)gmail(dot)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(at)postgresql(dot)org so
> that
> > >your
> > >> >> message can get through to the mailing list cleanly
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >> --
> > >> Yudhvir Singh Sidhu
> > >> 408 375 3134 cell
> > >
> > >--
> > >Jim Nasby decibel(at)decibel(dot)org
> > >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
> > >
> >
> >
> >
> > --
> > Yudhvir Singh Sidhu
> > 408 375 3134 cell
>
> --
> Jim C. Nasby, Database Architect decibel(at)decibel(dot)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