summaryrefslogtreecommitdiff
path: root/contrib/pgstattuple/sql
diff options
context:
space:
mode:
authorRobert Haas2017-02-03 19:35:25 +0000
committerRobert Haas2017-02-03 19:37:16 +0000
commite759854a09d49725a9519c48a0d71a32bab05a01 (patch)
treedf405d7c356302d430015d6cdd02b83805bbf240 /contrib/pgstattuple/sql
parent39b8cc991fe31ee8df8b0fee467bbd9800fcc1c5 (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.sql4
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');