Cornelia Boenigk <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
