Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-24095

Slow configuration sync on PostgreSQL due to redundant bytea type checks

XMLWordPrintable

    • S24-W6/7, S24-W8/9
    • 0.5

      After the fix:
      181452:20240214:172845.718 DCsync_configuration() items      : sql:9.955023 sync:7.854166 sec (5000103/0/0).

      Before the fix:
      183393:20240214:173040.807 DCsync_configuration() items      : sql:10.130892 sync:12.323380 sec (5000103/0/0).

      Full statistics:

      183393:20240214:173040.807 DCsync_configuration() config     : sql:0.000559 sync:0.000029 sec (1/0/0).
      183393:20240214:173040.807 DCsync_configuration() autoreg    : sql:0.000249 sync:0.000006 sec (1/0/0).
      183393:20240214:173040.807 DCsync_configuration() hosts      : sql:0.004168 sync:0.003787 sec (5001/0/0).
      183393:20240214:173040.807 DCsync_configuration() host_invent: sql:0.000355 sync:0.000004 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() templates  : sql:0.000306 sync:0.000024 sec (30/0/0).
      183393:20240214:173040.807 DCsync_configuration() globmacros : sql:0.000192 sync:0.000005 sec (1/0/0).
      183393:20240214:173040.807 DCsync_configuration() hostmacros : sql:0.004265 sync:0.004317 sec (5487/0/0).
      183393:20240214:173040.807 DCsync_configuration() interfaces : sql:0.000452 sync:0.000053 sec (26/0/0).
      183393:20240214:173040.807 DCsync_configuration() items      : sql:10.130892 sync:12.323380 sec (5000103/0/0).
      183393:20240214:173040.807 DCsync_configuration() template_items      : sql:0.514229 sync:0.002778 sec (14472/0/0).
      183393:20240214:173040.807 DCsync_configuration() prototype_items      : sql:0.325252 sync:0.001209 sec (6535/0/0).
      183393:20240214:173040.807 DCsync_configuration() item_discovery      : sql:0.001598 sync:0.001154 sec (6535/0/0).
      183393:20240214:173040.807 DCsync_configuration() triggers   : sql:0.006680 sync:0.008587 sec (5865/0/0).
      183393:20240214:173040.807 DCsync_configuration() trigdeps   : sql:0.000462 sync:0.000836 sec (1751/0/0).
      183393:20240214:173040.807 DCsync_configuration() trig. tags : sql:0.001796 sync:0.002796 sec (7638/0/0).
      183393:20240214:173040.807 DCsync_configuration() host tags : sql:0.000444 sync:0.000419 sec (900/0/0).
      183393:20240214:173040.807 DCsync_configuration() item tags : sql:0.005506 sync:0.007010 sec (23269/0/0).
      183393:20240214:173040.807 DCsync_configuration() functions  : sql:0.003164 sync:0.004066 sec (9630/0/0).
      183393:20240214:173040.807 DCsync_configuration() expressions: sql:0.000337 sync:0.000013 sec (10/0/0).
      183393:20240214:173040.807 DCsync_configuration() actions    : sql:0.000261 sync:0.000003 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() operations : sql:0.000325 sync:0.000003 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() conditions : sql:0.000227 sync:0.000003 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() corr       : sql:0.000221 sync:0.000004 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() corr_cond  : sql:0.000576 sync:0.000004 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() corr_op    : sql:0.000263 sync:0.000003 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() hgroups    : sql:0.000676 sync:0.000015 sec (18/0/0).
      183393:20240214:173040.807 DCsync_configuration() item pproc : sql:0.015281 sync:0.000025 sec (27/0/0).
      183393:20240214:173040.807 DCsync_configuration() item script param: sql:0.008207 sync:0.000003 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() maintenance: sql:0.000986 sync:0.000077 sec (0/0/0).
      183393:20240214:173040.807 DCsync_configuration() reindex    : 0.000378 sec.
      183393:20240214:173040.807 DCsync_configuration() total sql  : 11.019276 sec.
      183393:20240214:173040.807 DCsync_configuration() total sync : 12.360574 sec.
      183393:20240214:173040.807 DCsync_configuration() proxies    : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() hosts      : 5001 (9029 slots)
      183393:20240214:173040.807 DCsync_configuration() hosts_h    : 2 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() hosts_p    : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() psks       : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() ipmihosts  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() host_invent: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() htmpls     : 29 (43 slots)
      183393:20240214:173040.807 DCsync_configuration() gmacros    : 1 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() gmacros_m  : 1 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() hmacros    : 5487 (9029 slots)
      183393:20240214:173040.807 DCsync_configuration() hmacros_hm : 5209 (9029 slots)
      183393:20240214:173040.807 DCsync_configuration() kvs_paths : 0
      183393:20240214:173040.807 DCsync_configuration() interfaces : 1 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() interfaces_snmp : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() interfac_ht: 1 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() if_snmpitms: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() if_snmpaddr: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() item_discovery : 6535 (9029 slots)
      183393:20240214:173040.807 DCsync_configuration() items      : 5000103 (8911141 slots)
      183393:20240214:173040.807 DCsync_configuration() items_hk   : 5000103 (8911141 slots)
      183393:20240214:173040.807 DCsync_configuration() numitems   : 5000089 (8911141 slots)
      183393:20240214:173040.807 DCsync_configuration() preprocitems: 27 (43 slots)
      183393:20240214:173040.807 DCsync_configuration() preprocops : 27 (43 slots)
      183393:20240214:173040.807 DCsync_configuration() snmpitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() ipmiitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() trapitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() dependentitems  : 3 (11 slots)
      183393:20240214:173040.807 DCsync_configuration() logitems   : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() dbitems    : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() sshitems   : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() telnetitems: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() simpleitems: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() jmxitems   : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() calcitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() httpitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() scriptitems  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() functions  : 67 (101 slots)
      183393:20240214:173040.807 DCsync_configuration() triggers   : 5865 (9029 slots)
      183393:20240214:173040.807 DCsync_configuration() trigdeps   : 2511 (4007 slots)
      183393:20240214:173040.807 DCsync_configuration() trig. tags : 7638 (13553 slots)
      183393:20240214:173040.807 DCsync_configuration() expressions: 10 (17 slots)
      183393:20240214:173040.807 DCsync_configuration() actions    : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() conditions : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() corr.      : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() corr. conds: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() corr. ops  : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() hgroups    : 18 (29 slots)
      183393:20240214:173040.807 DCsync_configuration() item procs : 27 (43 slots)
      183393:20240214:173040.807 DCsync_configuration() maintenance: 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() maint tags : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() maint time : 0 (0 slots)
      183393:20240214:173040.807 DCsync_configuration() queue[0]   : 42 (48 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[1]   : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[2]   : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[3]   : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[4]   : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[5]   : 58 (72 allocated)
      183393:20240214:173040.807 DCsync_configuration() queue[6]   : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() pqueue     : 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() timer queue: 0 (0 allocated)
      183393:20240214:173040.807 DCsync_configuration() configfree : 59.401876%
      183393:20240214:173040.807 DCsync_configuration() strings    : 8696 (13553 slots)
      183393:20240214:173040.807 === memory statistics for configuration cache ===
      183393:20240214:173040.807 free chunks of size >= 256 bytes:        6
      183393:20240214:173040.807 min chunk size:        280 bytes
      183393:20240214:173040.807 max chunk size: 2551280592 bytes
      183393:20240214:173040.807 memory of total size 4053640048 bytes fragmented into 15082930 chunks
      183393:20240214:173040.807 of those, 2551291144 bytes are in        6 free chunks
      183393:20240214:173040.807 of those, 1502348904 bytes are in 15082924 used chunks
      183393:20240214:173040.807 of those,  241326864 bytes are used by allocation overhead
      183393:20240214:173040.807 ================================
       

            vso Vladislavs Sokurenko
            vso Vladislavs Sokurenko
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: