1 SET client_min_messages = warning;
3 RESET client_min_messages;
4 CREATE TABLE gevelt ( t box );
5 \copy gevelt from 'data/rect.data'
6 SELECT center(t) AS p INTO gevelp FROM gevelt;
7 CREATE INDEX gist_idx ON gevelt USING gist ( t );
8 CREATE INDEX spgist_idx ON gevelp USING spgist ( p );
10 SELECT gist_stat('gist_idx');
12 -----------------------------------------
15 Number of leaf pages: 28 +
16 Number of tuples: 3406 +
17 Number of invalid tuples: 0 +
18 Number of leaf tuples: 3378 +
19 Total size of tuples: 143516 bytes+
20 Total size of leaf tuples: 142296 bytes+
21 Total size of index: 237568 bytes+
25 SELECT gist_tree('gist_idx');
27 -----------------------------------------------------------------------------------------------
28 0(l:0) blk: 0 numTuple: 28 free: 6940b(14.95%) rightlink:4294967295 (InvalidBlockNumber) +
29 1(l:1) blk: 2 numTuple: 278 free: 2588b(68.28%) rightlink:4294967295 (InvalidBlockNumber)+
30 2(l:1) blk: 19 numTuple: 123 free: 2736b(66.47%) rightlink:3 (OK) +
31 3(l:1) blk: 8 numTuple: 128 free: 2516b(69.17%) rightlink:22 (OK) +
32 4(l:1) blk: 4 numTuple: 92 free: 4100b(49.75%) rightlink:23 (OK) +
33 5(l:1) blk: 20 numTuple: 122 free: 2780b(65.93%) rightlink:7 (OK) +
34 6(l:1) blk: 15 numTuple: 127 free: 2560b(68.63%) rightlink:11 (OK) +
35 7(l:1) blk: 12 numTuple: 118 free: 2956b(63.77%) rightlink:17 (OK) +
36 8(l:1) blk: 18 numTuple: 138 free: 2076b(74.56%) rightlink:9 (OK) +
37 9(l:1) blk: 23 numTuple: 126 free: 2604b(68.09%) rightlink:8 (OK) +
38 10(l:1) blk: 10 numTuple: 156 free: 1284b(84.26%) rightlink:19 (OK) +
39 11(l:1) blk: 13 numTuple: 130 free: 2428b(70.25%) rightlink:20 (OK) +
40 12(l:1) blk: 22 numTuple: 112 free: 3220b(60.54%) rightlink:10 (OK) +
41 13(l:1) blk: 16 numTuple: 89 free: 4232b(48.14%) rightlink:25 (OK) +
42 14(l:1) blk: 25 numTuple: 108 free: 3396b(58.38%) rightlink:5 (OK) +
43 15(l:1) blk: 7 numTuple: 99 free: 3792b(53.53%) rightlink:16 (OK) +
44 16(l:1) blk: 6 numTuple: 122 free: 2780b(65.93%) rightlink:18 (OK) +
45 17(l:1) blk: 14 numTuple: 163 free: 976b(88.04%) rightlink:6 (OK) +
46 18(l:1) blk: 27 numTuple: 122 free: 2780b(65.93%) rightlink:12 (OK) +
47 19(l:1) blk: 3 numTuple: 57 free: 5640b(30.88%) rightlink:26 (OK) +
48 20(l:1) blk: 24 numTuple: 58 free: 5596b(31.42%) rightlink:15 (OK) +
49 21(l:1) blk: 9 numTuple: 128 free: 2516b(69.17%) rightlink:24 (OK) +
50 22(l:1) blk: 21 numTuple: 166 free: 844b(89.66%) rightlink:13 (OK) +
51 23(l:1) blk: 26 numTuple: 124 free: 2692b(67.01%) rightlink:14 (OK) +
52 24(l:1) blk: 11 numTuple: 146 free: 1724b(78.87%) rightlink:2 (OK) +
53 25(l:1) blk: 17 numTuple: 64 free: 5332b(34.66%) rightlink:28 (OK) +
54 26(l:1) blk: 5 numTuple: 61 free: 5464b(33.04%) rightlink:27 (OK) +
55 27(l:1) blk: 1 numTuple: 92 free: 4100b(49.75%) rightlink:21 (OK) +
56 28(l:1) blk: 28 numTuple: 129 free: 2472b(69.71%) rightlink:4 (OK) +
60 SELECT * FROM gist_print('gist_idx') as t(level int, valid bool, a box) where level=1;
62 -------+-------+-----------------------------
64 1 | t | (32261,50040),(20397,42779)
65 1 | t | (20400,41715),(9175,31485)
66 1 | t | (8924,39250),(3,31083)
67 1 | t | (20594,19151),(10869,10535)
68 1 | t | (49981,42533),(43290,28026)
69 1 | t | (32512,19729),(20838,11843)
70 1 | t | (49999,27727),(40603,15778)
71 1 | t | (8993,50012),(64,39781)
72 1 | t | (32394,42395),(20513,31557)
73 1 | t | (20715,10161),(10407,51)
74 1 | t | (20327,49975),(9216,42130)
75 1 | t | (13397,31188),(7334,19288)
76 1 | t | (20856,31294),(13642,19263)
77 1 | t | (6986,30859),(107,19466)
78 1 | t | (40397,28538),(32515,15759)
79 1 | t | (49985,15380),(42047,43)
80 1 | t | (32715,11509),(24675,6)
81 1 | t | (41916,5154),(32914,357)
82 1 | t | (43056,42360),(32661,37729)
83 1 | t | (42941,37586),(32606,28547)
84 1 | t | (10104,18999),(15,7761)
85 1 | t | (41835,15752),(32828,5360)
86 1 | t | (50027,50073),(32453,42694)
87 1 | t | (24855,31262),(21146,19925)
88 1 | t | (24423,11473),(20828,181)
89 1 | t | (10146,7495),(138,81)
90 1 | t | (32511,31225),(25000,19942)
94 SELECT spgist_stat('spgist_idx');
96 ----------------------------------
102 usedSpace: 121.27 kbytes+
103 freeSpace: 46.07 kbytes +
108 leafPlaceholders: 569 +
109 innerPlaceholders: 0 +
115 CREATE TABLE test__int( a int[] );
116 \copy test__int from 'data/test__int.data'
117 CREATE INDEX gin_idx ON test__int USING gin ( a );
118 INSERT INTO test__int ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t );
119 INSERT INTO test__int ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) );
120 VACUUM ANALYZE test__int;
121 SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int);