(29 rows)
* gin_stat(INDEXNAME) prints estimated counts for each indexed values
+ Note: since 8.4 gin_stat function has gin_stat(INDEXNAME, COLNUMBER)
+ prototype, single-argument function will return result for a first
+ column of index
# SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int) where nrow > 250;
value | nrow
59 | 259
(4 rows)
+ * bigint gin_count_estimate(INDEXNAME, TSQUERY) outputs number of indexed
+ rows matched query. It doesn't touch heap at all.
+
+# select gin_count_estimate('qq', 'star');
+ gin_count_estimate
+--------------------
+ 790
+(1 row)
+