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 35.681
    Total time for all operations (ms) 49.464
    Average time for each operation (ms) 1.39
    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.777 2.352 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 4.268 1.814 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 3.788 1.035 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 3.258 2.837 0
    SELECT groupName FROM ofGroupUser WHERE username=? 2.758 4.610 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 1.866 359 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 1.854 595 0
    SELECT description FROM ofGroup WHERE groupName=? 1.119 304 0
    SELECT vcard FROM ofVCard WHERE username=? 1.106 8.535 7
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 925 199 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 905 426 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 608 140 0
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 608 455 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 605 203 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 572 860 1
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 400 692 1
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 343 67 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 314 807 2
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 249 270 1
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 236 18.867 79
INSERT Query Statistics
    Total # of operations 1.054
    Total time for all operations (ms) 1.043
    Average time for each operation (ms) 0.99
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 529 222 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 229 70 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 225 113 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 33 118 3
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 9 83 9
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 7 149 21
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 4 3 0
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 3 90 30
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 3 71 23
    INSERT INTO ofPubsubDefaultConf (serviceID, leaf, deliverPayloads, maxPayloadSize, persistItems, maxItems, notifyConfigChanges, notifyDelete, notifyRetract, presenceBased, sendItemSubscribe, publisherModel, subscriptionEnabled, accessModel, language, replyPolicy, associationPolicy, maxLeafNodes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2 24 12
UPDATE Query Statistics
    Total # of operations 721
    Total time for all operations (ms) 1.217
    Average time for each operation (ms) 1.69
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 289 415 1
    UPDATE ofVCard SET vcard=? WHERE username=? 255 678 2
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 48 28 0
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 48 64 1
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 44 7 0
    UPDATE ofID SET id=? WHERE idType=? AND id=? 35 12 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 2 13 6
DELETE Query Statistics
    Total # of operations 2.486
    Total time for all operations (ms) 2.499
    Average time for each operation (ms) 1.01
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.766 1.055 0
    DELETE FROM ofRosterGroups WHERE rosterID=? 368 298 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 228 172 0
    DELETE FROM ofRoster WHERE rosterID=? 79 661 8
    DELETE FROM ofOffline WHERE username=? 17 144 8
    DELETE FROM webregRegistrations WHERE reg_date < ? 14 23 1
    DELETE FROM ofGatewayAvatars WHERE jid=? 9 144 16
    DELETE FROM helgaMessage WHERE event_id = ? 2 0 0
    DELETE FROM helgaEvent WHERE event_id = ? 2 2 1
    DELETE FROM webregRegistrations WHERE username = ? 1 0 0