| 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: | Whole Thread | Raw Message | 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
| 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 |