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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 13.818 6.242 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 7.982 4.366 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 2.792 1.317 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 2.548 1.419 0
    SELECT groupName FROM ofGroupUser WHERE username=? 2.078 3.723 1
    SELECT vcard FROM ofVCard WHERE username=? 1.109 3.393 3
    SELECT name, propValue FROM ofUserProp WHERE username=? 1.108 255 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 788 254 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 787 202 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 786 279 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 737 2.252 3
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 573 753 1
    SELECT description FROM ofGroup WHERE groupName=? 532 243 0
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 394 77 0
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 302 404 1
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 221 144 0
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 150 144 0
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 135 32 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 99 518 5
    SELECT jid, transportType, username, password, nickname, registrationDate, lastLogin FROM ofGatewayRegistration WHERE registrationID=? 95 24 0
INSERT Query Statistics
    Total # of operations 1.011
    Total time for all operations (ms) 1.262
    Average time for each operation (ms) 1.25
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 669 525 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 174 241 1
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 95 16 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 21 47 2
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 13 2 0
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 6 91 15
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 6 4 0
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 4 20 5
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 4 40 10
    INSERT INTO helgaMessage (event_id, tojid, msg) VALUES (?, ?, ?) 3 16 5
UPDATE Query Statistics
    Total # of operations 353
    Total time for all operations (ms) 929
    Average time for each operation (ms) 2.63
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 154 657 4
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 113 172 1
    UPDATE ofID SET id=? WHERE idType=? AND id=? 23 4 0
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 22 31 1
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 18 32 1
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 14 3 0
    UPDATE helgaUser SET sub=? WHERE jid=? 3 1 0
    UPDATE ofPrivacyList SET isDefault=?, list=? WHERE username=? AND name=? 2 2 1
    UPDATE helgaUser SET presence=? WHERE jid=? 2 27 13
    UPDATE helgaUser SET source=? WHERE jid=? 1 0 0
DELETE Query Statistics
    Total # of operations 2.287
    Total time for all operations (ms) 3.550
    Average time for each operation (ms) 1.55
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 1.966 1.500 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 173 1.022 5
    DELETE FROM ofRosterGroups WHERE rosterID=? 116 102 0
    DELETE FROM ofOffline WHERE username=? 11 245 22
    DELETE FROM ofGatewayAvatars WHERE jid=? 6 1 0
    DELETE FROM webregRegistrations WHERE reg_date < ? 6 68 11
    DELETE FROM ofRoster WHERE rosterID=? 3 47 15
    DELETE FROM helgaMessage WHERE event_id = ? 2 0 0
    DELETE FROM helgaEvent WHERE event_id = ? 2 2 1
    DELETE FROM ofGroupUser WHERE groupName=? AND username=? 1 563 563