fix counting in gin_stat for versions >= 9.4

[gevel.git] / README.gevel

diff --git a/README.gevel b/README.gevel
index 35b81d1..b09529e 100644 (file)
--- a/README.gevel
+++ b/README.gevel
@@ -157,7 +157,8 @@ regression=# select gist_tree('pix');
 
 # SELECT * FROM spgist_print('spgist_idx') as t
                (
-                       tid tid, 
+                       tid tid,
+                       allthesame bool,
                        node_n int, 
                        level int, 
                        tid_pointer tid, 
@@ -165,12 +166,12 @@ regression=# select gist_tree('pix');
                        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) 
@@ -195,3 +196,28 @@ regression=# select gist_tree('pix');
                                 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+
+