pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 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:40 Michael Fuhr <mike@fuhr.org> parent: huaxin zhang <uwcssa@gmail.com> 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