X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D73E2D8BD5 for ; Sun, 4 Sep 2005 21:00:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13602-08 for ; Mon, 5 Sep 2005 00:00:23 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.198]) by svr1.postgresql.org (Postfix) with ESMTP id 1E780D8B38 for ; Sun, 4 Sep 2005 21:00:19 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i27so38613wxd for ; Sun, 04 Sep 2005 17:00:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ssb4qR3piepMVACBMeYbImvyNH4ZwQzQsRPethklh497E6jwnUOBPCGmqVtnFP+utugJW8jHDIUOaRnnVLD4+p7TWq3HUAubhJ3+hROKaN1+MZ7S0sCMd4Lu7xk2xzYCPM6dMgQGkjhRU3fgXX8W4nQwzujltphZTLyxfCt11z0= Received: by 10.70.10.11 with SMTP id 11mr69288wxj; Sun, 04 Sep 2005 17:00:21 -0700 (PDT) Received: by 10.70.23.2 with HTTP; Sun, 4 Sep 2005 17:00:21 -0700 (PDT) Message-ID: Date: Sun, 4 Sep 2005 20:00:21 -0400 From: huaxin zhang To: pgsql-admin@postgresql.org Subject: statistics not shown up Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.277 required=5 tests=[AWL=0.253, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/24 X-Sequence-Number: 18761 I start postgres using the -s parameter to track the number of hits to bu= ffer. I also set both "stats_start_collector", "stats_block_level" to true in /usr/local/pgsql/data/postgresql.conf However, I get "(typeid =3D 700, len =3D 4, typmod =3D -1, byval =3D f)" = after running each query. Apparently this is not manifesting buffer hit rate. Something I did wrong?