Index size.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 19 Sep 2019 09:11:41 +0300
changeset 2383 0c73cdddca3a
parent 2382 5f3c4cc21532
child 2384 39bedf1e6b4e
Index size.
postgres.rst
--- a/postgres.rst	Thu Sep 19 09:10:33 2019 +0300
+++ b/postgres.rst	Thu Sep 19 09:11:41 2019 +0300
@@ -427,6 +427,10 @@
   SELECT pg_column_size(5::int);
   SELECT pg_column_size(5::bigint);
 
+Index size::
+
+  SELECT pg_indexes_size('my_ix');
+
 Largest index::
 
   select pg_relation_size(oid), * from pg_class