postgre.rst
changeset 1711 379096db1a5b
parent 1710 601c31753686
child 1905 fba288d59662
equal deleted inserted replaced
1710:601c31753686 1711:379096db1a5b
    80 
    80 
    81 List of databases sizes::
    81 List of databases sizes::
    82 
    82 
    83   \l+
    83   \l+
    84 
    84 
       
    85 List tables sizes::
       
    86 
       
    87   \d+
       
    88 
    85 Table total size (with indexes)::
    89 Table total size (with indexes)::
    86 
    90 
    87   SELECT pg_size_pretty(pg_total_relation_size('schemaname.tablename'));
    91   SELECT pg_size_pretty(pg_total_relation_size('schemaname.tablename'));
    88 
    92 
    89 Sole table size (without indexes and other)::
    93 Sole table size (without indexes and other)::