Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17294

Zabbix Database Cleanup

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • None
    • None
    • None
    • None
    • Production

    Description

      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

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            jkp jithin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: