Hi Tom
> But you didn't say what the ps output showed.
ps aux | grep stats
postgres 24979 0.0 0.0 24416 3780 ?SNov07 0:07
postgres: stats buffer process
postgres 24980 0.0 0.0 24684 4024 ?SNov07 0:10
postgres: stats collector process
Regards
Conni
---
Cornelia Boenigk <[EMAIL PROTECTED]> writes:
> stats_row_level and stats_block_level are disabled in postgresql.conf.
> I used the SET command to activate them.
That's not going to accomplish a lot --- it'll only cause the session
you did the SET in to report to the stats collector. You need to
Tom,
thanks for the quick response.
stats_row_level and stats_block_level are disabled in postgresql.conf.
I used the SET command to activate them.
> If it's not running, look in the postmaster log right after
> restarting the postmaster; there may be a message there about why
> not.
I canno
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
a
Hi all
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
select * from pg_stat_user_tables;
select * from pg_stat_user_indexes;
select * from pg_statio_user_tables
select * from
