| From: | Cornelia Boenigk <poppcorn(at)cornelia-boenigk(dot)de> |
|---|---|
| To: | Liste pg_general <pgsql-general(at)postgresql(dot)org> |
| Subject: | zero values in statistic views |
| Date: | 2006-11-10 00:33:42 |
| Message-ID: | 4553C8E6.5010807@cornelia-boenigk.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 pg_statio_user_indexes;
are showing zeroes in all columns where UPDATEs, INSERTs, block-reads,
hits ... should be shown.
select * from pg_stat_database where datname = 'mydb';
shows between 20 and 60 numbackends and from 11 to 50 commits.
What could be the reason for this behaviour? What am I missing?
Thanks in advance
Conni
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-11-10 00:39:54 | Re: planer picks a bad plan (seq-scan instead of index) when adding an additional join |
| Previous Message | Thomas H. | 2006-11-10 00:03:48 | Re: planer picks a bad plan (seq-scan instead of index) when adding an additional join |