# SELECT * FROM spgist_print('spgist_idx') as t
(
- tid tid,
+ tid tid,
+ allthesame bool,
node_n int,
level int,
tid_pointer tid,
node_label int,
leaf_value point
) where level = 1;
- tid | node_n | level | tid_pointer | prefix | node_label | leaf_value
--------+--------+-------+-------------+-------------------------------------+------------+------------
- (1,1) | 0 | 1 | (5,4) | (24530.2070484581,23595.7092511013) | |
- (1,1) | 1 | 1 | (5,3) | (24530.2070484581,23595.7092511013) | |
- (1,1) | 2 | 1 | (5,2) | (24530.2070484581,23595.7092511013) | |
- (1,1) | 3 | 1 | (5,1) | (24530.2070484581,23595.7092511013) | |
+ tid | allthesame | node_n | level | tid_pointer | prefix | node_label | leaf_value
+-------+------------+--------+-------+-------------+-------------------------------------+------------+------------
+ (1,1) | f | 0 | 1 | (5,4) | (24530.2070484581,23595.7092511013) | |
+ (1,1) | f | 1 | 1 | (5,3) | (24530.2070484581,23595.7092511013) | |
+ (1,1) | f | 2 | 1 | (5,2) | (24530.2070484581,23595.7092511013) | |
+ (1,1) | f | 3 | 1 | (5,1) | (24530.2070484581,23595.7092511013) | |
* gin_stat(INDEXNAME) prints estimated counts for each indexed values
Note: since 8.4 gin_stat function has gin_stat(INDEXNAME, COLNUMBER)
790
(1 row)
+ * text gin_statpage(INDEXNAME)
+ Prints various stat about index internals.
+
+# select gin_statpage('gin_idx');
+ gin_statpage
+------------------------------
+ totalPages: 32 +
+ dataPages: 1 +
+ dataInnerPages: 0 +
+ dataLeafPages: 1 +
+ dataInnerFreeSpace: 0 +
+ dataLeafFreeSpace: 4454 +
+ dataInnerTuplesCount: 0 +
+ dataLeafIptrsCount: 3600 +
+ entryPages: 31 +
+ entryInnerPages: 21 +
+ entryLeafPages: 10 +
+ entryInnerFreeSpace: 15160+
+ entryLeafFreeSpace: 32788+
+ entryInnerTuplesCount: 7810 +
+ entryLeafTuplesCount: 305 +
+ entryPostingSize: 42122+
+ entryPostingCount: 96759+
+ entryAttrSize: 64924+
+