Postgresql comando

#Terminar proceso en la Base de Datos
SELECT pg_terminate_backend(#pid);
SELECT  * FROM pg_stat_activity WHERE datname='nombreBD';
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='nombreBD';

#Log de la Base de datos
tail -f /usr/local/var/postgres/server.log

#tamaño por tabla
\dt+ nombre_schema.

#tamaño por base de datos
\l+

#lista de schemas
\dn+

#Tamaño de la Base de datos --> Se debe conectar a la base de datos
select pg_database_size(current_database());
SELECT pg_size_pretty( pg_database_size( current_database() ) ) As human_size , pg_database_size( current_database() ) As raw_size;

SELECT pg_size_pretty( SUM(pg_database_size(datname))::bigint ) As human_size
    ,  SUM( pg_database_size(datname) )::bigint   As raw_size
    , pg_size_pretty( (SUM(pg_database_size(datname) ) - pg_database_size(current_database() ) )::bigint ) aS h_without_current
    FROM pg_database;