Cornelia Boenigk <poppcorn@xxxxxxxxxxxxxxxxxxx> 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
