Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-10506

Node page very slow to load for nodes with more than 1000 events

    XMLWordPrintable

    Details

    • Sprint:
      Horizon - January 9th 2019, Horizon - January 23rd 2019, Horizon - January 30th 2019, Horizon - January 30th-2 2019

      Description

      The following "long running" query was found by a customer that is reporting that a few nodes have a very long load time on the node page.  Several customers are reporting this problem.

               SELECT events.*,
                       node.nodelabel,
                       service.servicename,
                       monitoringsystems.id AS systemId,
                       monitoringsystems.label AS systemLabel,
                       monitoringsystems.location AS location
                  FROM node
      RIGHT OUTER JOIN events
                    ON (events.nodeid = node.nodeid)
       LEFT OUTER JOIN monitoringsystems
                    ON (events.systemid = monitoringsystems.id)
       LEFT OUTER JOIN service
                    ON (service.serviceid = events.serviceid)
                 WHERE EVENTACKUSER IS NULL
                   AND EVENTS.NODEID = <node id>
                   AND EVENTDISPLAY='Y'
              ORDER BY EVENTID
                  DESC
                 LIMIT 5
                OFFSET 0;
      

        Attachments

          Activity

            People

            • Assignee:
              j-white Jesse White
              Reporter:
              david David Hustace
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: