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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 9.013 3.400 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 8.003 2.632 0
    SELECT name, propValue FROM ofUserProp WHERE username=? 5.314 1.182 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 5.055 6.160 1
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 4.948 1.905 0
    SELECT groupName FROM ofGroupUser WHERE username=? 4.277 7.458 1
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 2.530 1.043 0
    SELECT vcard FROM ofVCard WHERE username=? 1.490 16.590 11
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 1.426 834 0
    SELECT description FROM ofGroup WHERE groupName=? 1.391 293 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 1.265 252 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 854 638 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 854 357 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 831 3.511 4
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 742 534 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 642 1.414 2
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 374 148 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 291 299 1
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 267 47.389 177
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 253 59 0
INSERT Query Statistics
    Total # of operations 1.459
    Total time for all operations (ms) 1.912
    Average time for each operation (ms) 1.31
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 841 451 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 455 149 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 72 91 1
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 47 237 5
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 10 249 24
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 6 246 41
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 6 18 3
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 4 159 39
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 4 154 38
    INSERT INTO helgaEvent (event_id, owner, creation, execution, type) VALUES (?, ?, ?, ?, ?) 4 54 13
UPDATE Query Statistics
    Total # of operations 630
    Total time for all operations (ms) 2.362
    Average time for each operation (ms) 3.75
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 369 862 2
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 96 1.328 13
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 60 109 1
    UPDATE ofID SET id=? WHERE idType=? AND id=? 49 8 0
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 31 27 0
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 23 15 0
    UPDATE ofUser SET plainPassword=?, encryptedPassword=? WHERE username=? 2 13 6
DELETE Query Statistics
    Total # of operations 3.381
    Total time for all operations (ms) 5.407
    Average time for each operation (ms) 1.60
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 2.772 1.871 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 455 1.123 2
    DELETE FROM ofRosterGroups WHERE rosterID=? 96 1.661 17
    DELETE FROM ofOffline WHERE username=? 21 503 23
    DELETE FROM webregRegistrations WHERE reg_date < ? 19 84 4
    DELETE FROM ofGatewayAvatars WHERE jid=? 6 162 27
    DELETE FROM helgaEvent WHERE event_id = ? 5 3 0
    DELETE FROM helgaMessage WHERE event_id = ? 5 0 0
    DELETE FROM webregRegistrations WHERE username = ? 2 0 0