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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 22.626 9.091 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 13.099 6.044 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 10.926 26.193 2
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 10.924 4.523 0
    SELECT groupName FROM ofGroupUser WHERE username=? 9.649 17.718 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 6.343 2.787 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 6.128 2.293 0
    SELECT description FROM ofGroup WHERE groupName=? 3.742 2.141 0
    SELECT vcard FROM ofVCard WHERE username=? 3.556 63.810 17
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 3.349 2.575 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 3.063 811 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 2.032 767 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 2.028 948 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.984 6.438 3
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 1.910 1.372 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 1.580 4.689 2
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 1.107 1.872 1
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 756 2.105 2
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 684 83.486 122
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 654 855 1
INSERT Query Statistics
    Total # of operations 3.244
    Total time for all operations (ms) 10.780
    Average time for each operation (ms) 3.32
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.848 5.485 2
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 839 216 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 274 175 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 113 782 6
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 45 872 19
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 36 924 25
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 15 136 9
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 14 215 15
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 14 1.158 82
    INSERT INTO ofPubsubDefaultConf (serviceID, leaf, deliverPayloads, maxPayloadSize, persistItems, maxItems, notifyConfigChanges, notifyDelete, notifyRetract, presenceBased, sendItemSubscribe, publisherModel, subscriptionEnabled, accessModel, language, replyPolicy, associationPolicy, maxLeafNodes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 6 68 11
UPDATE Query Statistics
    Total # of operations 1.694
    Total time for all operations (ms) 8.587
    Average time for each operation (ms) 5.07
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 876 7.004 7
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 412 1.132 2
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 154 219 1
    UPDATE ofID SET id=? WHERE idType=? AND id=? 123 73 0
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 78 118 1
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 34 4 0
    UPDATE helgaUser SET sub=? WHERE jid=? 7 4 0
    UPDATE ofPrivacyList SET isDefault=?, list=? WHERE username=? AND name=? 3 32 10
    UPDATE helgaUser SET source=? WHERE jid=? 3 0 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 3 0 0
DELETE Query Statistics
    Total # of operations 11.351
    Total time for all operations (ms) 12.352
    Average time for each operation (ms) 1.09
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 9.916 4.501 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 836 3.879 4
    DELETE FROM ofRosterGroups WHERE rosterID=? 425 479 1
    DELETE FROM ofOffline WHERE username=? 50 432 8
    DELETE FROM webregRegistrations WHERE reg_date < ? 46 125 2
    DELETE FROM ofGatewayAvatars WHERE jid=? 45 2.586 57
    DELETE FROM ofRoster WHERE rosterID=? 13 138 10
    DELETE FROM webregRegistrations WHERE username = ? 4 1 0
    DELETE FROM helgaMessage WHERE event_id = ? 2 1 0
    DELETE FROM ofPubsubAffiliation WHERE serviceID=? AND nodeID=? AND jid=? 2 87 43