• Sicer imamo to ponavadi v crontabu, ampak just to make sure

    rm -rf /var/lib/docker/overlay2/*/diff/tmp/*
    rm -rf /var/lib/docker/overlay2/*/merged/tmp/*
    
  • SQL for getting table and index sizes:

    psql -d arvio_amas -U postgres

    SELECT
      schema_name,
      relname,
      pg_size_pretty(table_size) AS size,
      table_size
    
    FROM (
           SELECT
             pg_catalog.pg_namespace.nspname           AS schema_name,
             relname,
             pg_relation_size(pg_catalog.pg_class.oid) AS table_size
    
           FROM pg_catalog.pg_class
             JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid
         ) t
    WHERE schema_name NOT LIKE 'pg_%'
    ORDER BY table_size DESC;
    Edited by Klemen Kubelj
  • Tule se lahko nabere se par GB:

    pip cache purge
0% Loading or .
You are about to add 0 people to the discussion. Proceed with caution.
Please register or to comment