Zabbix Database Cleanup

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Environment:
      Production

      Hi, 

      In our environment we are using zabbix for monitoring and database as postgresql.

      The problem we are having is postgresdb size has increased ad reach to 824GB. Now we need to cleanup the old data

       

      Few observation

      zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history') );
 pg_size_pretty
----------------
 191 GB
(1 row)


zabbix=# SELECT pg_size_pretty( pg_total_relation_size('trends_uint') );
 pg_size_pretty
----------------
 21 GB
(1 row)

zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history_uint') );
 pg_size_pretty
----------------
 566 GB
(1 row)

       

      Most of the space are occupied by above tables. Please help us to clean above tables without effecting the monitoring

       

      Regards

      jithin

            Assignee:
            Zabbix Support Team
            Reporter:
            jithin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: