Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 197F99F93A3 for ; Sun, 23 Sep 2007 14:00:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 17663-02 for ; Sun, 23 Sep 2007 14:00:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cse.ust.hk (cssvr7.cse.ust.hk [143.89.41.157]) by postgresql.org (Postfix) with ESMTP id 1C5A39F93E2 for ; Sun, 23 Sep 2007 14:00:25 -0300 (ADT) Received: from LENOVO098A0F97 (laptopgw.cse.ust.hk [143.89.41.237]) (authenticated bits=0) by cse.ust.hk (8.13.8/8.12.5) with ESMTP id l8NH0OrA008030 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Mon, 24 Sep 2007 01:00:24 +0800 From: "Yinan Li" To: Subject: zero value in statistics collector's result Date: Mon, 24 Sep 2007 01:00:24 +0800 Message-ID: <003801c7fe03$3c3f8020$b4be8060$@ust.hk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0039_01C7FE46.4A62C020" X-Mailer: Microsoft Office Outlook 12.0 thread-index: Acf+AgtvkMfWAZozTmi+UGbe2wbLXwAARnCw Content-Language: zh-cn X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200709/400 X-Sequence-Number: 26945 UbJGR;7b MIME 8qJ=5D6`2?7VSJ<~!# ------=_NextPart_000_0039_01C7FE46.4A62C020 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, When I use the statistics collector to see the number of IO, I always get zero in almost all of columns. I really want to know the reason for that. The result of statistics view: # select * from pg_statio_user_tables; relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit -------+------------+---------+----------------+---------------+------------ ---+--------------+-----------------+----------------+----------------+----- ---------- 16386 | public | tab | 0 | 0 | 0 | 0 | | | | (1 row) # select * from pg_statio_user_indexes; relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit -------+------------+------------+---------+--------------+---------------+- ------------- 16386 | 24581 | public | tab | idx_tab_a2 | 0 | 0 (1 row) I've set: stats_start_collector = on stats_row_level = on stats_block_level = on and I think that the statistics collector should be running, because: $ ps aux|grep stats postgres 3688 0.0 0.0 7272 648 ? Ss 00:48 0:00 postgres: stats collector process postgres 29790 0.0 0.0 4004 712 pts/2 S+ 04:44 0:00 grep stats Any help would be really appreciated. Regards, Yinan ------=_NextPart_000_0039_01C7FE46.4A62C020 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,=

 

When I use = the statistics collector to see the number of IO, I always get zero in = almost all of columns. I really want to know the reason for = that.

 

The result of statistics view:

# select * from pg_statio_user_tables;

 relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read = | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit

-------+------= ------+---------+----------------+---------------+---------------+-------= -------+-----------------+----------------+----------------+-------------= --

 16386 | public     | tab     |            =   0 = |            = 0 |            = 0 |            0 |            =      |            =     |            =     |            =  

(1 row)

# select * from pg_statio_user_indexes;

 relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit

-------+------= ------+------------+---------+--------------+---------------+------------= --

 16386 |      24581 | public     | tab     | idx_tab_a2   |            = 0 |            = 0

(1 row)

 

I’ve = set:

stats_start_co= llector =3D on

stats_row_leve= l =3D on

stats_block_le= vel =3D on

 

and I think that the statistics collector should be running, because: =

$ ps aux|grep stats

postgres = 3688  0.0  0.0   7272   648 ?        Ss   = 00:48   0:00 postgres: stats collector = process           =          

postgres 29790  0.0  0.0   4004   712 pts/2    S+   04:44   0:00 grep = stats

 

Any help = would be really appreciated.

 

Regards,<= /o:p>

Yinan

 

------=_NextPart_000_0039_01C7FE46.4A62C020--