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

Add index on auditlog Recordset ID

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • 7.0.0beta2
    • 7.0.0beta3
    • Server (S)
    • None

      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.

        1. R.jpg
          R.jpg
          739 kB

            arimdjonoks Artjoms Rimdjonoks
            arimdjonoks Artjoms Rimdjonoks
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: