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

Audit log page opening takes a long time

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 6.4.20, 7.0.6
    • Server (S)
    • None
    • Ubuntu 22.04.5 LTS, zabbix-server 7.0.6, nginx 1.18.0, postgresql 14.13, timescaledb 2.17.2
    • Support backlog

      Steps to reproduce:

      1. From the side bar, choose "Reports"
      2. From the sub-menu, choose "Audit log"

      Result:
      zabbix-server has been updated from version 6.4.20 to 7.0.6. After a while, a problem appeared with the “Audit log” page loading for too long, more than 5 minutes. When analyzing the query plan in the database, it turned out that select from the “auditlog” table takes a long time, and decompressing some timescale chunks takes more than two minutes.

      The script "postgresql/timescaledb/schema.sql script" ran after the update.
      Expected:
      Audit reports page opens faster,

        1. chunks_detailed_size_auditlog.txt
          6 kB
        2. chunks_detailed_size_history_uint.txt
          19 kB
        3. chunks_detailed_size_history.txt
          19 kB
        4. chunks_detailed_size_trends_uint.txt
          3 kB
        5. chunks_detailed_size_trends.txt
          3 kB
        6. pg_settings.txt
          29 kB
        7. QUERY PLAN.txt
          37 kB
        8. zbx_25808_explain_after_analyze.txt
          5.20 MB
        9. zbx_25808_explain.txt
          5.03 MB

            askolmeisters Armands Arseniuss Skolmeisters
            p.kashtankin Pavel
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 5h
                5h