diff options
| author | Robert Haas | 2017-02-03 19:35:25 +0000 |
|---|---|---|
| committer | Robert Haas | 2017-02-03 19:37:16 +0000 |
| commit | e759854a09d49725a9519c48a0d71a32bab05a01 (patch) | |
| tree | df405d7c356302d430015d6cdd02b83805bbf240 /contrib/pgstattuple/sql | |
| parent | 39b8cc991fe31ee8df8b0fee467bbd9800fcc1c5 (diff) | |
pgstattuple: Add pgstathashindex.
Since pgstattuple v1.5 hasn't been released yet, no need for a new
extension version. The new function exposes statistics about hash
indexes similar to what other pgstatindex functions return for other
index types.
Ashutosh Sharma, reviewed by Kuntal Ghosh. Substantial further
revisions by me.
Diffstat (limited to 'contrib/pgstattuple/sql')
| -rw-r--r-- | contrib/pgstattuple/sql/pgstattuple.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/pgstattuple/sql/pgstattuple.sql b/contrib/pgstattuple/sql/pgstattuple.sql index d22c9f1c46d..81fd5d693b4 100644 --- a/contrib/pgstattuple/sql/pgstattuple.sql +++ b/contrib/pgstattuple/sql/pgstattuple.sql @@ -47,3 +47,7 @@ select pg_relpages(relname) from pg_class where relname = 'test_pkey'; create index test_ginidx on test using gin (b); select * from pgstatginindex('test_ginidx'); + +create index test_hashidx on test using hash (b); + +select * from pgstathashindex('test_hashidx'); |
