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.475
    Total time for all operations (ms) 23.592
    Average time for each operation (ms) 1.10
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 4.795 1.795 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 3.430 1.790 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 2.008 1.629 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 1.839 647 0
    SELECT groupName FROM ofGroupUser WHERE username=? 1.602 2.822 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 777 231 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 572 215 0
    SELECT vcard FROM ofVCard WHERE username=? 568 1.633 2
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 506 340 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 431 142 0
    SELECT description FROM ofGroup WHERE groupName=? 430 111 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 430 136 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 364 2.294 6
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 286 66 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 258 143 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 177 252 1
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 160 151 0
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 143 39 0
    SELECT jid, transportType, username, password, nickname, registrationDate, lastLogin FROM ofGatewayRegistration WHERE registrationID=? 109 44 0
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 107 21 0
INSERT Query Statistics
    Total # of operations 523
    Total time for all operations (ms) 5.045
    Average time for each operation (ms) 9.65
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 303 152 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 106 25 0
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 68 4.622 67
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 26 45 1
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 9 3 0
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 2 40 20
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2 56 28
    INSERT INTO ofGroupUser (groupName, username, administrator) VALUES (?, ?, ?) 2 55 27
    INSERT INTO ofVCard (username, vcard) VALUES (?, ?) 1 0 0
    INSERT INTO ofPrivate (privateData, name, username, namespace) VALUES (?, ?, ?, ?) 1 0 0
UPDATE Query Statistics
    Total # of operations 589
    Total time for all operations (ms) 354
    Average time for each operation (ms) 0.60
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 375 145 0
    UPDATE ofVCard SET vcard=? WHERE username=? 113 152 1
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 26 27 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 26 6 0
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 23 6 0
    UPDATE ofID SET id=? WHERE idType=? AND id=? 22 16 0
    UPDATE ofGatewayPseudoRoster SET nickname=? WHERE registrationID=? AND username=? 2 2 1
    UPDATE ofGatewayPseudoRoster SET groups=? WHERE registrationID=? AND username=? 2 0 0
DELETE Query Statistics
    Total # of operations 1.507
    Total time for all operations (ms) 834
    Average time for each operation (ms) 0.55
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.002 528 0
    DELETE FROM ofRosterGroups WHERE rosterID=? 375 71 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 107 106 0
    DELETE FROM ofOffline WHERE username=? 17 126 7
    DELETE FROM webregRegistrations WHERE reg_date < ? 4 2 0
    DELETE FROM webregRegistrations WHERE username = ? 1 1 1
    DELETE FROM ofGatewayAvatars WHERE jid=? 1 0 0