pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Y Sidhu <ysidhu@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_stats how-to?
Date: Mon, 14 May 2007 13:36:16 -0500
Message-ID: <20070514183615.GW69517@nasby.net> (raw)
In-Reply-To: <b09064f30705141109m7c2f57an802f8fe0485a65bb@mail.gmail.com>
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>
	<b09064f30705141109m7c2f57an802f8fe0485a65bb@mail.gmail.com>

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)



view thread (18+ messages)  latest in thread

Message-ID: <20070514183615.GW69517@nasby.net>
Permalink:  ../20070514183615.GW69517@nasby.net/
Also on:    postgresql.org/message-id/20070514183615.GW69517@nasby.net

 · 

reply
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: <20070514183615.GW69517@nasby.net>

* 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