# 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)