====== Полезное при работе с PostgreSQL ======

===== Вход в БД =====

<code bash>sudo -u postgres psql</code>

===== Просмотр баз =====

<code bash>postgres=# \l</code>

===== Размер табличных пространств =====

<code sql>SELECT spcname, pg_size_pretty(pg_tablespace_size(spcname)) FROM pg_tablespace WHERE spcname<>'pg_global';</code>
<code sql>  spcname   | pg_size_pretty
------------+----------------
 pg_default | 78 MB
(1 row)</code>

===== Размер баз данных =====

<code sql>SELECT pg_database.datname,pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database ORDER BY pg_database_size(pg_database.datname) DESC;</code>
<code sql>    datname    |   size
---------------+----------
 amavisd       | 10237 kB
 vmail         | 10149 kB
 iredapd       | 9925 kB
 roundcubemail | 9181 kB
 iredadmin     | 8461 kB
 fail2ban      | 8341 kB
 template1     | 7901 kB
 postgres      | 7901 kB
 template0     | 7753 kB
(9 rows)
</code>