From: Jim C. Nasby <decibel@decibel.org>
To: Y Sidhu <ysidhu@gmail.com>
Subject: Re: pg_stats how-to?
Date: Mon, 14 May 2007 12:45:58 -0500
Message-ID: <20070514174558.GS69517@decibel.org> (raw)
In-Reply-To: <b09064f30705140928x6b44f03dtdb93ebd18e7cdaca@mail.gmail.com>
References: <4647B0A9.7080304@gmail.com>
<bf54be870705131751g32e29447l4ec3a2bfabca10e6@mail.gmail.com>
<b09064f30705140916o7c1d1a24h2bdabd3714df2187@mail.gmail.com>
<20070514162610.GO69517@nasby.net>
<b09064f30705140928x6b44f03dtdb93ebd18e7cdaca@mail.gmail.com>
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?"
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: decibel@decibel.org, ysidhu@gmail.com
Subject: Re: pg_stats how-to?
In-Reply-To: <20070514174558.GS69517@decibel.org>
* 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