-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
5.2.3
-
None
Steps to reproduce:
- Create 10 hosts with 400 triggers.
- Navigate to Monitoring -> Hosts
- Web page load slowly . (More than 10 seconds)
Result:
Time by script profiler debug:
******************** Script profiler ******************** Total time: 8.946059 Total SQL time: 8.506547 SQL count: 327 (selects: 222 | executes: 116) Peak memory usage: 28M Memory limit: 256M
Query slow:
SQL (8.121343): SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid IN (10788,10789,10790,10833,10834,10835,10836,10837,10838,10839,10840,10841,10842,10843,10844,10845,10846,10947,10948,10967,10970,10971,10972,10973,10974,10981,10982,10983,10984,11069,11070,11071,11072,11073,11074,11075,11076,11086,11087,11088,11089,11184,11185,11189,11190,11191,11213,11215,11216,11315) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)
Expected:
Query optimized.
- duplicates
-
ZBX-20620 Hosts overview after PostgreSQL 12 - 13 upgrade
- Closed