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

Bad performance when accessing Events without permission to any hosts

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 2.2.10, 3.0.2
    • API (A)
    • PostgreSQL 9.3.5
    • Sprint 4
    • 4

      There appears to be a significant performance impact when accessing Monitoring->Events without having permission to any host.

      See attached query plans for details.
      Groups with id 50 and 56 do not grant any host permission while 32 does.

      I presume you're already aware of http://explain.depesz.com for easier interpretation of pg query plans but I mention it anyway - just in case you're not

            sasha Alexander Vladishev
            okkuv9xh Marc
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: