Re: [PERFORM] Explain Analyze - actual time in loops - Mailing list pgsql-performance

From Tom Lane
Subject Re: [PERFORM] Explain Analyze - actual time in loops
Date
Msg-id 19229.1504879650@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Explain Analyze - actual time in loops  (Neto pr <netopr9@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Neto pr
Date:
Subject: Re: [PERFORM] Explain Analyze - actual time in loops
Next
From: Soni M
Date:
Subject: Re: [PERFORM] OS cache management