Slow nav bar creation for graphs

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Minor
    • None
    • Affects Version/s: 1.6
    • Component/s: Frontend (F)
    • None
    • Environment:
      Postgrsql 8.3

      LOG: duration: 84825.502 ms statement: SELECT MIN(t.clock) as clock FROM graphs_items gi, trends t WHERE gi.graphid=21661 AND t.itemid = gi.itemid

      That's the query, that becomes slow when your trends table grow and graph contains many items, so I'd call it a bug.

            Assignee:
            Unassigned
            Reporter:
            Zaitsev Kirill (teferi)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: