PostgreSQL

Servidores de Banco de Dados    
SELECT pg_database.datname as "database_name", pg_size_pretty(pg_database_size(pg_database.datname)) 
FROM pg_database 
ORDER by pg_database_size(pg_database.datname) DESC;
  • Espaço ocupado pelas tabelas 
    SELECT *, pg_size_pretty(total_bytes) AS total
  , pg_size_pretty(index_bytes) AS INDEX
  , pg_size_pretty(toast_bytes) AS toast
  , pg_size_pretty(table_bytes) AS TABLE
FROM (
SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM (
    SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME
            , c.reltuples AS row_estimate
            , pg_total_relation_size(c.oid) AS total_bytes
            , pg_indexes_size(c.oid) AS index_bytes
            , pg_total_relation_size(reltoastrelid) AS toast_bytes
        FROM pg_class c
        LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
        WHERE relkind = 'r'
) a
) a
order by total_bytes;
  • Ver queries ativas
SELECT pid, age(clock_timestamp(), query_start), usename, client_addr, wait_event, state, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

Sub-Páginas / Relacionados :   PostGIS    

de     en     es     fr