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