Re: zero values in statistic views

Cornelia Boenigk <poppcorn@cornelia-boenigk.de> writes:
> I would like to see what is going on in a database using the statistic
> views.

> I am superuser,
> stats_start_collector = on
> stats_row_level = on
> stats_block_level = on

That all looks OK, but it sounds like the stats collector is not running
anyway.  Have you checked with "ps" to see if the postmaster has a
couple of child processes calling themselves stats buffer and stats
collector?  (You may need to say "ps aux" or "ps -ef" depending on
platform to see these labels rather than generic "postmaster" labels.)

If it's not running, look in the postmaster log right after restarting
the postmaster; there may be a message there about why not.

            regards, tom lane