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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 12.076 7.989 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 7.446 4.899 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 6.783 26.255 3
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 6.639 7.148 1
    SELECT groupName FROM ofGroupUser WHERE username=? 5.818 11.328 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 3.508 1.330 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 3.050 1.663 0
    SELECT vcard FROM ofVCard WHERE username=? 2.126 50.199 23
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 2.069 2.054 0
    SELECT description FROM ofGroup WHERE groupName=? 1.955 1.014 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 1.525 399 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 1.181 1.210 1
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 1.168 871 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.145 7.656 6
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 987 1.059 1
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 863 3.478 4
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 521 497 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 495 5.772 11
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 354 904 2
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 349 85.928 246
INSERT Query Statistics
    Total # of operations 2.024
    Total time for all operations (ms) 6.036
    Average time for each operation (ms) 2.98
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.115 1.236 1
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 612 531 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 176 189 1
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 40 1.474 36
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 32 846 26
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 25 1.291 51
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 19 339 17
    INSERT INTO ofPrivate (privateData, name, username, namespace) VALUES (?, ?, ?, ?) 2 24 12
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1 37 37
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 1 32 32
UPDATE Query Statistics
    Total # of operations 992
    Total time for all operations (ms) 8.335
    Average time for each operation (ms) 8.40
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 439 6.001 13
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 322 1.757 5
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 96 302 3
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 53 141 2
    UPDATE ofID SET id=? WHERE idType=? AND id=? 47 82 1
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 34 52 1
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 1 0 0
DELETE Query Statistics
    Total # of operations 5.164
    Total time for all operations (ms) 12.498
    Average time for each operation (ms) 2.42
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 4.092 2.826 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 611 5.222 8
    DELETE FROM ofRosterGroups WHERE rosterID=? 339 956 2
    DELETE FROM ofGatewayAvatars WHERE jid=? 25 1.100 44
    DELETE FROM webregRegistrations WHERE reg_date < ? 24 278 11
    DELETE FROM ofOffline WHERE username=? 23 453 19
    DELETE FROM ofRoster WHERE rosterID=? 17 999 58
    DELETE FROM ofPubsubAffiliation WHERE serviceID=? AND nodeID=? AND jid=? 13 249 19
    DELETE FROM ofPubsubSubscription WHERE serviceID=? AND nodeID=? AND id=? 13 291 22
    DELETE FROM ofGatewayRegistration WHERE registrationID=? 1 1 1