pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
statistics not shown up
2+ messages / 2 participants
[nested] [flat]

* statistics not shown up
@ 2005-09-05 00:00 huaxin zhang <uwcssa@gmail.com>
  2005-09-05 00:40 ` Re: statistics not shown up Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: huaxin zhang @ 2005-09-05 00:00 UTC (permalink / raw)
  To: pgsql-admin

I start postgres  using the -s  parameter to track the number of hits to buffer.

I also set both "stats_start_collector", "stats_block_level" to true
in /usr/local/pgsql/data/postgresql.conf

However, I get  "(typeid = 700, len = 4, typmod = -1, byval = f)"  after
running each query. Apparently this is not manifesting buffer hit rate.
Something I did wrong?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: statistics not shown up
  2005-09-05 00:00 statistics not shown up huaxin zhang <uwcssa@gmail.com>
@ 2005-09-05 00:40 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2005-09-05 00:40 UTC (permalink / raw)
  To: huaxin zhang <uwcssa@gmail.com>; +Cc: pgsql-admin

On Sun, Sep 04, 2005 at 08:00:21PM -0400, huaxin zhang wrote:
> I start postgres  using the -s  parameter to track the number of hits to buffer.

I assume you're running postgres in single-user mode since that's
where the -s option means "print statistics."  Is that what you're
doing?

> I also set both "stats_start_collector", "stats_block_level" to true
> in /usr/local/pgsql/data/postgresql.conf
> 
> However, I get  "(typeid = 700, len = 4, typmod = -1, byval = f)"  after
> running each query. Apparently this is not manifesting buffer hit rate.

Try setting log_min_messages to debug1; that works for me in 8.0.3.

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-09-05 00:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-05 00:00 statistics not shown up huaxin zhang <uwcssa@gmail.com>
2005-09-05 00:40 ` Michael Fuhr <mike@fuhr.org>

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