add gin_stat() function

[gevel.git] / sql / gevel.sql

diff --git a/sql/gevel.sql b/sql/gevel.sql
index 6024eae..23aaa8c 100644 (file)
--- a/sql/gevel.sql
+++ b/sql/gevel.sql
@@ -14,3 +14,13 @@ CREATE INDEX gist_idx ON gevelt USING gist ( t );
 SELECT gist_stat('gist_idx');
 SELECT gist_tree('gist_idx');
 SELECT * FROM gist_print('gist_idx') as t(level int, valid bool, a box) where level=1;
+
+CREATE TABLE test__int( a int[] );
+\copy test__int from 'data/test__int.data'
+
+CREATE INDEX gin_idx ON test__int USING gin ( a );
+
+INSERT INTO test__int ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t );
+INSERT INTO test__int ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) );
+
+SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int);