Openfire 3.6.0
Logged in as admin - Abmelden

Database Query Statistics

Enable database query statistics to trace all database queries made. This can be useful to debug issues and monitor database performance. However, it's not recommended that you leave query statistics permanently running, as they will cause performance to degrade slightly.

Query Statistics Status


Query Statistics Settings

Refresh: | |
SELECT Query Statistics
    Total # of operations 31.805
    Total time for all operations (ms) 36.608
    Average time for each operation (ms) 1.15
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 6.545 3.454 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 5.183 2.573 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 3.588 3.056 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 2.817 2.921 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 2.389 478 0
    SELECT groupName FROM ofGroupUser WHERE username=? 2.084 3.526 1
    SELECT vcard FROM ofVCard WHERE username=? 861 6.682 7
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 682 238 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 541 852 1
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 507 198 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 504 289 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 504 191 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 494 974 1
    SELECT description FROM ofGroup WHERE groupName=? 488 130 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 341 66 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 319 570 1
    SELECT jid, transportType, username, password, nickname, registrationDate, lastLogin FROM ofGatewayRegistration WHERE registrationID=? 273 60 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 260 563 2
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 213 189 0
    SELECT imageData FROM ofGatewayAvatars WHERE jid=? 130 51 0
INSERT Query Statistics
    Total # of operations 709
    Total time for all operations (ms) 888
    Average time for each operation (ms) 1.25
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 474 270 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 173 63 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 37 22 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 11 44 4
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 6 201 33
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 3 150 50
    INSERT INTO helgaMessage (event_id, tojid, msg) VALUES (?, ?, ?) 1 0 0
    INSERT INTO ofGroupUser (groupName, username, administrator) VALUES (?, ?, ?) 1 65 65
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 1 60 60
    INSERT INTO helgaGroup (type, jid, group_id) VALUES (?, ?, ?) 1 12 12
UPDATE Query Statistics
    Total # of operations 453
    Total time for all operations (ms) 1.055
    Average time for each operation (ms) 2.33
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 151 802 5
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 129 145 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 77 30 0
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 75 16 0
    UPDATE ofID SET id=? WHERE idType=? AND id=? 11 5 0
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 10 57 5
DELETE Query Statistics
    Total # of operations 2.137
    Total time for all operations (ms) 2.582
    Average time for each operation (ms) 1.21
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.630 1.358 0
    DELETE FROM ofRosterGroups WHERE rosterID=? 217 187 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 173 297 1
    DELETE FROM ofRoster WHERE rosterID=? 88 184 2
    DELETE FROM ofOffline WHERE username=? 14 138 9
    DELETE FROM ofGatewayAvatars WHERE jid=? 6 393 65
    DELETE FROM webregRegistrations WHERE reg_date < ? 5 24 4
    DELETE FROM helgaGroup WHERE type=? AND jid=? AND group_id=? 2 0 0
    DELETE FROM ofPubsubSubscription WHERE serviceID=? AND nodeID=? AND id=? 1 0 0
    DELETE FROM ofPubsubAffiliation WHERE serviceID=? AND nodeID=? AND jid=? 1 1 1