[ZBX-13075] Map widget refreshes very slowly with large amount of nested maps Created: 2017 Nov 21  Updated: 2025 Jul 03

Status: READY TO DEVELOP
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.4.4
Fix Version/s: 7.0.17rc1, 7.4.1rc1, 8.0.0alpha1 (master)

Type: Problem report Priority: Trivial
Reporter: Kaspars Mednis Assignee: Zabbix Development Team
Resolution: Unresolved Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7.4
MariaDB Ver 15.1 Distrib 5.5.56
PHP Version 5.4.16

Attachments: PNG File Selection_150.png     PNG File problem_without_problems.png     PNG File tree_admin.png     PNG File tree_guest.png     PNG File tree_user.png    
Issue Links:
Duplicate
is duplicated by ZBX-15385 Long time SQL queries in MySQL 8.0 Closed
Sub-task
depends on ZBX-12748 Cloning dashboard which has navigatio... Open
depends on ZBX-12590 Incorrect selection in Map navigation... Reopened
depends on ZBX-12899 Circular dependencies possible when b... Closed
depends on ZBX-15006 Dashboard widget can be linked to itself Closed
depends on ZBX-12760 Problem with maps widget on Dashboard Need info
Team: Team B
Sprint: Sprint 21, Sprint 24, Sprint 25, Sprint 32, Sprint 33, Sprint 34, Sprint 35, Sprint 36, Sprint 37, Sprint 38, Sprint 39, Sprint 40, Sprint 41, Sprint 42, Sprint 43, Sprint 44, Sprint 45, Sprint 46, Nov 2018, Sprint 47, Dec 2018, Sprint 48, Jan 2019, Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 49 (Feb 2019), Sprint 50 (Mar 2019), Sprint 51 (Apr 2019), Sprint 52 (May 2019), Sprint 53 (Jun 2019), Sprint 54 (Jul 2019), Sprint 57 (Oct 2019), Sprint 58 (Nov 2019), Sprint 59 (Dec 2019), Sprint 60 (Jan 2020), Sprint 61 (Feb 2020), Sprint 62 (Mar 2020), Sprint 63 (Apr 2020), Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020), Sprint 68 (Sep 2020), Sprint 69 (Oct 2020), Sprint 70 (Nov 2020), Sprint 71 (Dec 2020), Sprint 72 (Jan 2021), Sprint 73 (Feb 2021), Sprint 74 (Mar 2021), Sprint 75 (Apr 2021)
Story Points: 2

 Description   

Map Navigation tree widget takes over 15 minutes to refresh. I currently have one main map with approximately 60 tiered sub-maps. When I try to put them in the map navigation tree widget, the widget is unable to refresh in 15 minutes causing the tree widget to be unusable.
The submaps go 3 - 4 levels deep, with the lowest level being comprised of maps that contain about 30 hosts, each host has approximately 75 items with about 60 triggers

Steps to reproduce:

  • Create Map including 12 submaps including 10 submaps each including 20 hosts each
  • Add this map to Dashboard Map tree widget, check the add submap checkbox

Result:
CPU Usage goes very high, the widget takes 3 minutes to load

Debug info:

Total time: 169.086932
Total SQL time: 0.518418
SQL count: 43 (selects: 30 | executes: 13)
Peak memory usage: 26.25M
Memory limit: 1024M

Generated at Fri Jul 04 07:50:04 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.