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

Details

    • Problem report
    • Status: Reopened
    • Trivial
    • Resolution: Unresolved
    • 2.2.10, 3.0.2
    • None
    • API (A)
    • PostgreSQL 9.3.5
    • Sprint 4
    • 4

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            okkuv9xh Marc
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: