# HG changeset patch # User Oleksandr Gavenko # Date 1568873501 -10800 # Node ID 0c73cdddca3a72ebd8ab024d175277cca342b72e # Parent 5f3c4cc2153299838cb2c79996011b6cf4f9b3cb Index size. diff -r 5f3c4cc21532 -r 0c73cdddca3a 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