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

Task table missing index on foreign key constraint

XMLWordPrintable

    • Team A
    • Sprint 102 (Jul 2023), Sprint 103 (Aug 2023)
    • 0.5

      Performance can be slow when deleting host when there are many tasks on PostgreSQL due to missing index, note that MySQL create this index automatically

      Indexes:
          "task_pkey" PRIMARY KEY, btree (taskid)
          "task_1" btree (status, proxy_hostid)
      Foreign-key constraints:
          "c_task_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE 

            dimir dimir
            vso Vladislavs Sokurenko
            Team A
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: