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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 15.337 6.511 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 11.112 5.116 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 9.723 21.790 2
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 8.993 4.518 0
    SELECT groupName FROM ofGroupUser WHERE username=? 8.104 14.552 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 6.017 1.651 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 3.924 2.809 0
    SELECT vcard FROM ofVCard WHERE username=? 2.865 46.511 16
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 2.625 1.795 0
    SELECT description FROM ofGroup WHERE groupName=? 2.405 834 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 1.962 505 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 1.504 779 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 1.499 1.045 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.472 5.309 3
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 1.181 1.058 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 1.027 8.505 8
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 532 793 1
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 475 293 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 445 4.005 9
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 430 108 0
INSERT Query Statistics
    Total # of operations 2.771
    Total time for all operations (ms) 5.017
    Average time for each operation (ms) 1.81
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.471 1.116 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 753 308 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 212 265 1
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 147 1.391 9
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 61 607 9
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 37 242 6
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 37 222 6
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 23 398 17
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 9 122 13
    INSERT INTO ofPubsubNode (serviceID, nodeID, leaf, creationDate, modificationDate, parent, deliverPayloads, maxPayloadSize, persistItems, maxItems, notifyConfigChanges, notifyDelete, notifyRetract, presenceBased, sendItemSubscribe, publisherModel, subscriptionEnabled, configSubscription, accessModel, payloadType, bodyXSLT, dataformXSLT, creator, description, language, name, replyPolicy, associationPolicy, maxLeafNodes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 4 42 10
UPDATE Query Statistics
    Total # of operations 1.869
    Total time for all operations (ms) 9.047
    Average time for each operation (ms) 4.84
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 984 1.437 1
    UPDATE ofVCard SET vcard=? WHERE username=? 567 6.969 12
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 130 284 2
    UPDATE ofID SET id=? WHERE idType=? AND id=? 90 123 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 57 180 3
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 36 41 1
    UPDATE helgaUser SET sub=? WHERE jid=? 2 1 0
    UPDATE ofUser SET plainPassword=?, encryptedPassword=? WHERE username=? 1 0 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 1 11 11
    UPDATE helgaUser SET source=? WHERE jid=? 1 1 1
DELETE Query Statistics
    Total # of operations 7.289
    Total time for all operations (ms) 11.942
    Average time for each operation (ms) 1.64
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 5.415 5.768 1
    DELETE FROM ofRosterGroups WHERE rosterID=? 1.002 751 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 751 3.255 4
    DELETE FROM ofOffline WHERE username=? 41 1.038 25
    DELETE FROM webregRegistrations WHERE reg_date < ? 29 193 6
    DELETE FROM ofGatewayAvatars WHERE jid=? 23 470 20
    DELETE FROM ofRoster WHERE rosterID=? 18 350 19
    DELETE FROM helgaMessage WHERE event_id = ? 4 57 14
    DELETE FROM helgaEvent WHERE event_id = ? 4 58 14
    DELETE FROM webregRegistrations WHERE username = ? 2 2 1