Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-9143

Add index on auditlog Recordset ID

    • Prev.Sprint, S24-W24/25, S24-W26/27
    • 1

      Searching auditlog entries by Recordset ID is a common use-case:

      Auditlog table has no index on it:

      Indexes:
          "auditlog_pkey" PRIMARY KEY, btree (auditid)
          "auditlog_1" btree (userid, clock)
          "auditlog_2" btree (clock)
          "auditlog_3" btree (resourcetype, resourceid)
      

      We need to add one to avoid sequential table scan.

            bkruszewski Bartosz Kruszewski
            arimdjonoks Artjoms Rimdjonoks
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h
                8h