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 0B8339F9DCD for ; Mon, 1 May 2006 10:05:05 -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 48553-05 for ; Mon, 1 May 2006 10:04:57 -0300 (ADT) X-Greylist: delayed 00:14:09.39488 by SQLgrey- Received: from mx1.sonologic.nl (mx1.sonologic.nl [82.94.245.21]) by postgresql.org (Postfix) with ESMTP id 72F489FA4B3 for ; Mon, 1 May 2006 10:04:55 -0300 (ADT) Received: from [192.168.0.254] (gongmaster.xs4all.nl [213.84.33.240]) (authenticated bits=0) by mx1.sonologic.nl (8.13.6/8.13.6) with ESMTP id k41D4oKs047246; Mon, 1 May 2006 13:04:51 GMT Message-ID: <44560780.7010308@metro.cx> Date: Mon, 01 May 2006 15:05:04 +0200 From: Koen Martens Organization: Sonologic User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050317 Thunderbird/1.0.2 Mnenhy/0.7.2.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ketema Harris CC: pgsql-admin@postgresql.org Subject: Re: IO query References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Helo-Milter-Authen: gmc@sonologic.nl, pgsql@metro.cx, mx1 Received-SPF: pass (mx1.sonologic.nl: 213.84.33.240 is authenticated by a trusted mechanism) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1 X-Sequence-Number: 21533 select oid from pg_class where relname='foo'; Ketema Harris wrote: > 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št know how to find the oid of a table with a query. Where is that > stored? > > Thanks > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > -- K.F.J. Martens, Sonologic, http://www.sonologic.nl/ Networking, hosting, embedded systems, unix, artificial intelligence. Public PGP key: http://www.metro.cx/pubkey-gmc.asc Wondering about the funny attachment your mail program can't read? Visit http://www.openpgp.org/