zero values in statistic views

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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