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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 5.531 2.326 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 3.843 1.483 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 3.262 1.485 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 3.180 5.498 1
    SELECT groupName FROM ofGroupUser WHERE username=? 2.759 4.760 1
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 1.950 656 0
    SELECT name, propValue FROM ofUserProp WHERE username=? 1.880 503 0
    SELECT description FROM ofGroup WHERE groupName=? 1.082 241 0
    SELECT vcard FROM ofVCard WHERE username=? 1.004 9.877 9
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 975 184 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 919 879 0
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 614 286 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 601 178 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 600 263 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 567 2.170 3
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 410 841 2
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 346 113 0
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 229 24.585 107
    SELECT count(*) FROM ofUser 176 57 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 166 171 1
INSERT Query Statistics
    Total # of operations 918
    Total time for all operations (ms) 1.268
    Average time for each operation (ms) 1.38
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 553 429 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 256 83 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 48 7 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 16 325 20
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 8 60 7
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 7 204 29
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 5 2 0
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 4 38 9
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 4 1 0
    INSERT INTO ofGroupUser (groupName, username, administrator) VALUES (?, ?, ?) 4 44 11
UPDATE Query Statistics
    Total # of operations 460
    Total time for all operations (ms) 1.106
    Average time for each operation (ms) 2.40
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 261 789 3
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 72 171 2
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 71 87 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 19 11 0
    UPDATE ofID SET id=? WHERE idType=? AND id=? 18 4 0
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 15 42 2
    UPDATE helgaUser SET sub=? WHERE jid=? 2 2 1
    UPDATE helgaUser SET source=? WHERE jid=? 1 0 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 1 0 0
DELETE Query Statistics
    Total # of operations 1.969
    Total time for all operations (ms) 1.486
    Average time for each operation (ms) 0.75
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.588 734 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 255 387 1
    DELETE FROM ofRosterGroups WHERE rosterID=? 75 24 0
    DELETE FROM ofOffline WHERE username=? 24 159 6
    DELETE FROM webregRegistrations WHERE reg_date < ? 15 21 1
    DELETE FROM ofGatewayAvatars WHERE jid=? 5 44 8
    DELETE FROM ofRoster WHERE rosterID=? 3 95 31
    DELETE FROM webregRegistrations WHERE username = ? 2 2 1
    DELETE FROM helgaGroup WHERE type=? AND jid=? AND group_id=? 2 20 10