X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 578AF5292D for ; Tue, 7 Jun 2005 16:57:26 -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 52349-06 for ; Tue, 7 Jun 2005 19:57:21 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 4D0A6528D0 for ; Tue, 7 Jun 2005 16:57:20 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE00C752B5; Tue, 7 Jun 2005 15:56:47 -0400 Received: from smtp2.surnet.cl (smtp2.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Tue, 07 Jun 2005 19:56:47 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE3007954E8; Tue, 7 Jun 2005 15:57:31 -0400 Received: from localhost (200.85.216.119) by cluster.surnet.cl (7.0.024) id 4276578F004F9614; Tue, 7 Jun 2005 15:57:17 -0400 Received: by localhost (Postfix, from userid 1000) id 1EB98C2DC7B; Tue, 7 Jun 2005 15:57:44 -0400 (CLT) Date: Tue, 7 Jun 2005 15:57:43 -0400 From: Alvaro Herrera To: Eduardo Bezerra Cc: pgsql-admin@postgresql.org Subject: Re: btree information Message-ID: <20050607195743.GC19846@surnet.cl> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.608 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200506/36 X-Sequence-Number: 17791 On Tue, Jun 07, 2005 at 01:36:56PM -0400, Eduardo Bezerra wrote: > hi all, > Someone can help me to find these data about btree index: > * height; > * maximum number of keys per block > * average number of keys per block > * number of leaf blocks > * average number of leaf blocks per total number of keys > * average number of data blocks per total number of keys I guess what I'd do is run pg_filedump in an btree index file to find out. Leaf pages are marked with the BTP_LEAF flag. Regarding the number of keys in a block, it's variable, depends on the size of the keys. You can find out for a particular index using pg_filedump too. -- Alvaro Herrera () Jude: I wish humans laid eggs Ringlord: Why would you want humans to lay eggs? Jude: So I can eat them