1 SET client_min_messages = warning;
3 RESET client_min_messages;
4 CREATE TABLE test__val( a int[] );
5 \copy test__val from 'data/test__int.data'
6 INSERT INTO test__val ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t );
7 INSERT INTO test__val ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) );
8 VACUUM ANALYZE test__val;
10 CREATE INDEX btree_idx ON test__val USING btree ( a );
11 SELECT btree_stat('btree_idx');
13 -----------------------------------------
16 Number of leaf pages: 74 +
17 Number of tuples: 11047 +
18 Number of invalid tuples: 0 +
19 Number of leaf tuples: 10973 +
20 Total size of tuples: 138624 bytes+
21 Total size of leaf tuples: 140204 bytes+
22 Total size of index: 614400 bytes+
26 SELECT btree_tree('btree_idx');
28 ---------------------------------
29 lvl: 0, blk: 3, numTuples: 74 +
30 lvl: 1, blk: 1, numTuples: 139 +
31 lvl: 1, blk: 2, numTuples: 139 +
32 lvl: 1, blk: 4, numTuples: 139 +
33 lvl: 1, blk: 5, numTuples: 136 +
34 lvl: 1, blk: 6, numTuples: 141 +
35 lvl: 1, blk: 7, numTuples: 139 +
36 lvl: 1, blk: 8, numTuples: 140 +
37 lvl: 1, blk: 9, numTuples: 136 +
38 lvl: 1, blk: 10, numTuples: 140+
39 lvl: 1, blk: 11, numTuples: 138+
40 lvl: 1, blk: 12, numTuples: 143+
41 lvl: 1, blk: 13, numTuples: 137+
42 lvl: 1, blk: 14, numTuples: 138+
43 lvl: 1, blk: 15, numTuples: 140+
44 lvl: 1, blk: 16, numTuples: 141+
45 lvl: 1, blk: 17, numTuples: 138+
46 lvl: 1, blk: 18, numTuples: 141+
47 lvl: 1, blk: 19, numTuples: 141+
48 lvl: 1, blk: 20, numTuples: 138+
49 lvl: 1, blk: 21, numTuples: 141+
50 lvl: 1, blk: 22, numTuples: 141+
51 lvl: 1, blk: 23, numTuples: 141+
52 lvl: 1, blk: 24, numTuples: 138+
53 lvl: 1, blk: 25, numTuples: 140+
54 lvl: 1, blk: 26, numTuples: 142+
55 lvl: 1, blk: 27, numTuples: 141+
56 lvl: 1, blk: 28, numTuples: 142+
57 lvl: 1, blk: 29, numTuples: 140+
58 lvl: 1, blk: 30, numTuples: 141+
59 lvl: 1, blk: 31, numTuples: 140+
60 lvl: 1, blk: 32, numTuples: 142+
61 lvl: 1, blk: 33, numTuples: 143+
62 lvl: 1, blk: 34, numTuples: 141+
63 lvl: 1, blk: 35, numTuples: 140+
64 lvl: 1, blk: 36, numTuples: 142+
65 lvl: 1, blk: 37, numTuples: 142+
66 lvl: 1, blk: 38, numTuples: 141+
67 lvl: 1, blk: 39, numTuples: 143+
68 lvl: 1, blk: 40, numTuples: 142+
69 lvl: 1, blk: 41, numTuples: 143+
70 lvl: 1, blk: 42, numTuples: 143+
71 lvl: 1, blk: 43, numTuples: 142+
72 lvl: 1, blk: 44, numTuples: 143+
73 lvl: 1, blk: 45, numTuples: 142+
74 lvl: 1, blk: 46, numTuples: 142+
75 lvl: 1, blk: 47, numTuples: 141+
76 lvl: 1, blk: 48, numTuples: 144+
77 lvl: 1, blk: 49, numTuples: 141+
78 lvl: 1, blk: 50, numTuples: 142+
79 lvl: 1, blk: 51, numTuples: 143+
80 lvl: 1, blk: 52, numTuples: 142+
81 lvl: 1, blk: 53, numTuples: 143+
82 lvl: 1, blk: 54, numTuples: 141+
83 lvl: 1, blk: 55, numTuples: 142+
84 lvl: 1, blk: 56, numTuples: 141+
85 lvl: 1, blk: 57, numTuples: 156+
86 lvl: 1, blk: 58, numTuples: 159+
87 lvl: 1, blk: 59, numTuples: 160+
88 lvl: 1, blk: 60, numTuples: 161+
89 lvl: 1, blk: 61, numTuples: 163+
90 lvl: 1, blk: 62, numTuples: 163+
91 lvl: 1, blk: 63, numTuples: 164+
92 lvl: 1, blk: 64, numTuples: 165+
93 lvl: 1, blk: 65, numTuples: 165+
94 lvl: 1, blk: 66, numTuples: 166+
95 lvl: 1, blk: 67, numTuples: 166+
96 lvl: 1, blk: 68, numTuples: 167+
97 lvl: 1, blk: 69, numTuples: 167+
98 lvl: 1, blk: 70, numTuples: 167+
99 lvl: 1, blk: 71, numTuples: 167+
100 lvl: 1, blk: 72, numTuples: 167+
101 lvl: 1, blk: 73, numTuples: 167+
102 lvl: 1, blk: 74, numTuples: 167+
103 lvl: 1, blk: 75, numTuples: 274+
107 SELECT * FROM btree_print('btree_idx') as t(level int, valid bool, a int[]) where level=1;
109 -------+-------+-------------------------
112 1 | t | {3,52,31,62,98}
118 1 | t | {12,96,72,23,83,56}
119 1 | t | {14,30,132,144,174}
121 1 | t | {17,36,97,77}
124 1 | t | {22,31,38,77,21}
126 1 | t | {25,218,241,241}
127 1 | t | {27,87,61,54,41}
128 1 | t | {29,53,109,128,129,195}
131 1 | t | {34,44,47,81,124,135}
134 1 | t | {39,74,47,71,63,80}
136 1 | t | {43,41,12,44,75,91}
137 1 | t | {45,26,61,15}
139 1 | t | {49,16,63,56}
140 1 | t | {50,98,71,10}
142 1 | t | {54,46,31,87,13,8}
144 1 | t | {57,99,66,93}
145 1 | t | {59,103,180,196}
146 1 | t | {61,63,59,62}
148 1 | t | {65,30,39,82,89,34}
152 1 | t | {73,24,81,58,22}
153 1 | t | {75,54,93,39,18}
156 1 | t | {81,61,86,96,47,67}
157 1 | t | {83,79,46,37,99}
163 1 | t | {96,33,86,28,19}
164 1 | t | {98,53,58,58,61}
165 1 | t | {100,80,23,24,17}