diff options
| author | Heikki Linnakangas | 2012-12-05 07:58:03 +0000 |
|---|---|---|
| committer | Heikki Linnakangas | 2012-12-05 07:58:03 +0000 |
| commit | 357cbaaeae5bc1f385828be97345e7ea24235f92 (patch) | |
| tree | 4eaea3119077cc3f7c484f9596f5cdae48641a60 /contrib/pgstattuple/sql | |
| parent | cdf498c5d76915954cb5d5c6097eb67eb94560c8 (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.sql | 6 |
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'); |
