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

    Query Count Total Time Avg. Time
    SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? 18.883 11.191 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 12.349 11.887 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 11.389 57.665 5
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 10.548 7.960 0
    SELECT groupName FROM ofGroupUser WHERE username=? 9.620 18.661 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 5.892 2.081 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 5.382 2.066 0
    SELECT description FROM ofGroup WHERE groupName=? 3.432 1.040 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 3.254 4.022 1
    SELECT vcard FROM ofVCard WHERE username=? 3.184 76.612 24
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 2.691 2.149 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 1.970 943 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 1.874 2.481 1
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.816 8.888 4
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 1.717 3.858 2
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 1.285 4.713 3
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 901 600 0
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 681 116.247 170
    SELECT count(*) FROM ofUser 481 392 0
    SELECT name, isDefault FROM ofPrivacyList WHERE username=? 478 154 0
INSERT Query Statistics
    Total # of operations 3.450
    Total time for all operations (ms) 12.390
    Average time for each operation (ms) 3.59
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.759 3.905 2
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 1.003 371 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 414 198 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 81 2.608 32
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 72 1.580 21
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 25 1.066 42
    INSERT INTO ofPubsubSubscription (serviceID, nodeID, id, jid, owner, state, deliver, digest, digest_frequency, expire, includeBody, showValues, subscriptionType, subscriptionDepth, keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 17 109 6
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 17 1.709 100
    INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) 16 141 8
    INSERT INTO ofPubsubNode (serviceID, nodeID, leaf, creationDate, modificationDate, parent, deliverPayloads, maxPayloadSize, persistItems, maxItems, notifyConfigChanges, notifyDelete, notifyRetract, presenceBased, sendItemSubscribe, publisherModel, subscriptionEnabled, configSubscription, accessModel, payloadType, bodyXSLT, dataformXSLT, creator, description, language, name, replyPolicy, associationPolicy, maxLeafNodes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 8 181 22
UPDATE Query Statistics
    Total # of operations 1.852
    Total time for all operations (ms) 15.398
    Average time for each operation (ms) 8.31
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 770 4.265 5
    UPDATE ofVCard SET vcard=? WHERE username=? 708 10.538 14
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 180 238 1
    UPDATE ofID SET id=? WHERE idType=? AND id=? 98 102 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 50 184 3
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 36 33 0
    UPDATE ofMucRoom SET subject=? WHERE roomID=? 3 1 0
    UPDATE ofUser SET plainPassword=?, encryptedPassword=? WHERE username=? 2 0 0
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 2 15 7
    UPDATE ofUser SET email=? WHERE username=? 1 22 22
DELETE Query Statistics
    Total # of operations 7.902
    Total time for all operations (ms) 13.069
    Average time for each operation (ms) 1.65
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 5.988 4.372 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 997 4.293 4
    DELETE FROM ofRosterGroups WHERE rosterID=? 780 2.047 2
    DELETE FROM ofOffline WHERE username=? 44 809 18
    DELETE FROM webregRegistrations WHERE reg_date < ? 40 267 6
    DELETE FROM ofGatewayAvatars WHERE jid=? 25 821 32
    DELETE FROM ofRoster WHERE rosterID=? 10 226 22
    DELETE FROM helgaMessage WHERE event_id = ? 4 24 6
    DELETE FROM helgaEvent WHERE event_id = ? 4 15 3
    DELETE FROM webregRegistrations WHERE username = ? 4 0 0