How many levels a B-tree has? - Mailing list pgsql-general

From Cris
Subject How many levels a B-tree has?
Date
Msg-id 200305141609.h4EG9sG27003@cancerberus.com
Whole thread Raw
Responses Re: How many levels a B-tree has?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,[I'm not sure if this will be the best word to express the thing I
mean, because I've been reading some papers, and mail archives that have
been looked for by this word, and I haven't got any result, so I would do my
best.]I need to know (if it possible) how many LEVELS a B-tree index
has (to know how many accesses to the disk it would do in a query). I could
know the index size, but no-idea to find out how many levels it has.
I've read about pg_index, but there isn't any about.There is any way to
do it?ThanksCris..

pgsql-general by date:

Previous
From: Todd Nemanich
Date:
Subject: Questions regarding stored procedures
Next
From: "alex b."
Date:
Subject: Re: COPY versus INSERT