Pageinspect bt_metap help

From: Neto pr <netopr9(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Pageinspect bt_metap help
Date: 2017-09-17 21:52:37
Message-ID: CA+wPC0MRuc0qn6v57VNtBE0Dh-r1Bcugi4FHHqC_kY-1X2tzGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Geoghegan 2017-09-17 21:59:34 Re: Pageinspect bt_metap help
Previous Message Konstantin Kivi 2017-09-17 08:34:48 Partitioning perfomance issue