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 85.910
    Total time for all operations (ms) 168.831
    Average time for each operation (ms) 1.97
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 18.873 11.601 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 9.856 4.282 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 9.662 4.953 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 7.152 16.913 2
    SELECT groupName FROM ofGroupUser WHERE username=? 6.112 13.034 2
    SELECT name, propValue FROM ofUserProp WHERE username=? 5.205 1.324 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 3.434 1.691 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 2.154 1.196 0
    SELECT description FROM ofGroup WHERE groupName=? 2.075 534 0
    SELECT vcard FROM ofVCard WHERE username=? 2.072 37.895 18
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 1.717 367 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 1.599 834 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 1.593 1.701 1
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.405 3.474 2
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 1.211 603 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 845 1.561 1
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 670 246 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 506 569 1
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 495 2.446 4
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 436 49.998 114
INSERT Query Statistics
    Total # of operations 2.267
    Total time for all operations (ms) 6.028
    Average time for each operation (ms) 2.66
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.392 2.593 1
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 620 1.497 2
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 107 54 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 67 478 7
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 33 274 8
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 12 371 30
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 7 564 80
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 4 28 7
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 4 38 9
    INSERT INTO ofGroupUser (groupName, username, administrator) VALUES (?, ?, ?) 4 34 8
UPDATE Query Statistics
    Total # of operations 954
    Total time for all operations (ms) 5.321
    Average time for each operation (ms) 5.58
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 498 4.546 9
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 171 380 2
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 100 277 2
    UPDATE ofID SET id=? WHERE idType=? AND id=? 70 27 0
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 57 46 0
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 48 19 0
    UPDATE helgaUser SET sub=? WHERE jid=? 4 1 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 3 2 0
    UPDATE helgaUser SET source=? WHERE jid=? 2 0 0
    UPDATE ofUser SET plainPassword=?, encryptedPassword=? WHERE username=? 1 23 23
DELETE Query Statistics
    Total # of operations 4.875
    Total time for all operations (ms) 11.105
    Average time for each operation (ms) 2.28
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 3.975 3.834 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 618 6.328 10
    DELETE FROM ofRosterGroups WHERE rosterID=? 180 90 0
    DELETE FROM ofGatewayAvatars WHERE jid=? 33 354 10
    DELETE FROM webregRegistrations WHERE reg_date < ? 27 133 4
    DELETE FROM ofOffline WHERE username=? 26 106 4
    DELETE FROM ofRoster WHERE rosterID=? 9 215 23
    DELETE FROM helgaGroup WHERE type=? AND jid=? AND group_id=? 2 43 21
    DELETE FROM webregRegistrations WHERE username = ? 2 0 0
    DELETE FROM helgaMessage WHERE event_id = ? 1 0 0