MIME-Version: 1.0
From: Neto pr <netopr9@gmail.com>
Date: Sun, 17 Sep 2017 18:52:37 -0300
Message-ID: 
 <CA+wPC0MRuc0qn6v57VNtBE0Dh-r1Bcugi4FHHqC_kY-1X2tzGQ@mail.gmail.com>
Subject: Pageinspect bt_metap help
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="089e08267de8f4d3eb055969a461"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--089e08267de8f4d3eb055969a461
Content-Type: text/plain; charset="UTF-8"

Hello All

I am using Postgresql extension pageinspect.

Could someone tell me the meaning of these columns: magic, version, root,
level, fastroot, fastlevel of the bt_metap function.

This information is not presents in the documentation.

The height of the b-tree (position of node farthest from root to leaf), is
the column Level?

See below a return query that I ran on an index called
idx_l_shipmodelineitem000

------------------------------------------------------------------
postgres # SELECT * FROM bt_metap ('idx_l_shipmodelineitem000');
postgres # magic  | version  | root     | level | fastroot | fastlevel
postgres # 340322  | 2  | 41827 | 3       | 41827   | 3

Best regards
Neto

--089e08267de8f4d3eb055969a461
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hello All<br></div><div><br></div><div>I am usin=
g Postgresql extension pageinspect.</div><div><br></div>Could someone tell =
me the meaning of these columns: magic, version, root, level, fastroot, fas=
tlevel of the bt_metap function.</div><div><br>This information is not pres=
ents in the documentation.</div><div><br><div>The height of the b-tree (pos=
ition of node farthest from root to leaf), is the column Level?</div><div><=
br></div><div>See below a return query that I ran on an index called idx_l_=
shipmodelineitem000</div><div><br></div><div>------------------------------=
------------------------------------</div><div>postgres # SELECT * FROM bt_=
metap (&#39;idx_l_shipmodelineitem000&#39;);</div><div>postgres # magic=C2=
=A0<span style=3D"white-space:pre">	</span>| version=C2=A0<span style=3D"wh=
ite-space:pre">	</span>| root=C2=A0 =C2=A0 =C2=A0| level | fastroot | fastl=
evel</div><div>postgres # 340322=C2=A0<span style=3D"white-space:pre">	</sp=
an>| 2=C2=A0<span style=3D"white-space:pre">		</span>| 41827 | 3=C2=A0 =C2=
=A0 =C2=A0 =C2=A0| 41827=C2=A0 =C2=A0| 3</div><div><br></div><div>Best rega=
rds</div><div>Neto=C2=A0</div></div><div><br></div><div><br></div></div>

--089e08267de8f4d3eb055969a461--