X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CD9F311F66E7 for ; Thu, 27 Apr 2006 15:22:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07407-06 for ; Thu, 27 Apr 2006 15:22:44 -0300 (ADT) X-Greylist: delayed 00:28:17.544876 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D9A5F11F6640 for ; Thu, 27 Apr 2006 15:22:43 -0300 (ADT) Received: from interceptor1.c4directsolutions.com (unknown [72.17.156.12]) by svr4.postgresql.org (Postfix) with ESMTP id AC14C5B5E50 for ; Thu, 27 Apr 2006 17:54:25 +0000 (GMT) Received: from [192.168.0.12] ([72.156.236.193]) by interceptor1.c4directsolutions.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 27 Apr 2006 13:54:28 -0400 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Thu, 27 Apr 2006 13:54:21 -0400 Subject: IO query From: Ketema Harris To: Message-ID: Thread-Topic: IO query Thread-Index: AcZqI5yU2thXuNYWEdqi1AARJHlfcA== Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-OriginalArrivalTime: 27 Apr 2006 17:54:28.0578 (UTC) FILETIME=[A1189420:01C66A23] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/357 X-Sequence-Number: 21526 Does anyone have a function or query that will loop through all the dbs in = a cluster, gather all the oids for every table, then call pg_stat_get_db_blocks_fetched(oid) and pg_stat_get_db_blocks_hit(oid), subtracting the latter from the former to get an estimate of kernel read() calls? I would like to write on if there is not one already out there, but I don=B9t know how to find the oid of a table with a query. Where is that stored? Thanks