postgres.rst
changeset 2383 0c73cdddca3a
parent 2382 5f3c4cc21532
child 2385 0c07e8df092f
equal deleted inserted replaced
2382:5f3c4cc21532 2383:0c73cdddca3a
   425 
   425 
   426   SELECT pg_column_size(5::smallint);
   426   SELECT pg_column_size(5::smallint);
   427   SELECT pg_column_size(5::int);
   427   SELECT pg_column_size(5::int);
   428   SELECT pg_column_size(5::bigint);
   428   SELECT pg_column_size(5::bigint);
   429 
   429 
       
   430 Index size::
       
   431 
       
   432   SELECT pg_indexes_size('my_ix');
       
   433 
   430 Largest index::
   434 Largest index::
   431 
   435 
   432   select pg_relation_size(oid), * from pg_class
   436   select pg_relation_size(oid), * from pg_class
   433   where relkind = 'i'
   437   where relkind = 'i'
   434   order by pg_relation_size(oid) desc;
   438   order by pg_relation_size(oid) desc;