Aller au contenu

RDSHighDiskConsumption#

Fires when database is using more than 80% of disk capacity (warning) and 95% (critical).

Troubleshooting Hints#

  • Connect to the database with root account
  • Check databases list with \l
  • For each databases check its size
    SELECT pg_size_pretty( pg_database_size('gitea') );
    
  • To see tables size connect to each database.
    \c gitea
    #fill the secret
    
    and check tables size with \dt+ or with:
    SELECT pg_size_pretty( pg_total_relation_size('tablename') );
    

Solutions#