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 75.170
    Total time for all operations (ms) 127.480
    Average time for each operation (ms) 1.70
    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.032 5.720 0
    SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? 8.427 3.728 0
    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? 7.490 3.591 0
    SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? 7.081 11.193 1
    SELECT groupName FROM ofGroupUser WHERE username=? 6.206 10.835 1
    SELECT name, propValue FROM ofUserProp WHERE username=? 3.957 1.191 0
    SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username 3.858 1.370 0
    SELECT description FROM ofGroup WHERE groupName=? 2.373 614 0
    SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? 2.330 1.662 0
    SELECT vcard FROM ofVCard WHERE username=? 2.119 23.762 11
    SELECT name, propValue FROM ofGroupProp WHERE groupName=? 1.928 386 0
    SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? 1.281 712 0
    SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? 1.279 446 0
    SELECT stanza, creationDate FROM ofOffline WHERE username=? 1.247 5.878 4
    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? 1.104 1.107 1
    SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? 943 1.812 1
    SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? 557 246 0
    SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? 524 3.998 7
    SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? 435 560 1
    SELECT SUM(messageSize) FROM ofOffline WHERE username=? 427 38.667 90
INSERT Query Statistics
    Total # of operations 2.160
    Total time for all operations (ms) 3.298
    Average time for each operation (ms) 1.53
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) 1.249 725 0
    INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) 618 183 0
    INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) 162 98 0
    INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) 54 582 10
    INSERT INTO ofGatewayAvatars(jid, xmppHash, legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES (?, ?, ?, ?, ?, ?, ?) 31 599 19
    INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) 23 843 36
    INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) 12 110 9
    INSERT INTO ofPrivate (privateData, name, username, namespace) VALUES (?, ?, ?, ?) 2 1 0
    INSERT INTO ofMucAffiliation (roomID, jid, affiliation) VALUES (?, ?, ?) 1 42 42
    INSERT INTO webregRegistrations SET username = ?, email = ?, reg_key = ?, pass_enc = ?, reg_date = ?, admins = ?, news = ? 1 10 10
UPDATE Query Statistics
    Total # of operations 1.101
    Total time for all operations (ms) 3.516
    Average time for each operation (ms) 3.19
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    UPDATE ofVCard SET vcard=? WHERE username=? 524 2.547 4
    UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? 316 550 1
    UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? 103 113 1
    UPDATE ofID SET id=? WHERE idType=? AND id=? 59 106 1
    UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? 59 162 2
    UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? 37 37 1
    UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? 2 1 0
    UPDATE ofMucRoom SET modificationDate=?, naturalName=?, description=?, canChangeSubject=?, maxUsers=?, publicRoom=?, moderated=?, membersOnly=?, canInvite=?, roomPassword=?, canDiscoverJID=?, logEnabled=?, rolesToBroadcast=?, useReservedNick=?, canChangeNick=?, canRegister=? WHERE roomID=? 1 0 0
DELETE Query Statistics
    Total # of operations 5.294
    Total time for all operations (ms) 5.805
    Average time for each operation (ms) 1.10
    Operations per second 0.00
    Most common SQL queries  

    Query Count Total Time Avg. Time
    DELETE FROM ofPresence WHERE username=? 4.258 2.953 0
    DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? 618 1.595 2
    DELETE FROM ofRosterGroups WHERE rosterID=? 316 319 1
    DELETE FROM ofOffline WHERE username=? 38 328 8
    DELETE FROM ofGatewayAvatars WHERE jid=? 31 378 12
    DELETE FROM webregRegistrations WHERE reg_date < ? 29 181 6
    DELETE FROM webregRegistrations WHERE username = ? 1 1 1
    DELETE FROM helgaMessage WHERE event_id = ? 1 20 20
    DELETE FROM ofGatewayPseudoRoster WHERE registrationID=? AND username=? 1 1 1
    DELETE FROM helgaEvent WHERE event_id = ? 1 29 29