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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 3.878 1.440 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 2.329 1.146 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 2.241 2.121 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 2.048 848 0
    SELECT groupName FROM ofGroupUser WHERE username=? 1.849 3.285 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 1.022 190 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 754 235 0
    SELECT vcard FROM ofVCard WHERE username=? 639 9.062 14
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 621 366 0
    SELECT description FROM ofGroup WHERE groupName=? 474 120 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 445 149 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 439 124 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 377 79 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 370 744 2
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 291 583 2
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 218 160 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 163 251 1
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 134 29 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 119 1.266 10
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 103 15.583 151
INSERT Query Statistics
    Total # of operations 609
    Total time for all operations (ms) 448
    Average time for each operation (ms) 0.74
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 403 221 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 153 35 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 19 18 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 18 65 3
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 11 65 5
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 2 17 8
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1 0 0
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 1 27 27
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 1 0 0
UPDATE Query Statistics
    Total # of operations 243
    Total time for all operations (ms) 488
    Average time for each operation (ms) 2.01
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 143 252 1
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 35 44 1
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 29 160 5
    UPDATE ofID SET id=? WHERE idType=? AND id=? 18 5 0
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 11 25 2
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 7 2 0
DELETE Query Statistics
    Total # of operations 1.585
    Total time for all operations (ms) 1.664
    Average time for each operation (ms) 1.05
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.368 888 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 153 212 1
    DELETE FROM ofRosterGroups WHERE rosterID=? 30 149 4
    DELETE FROM ofOffline WHERE username=? 13 124 9
    DELETE FROM ofGatewayAvatars WHERE jid=? 11 211 19
    DELETE FROM webregRegistrations WHERE reg_date < ? 5 46 9
    DELETE FROM ofGatewayPseudoRoster WHERE registrationID=? 1 2 2
    DELETE FROM helgaMessage WHERE event_id = ? 1 16 16
    DELETE FROM ofRoster WHERE rosterID=? 1 0 0
    DELETE FROM helgaEvent WHERE event_id = ? 1 16 16