From: Tom Lane <tgl@sss.pgh.pa.us>
To: Neto pr <netopr9@gmail.com>
cc: Igor Neyman <ineyman@perceptron.com>,
        "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Explain Analyze - actual time in loops
In-reply-to: 
 <CA+wPC0Otv5=9yHu30t_ovCiMe=GL3EU7NgTY5mEH6M_4kymdFA@mail.gmail.com>
References: 
 <CA+wPC0OXdN+_8HxhYMWyV9nfD8v+xChvLROiWCiRo=qSve2MjQ@mail.gmail.com>
 <DM5PR17MB14993F6FD18158C593907D85DA950@DM5PR17MB1499.namprd17.prod.outlook.com>
 <CA+wPC0ObeUigZk3Vf_EVtozKUoCcd91FDFUd4VR4L_3LkY6bbA@mail.gmail.com>
 <15789.1504878289@sss.pgh.pa.us>
 <CA+wPC0Otv5=9yHu30t_ovCiMe=GL3EU7NgTY5mEH6M_4kymdFA@mail.gmail.com>
Comments: In-reply-to Neto pr <netopr9@gmail.com>
	message dated "Fri, 08 Sep 2017 07:02:37 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <19228.1504879650.1@sss.pgh.pa.us>
Date: Fri, 08 Sep 2017 10:07:30 -0400
Message-ID: <19229.1504879650@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Neto pr <netopr9@gmail.com> writes:
> I need to know the height of a B-tree index (level of the leaf node
> farthest from the root).

pageinspect's bt_metap() will give you that --- it's the "level"
field, I believe.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance