summaryrefslogtreecommitdiff
path: root/contrib/pgstattuple/sql
diff options
context:
space:
mode:
authorHeikki Linnakangas2012-12-05 07:58:03 +0000
committerHeikki Linnakangas2012-12-05 07:58:03 +0000
commit357cbaaeae5bc1f385828be97345e7ea24235f92 (patch)
tree4eaea3119077cc3f7c484f9596f5cdae48641a60 /contrib/pgstattuple/sql
parentcdf498c5d76915954cb5d5c6097eb67eb94560c8 (diff)
Add pgstatginindex() function to get the size of the GIN pending list.
Fujii Masao, reviewed by Kyotaro Horiguchi.
Diffstat (limited to 'contrib/pgstattuple/sql')
-rw-r--r--contrib/pgstattuple/sql/pgstattuple.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/contrib/pgstattuple/sql/pgstattuple.sql b/contrib/pgstattuple/sql/pgstattuple.sql
index 2fd1152e8ce..8cb350d6ee1 100644
--- a/contrib/pgstattuple/sql/pgstattuple.sql
+++ b/contrib/pgstattuple/sql/pgstattuple.sql
@@ -6,7 +6,7 @@ CREATE EXTENSION pgstattuple;
-- indexes should be that.
--
-create table test (a int primary key);
+create table test (a int primary key, b int[]);
select * from pgstattuple('test'::text);
select * from pgstattuple('test'::regclass);
@@ -15,3 +15,7 @@ select * from pgstatindex('test_pkey');
select pg_relpages('test');
select pg_relpages('test_pkey');
+
+create index test_ginidx on test using gin (b);
+
+select * from pgstatginindex('test_ginidx');