Check pages with the -pk and -pK options

The -pk and -pK options display detailed information about the root and branch pages in an R-tree index. These options also display minimal information about the leaf pages.

The -pk and -pK options of the oncheck utility display the following type of information about root and branch pages:

Level: The level of the page within the R-tree structure
The root page is at level 0.
Pagenum: Unique identifier of the page
Usage: The percent of the total space on the page that is currently in use
Number of children: The number of entries on the page
Right: The page number of the right sibling
If the page does not have a right sibling, then this value is -1.
Bounding box: The global bounding box on the page (root page only)
Children: A list of the page's children

The following example shows how to use the -pK option:

oncheck -pK rtree_db:polygons

The following partial example shows the type of output that oncheck -pK displays:

Node: Level 0, Pagenum 31, Usage  51.2%, No. of Children 10, right -1
X(2.49752E-05,1) Y(-1,1) Z(-1,1) A(any) T(any)
Child 10, Fullness 0x0
X(0.000161568,1) Y(-1,1) Z(-1,1) A(any) T(any)
.
.
.
Node: Level 1, Pagenum 136, Usage  37.7%, No. of Children 7, right -1
Child 104, Fullness 0x0
X(0.0547637,0.73305) Y(-1,-0.670752) Z(-0.583419,0.588895) A(any) T(any)
.
.
.

The example shows output for a root page (level 0) and a branch page (level 1).

The example displays only one child for each page; the output for the remaining children is similar.