X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4C21D1E5C9 for ; Tue, 4 May 2004 15:44:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96075-06 for ; Tue, 4 May 2004 15:44:18 -0300 (ADT) Received: from web13121.mail.yahoo.com (web13121.mail.yahoo.com [216.136.174.83]) by svr1.postgresql.org (Postfix) with SMTP id 7EEC3D1E5C1 for ; Tue, 4 May 2004 15:44:16 -0300 (ADT) Message-ID: <20040504184416.11114.qmail@web13121.mail.yahoo.com> Received: from [63.78.248.48] by web13121.mail.yahoo.com via HTTP; Tue, 04 May 2004 11:44:16 PDT Date: Tue, 4 May 2004 11:44:16 -0700 (PDT) From: Litao Wu Subject: pg_stat To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/27 X-Sequence-Number: 6858 Hi, I have query: select pg_stat_get_numscans(76529669), pg_stat_get_blocks_fetched(76529669), pg_stat_get_blocks_hit(76529669); The result is: pg_stat_get_numscans | pg_stat_get_blocks_fetched | pg_stat_get_blocks_hit ----------------------+----------------------------+------------------------ 0 | 23617 | 23595 (1 row) My questions are: 1. How can index disk blocks be requested (either from disk or cache) without index scan? 2. If I want to check if an index is used after pg_stat_reset(), how can I get it? By number of scans or block requests, or some other ways? Thanks, __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover