|
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
SELECT Query Statistics
Total # of operations |
92.973 |
Total time for all operations (ms) |
206.399 |
Average time for each operation (ms) |
2.22 |
Operations per second |
0.00 |
Most common SQL queries |
|
|
Query |
Count |
Total Time |
Avg. Time |
SELECT name, list FROM ofPrivacyList WHERE username=? AND isDefault=? |
15.337 |
6.511 |
0 |
SELECT name, email, creationDate, modificationDate FROM ofUser WHERE username=? |
11.112 |
5.116 |
0 |
SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=? |
9.723 |
21.790 |
2 |
SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID=? |
8.993 |
4.518 |
0 |
SELECT groupName FROM ofGroupUser WHERE username=? |
8.104 |
14.552 |
1 |
SELECT name, propValue FROM ofUserProp WHERE username=? |
6.017 |
1.651 |
0 |
SELECT username FROM ofGroupUser WHERE administrator=? AND groupName=? ORDER BY username |
3.924 |
2.809 |
0 |
SELECT vcard FROM ofVCard WHERE username=? |
2.865 |
46.511 |
16 |
SELECT remotePort, permission FROM ofRemoteServerConf where xmppDomain=? |
2.625 |
1.795 |
0 |
SELECT description FROM ofGroup WHERE groupName=? |
2.405 |
834 |
0 |
SELECT name, propValue FROM ofGroupProp WHERE groupName=? |
1.962 |
505 |
0 |
SELECT name, startTime, endTime FROM ofUserFlag WHERE username=? AND name=? |
1.504 |
779 |
0 |
SELECT plainPassword, encryptedPassword FROM ofUser WHERE username=? |
1.499 |
1.045 |
0 |
SELECT stanza, creationDate FROM ofOffline WHERE username=? |
1.472 |
5.309 |
3 |
SELECT offlinePresence, offlineDate FROM ofPresence WHERE username=? |
1.181 |
1.058 |
0 |
SELECT privateData FROM ofPrivate WHERE username=? AND namespace=? |
1.027 |
8.505 |
8 |
SELECT registrationID FROM ofGatewayRegistration WHERE jid=? AND transportType=? |
532 |
793 |
1 |
SELECT secret, permission FROM ofExtComponentConf where subdomain=? AND wildcard=? |
475 |
293 |
0 |
SELECT xmppHash, legacyIdentifier, createDate, lastUpdate, imageType FROM ofGatewayAvatars WHERE jid=? |
445 |
4.005 |
9 |
SELECT name, isDefault FROM ofPrivacyList WHERE username=? |
430 |
108 |
0 |
|
|
INSERT Query Statistics
Total # of operations |
2.771 |
Total time for all operations (ms) |
5.017 |
Average time for each operation (ms) |
1.81 |
Operations per second |
0.00 |
Most common SQL queries |
|
|
Query |
Count |
Total Time |
Avg. Time |
INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?) |
1.471 |
1.116 |
0 |
INSERT INTO ofPubsubItem (serviceID, nodeID, id, jid, creationDate, payload) VALUES (?, ?, ?, ?, ?, ?) |
753 |
308 |
0 |
INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES (?, ?, ?) |
212 |
265 |
1 |
INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?) |
147 |
1.391 |
9 |
INSERT INTO ofOffline (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?, ?, ?, ?) |
61 |
607 |
9 |
INSERT INTO ofPubsubSubscription (serviceID,
nodeID, id, jid, owner, state, deliver, digest, digest_frequency,
expire, includeBody, showValues, subscriptionType, subscriptionDepth,
keyword) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
37 |
242 |
6 |
INSERT INTO ofPubsubAffiliation (serviceID, nodeID, jid, affiliation) VALUES (?, ?, ?, ?) |
37 |
222 |
6 |
INSERT INTO ofGatewayAvatars(jid, xmppHash,
legacyIdentifier, createDate, lastUpdate, imageType, imageData) VALUES
(?, ?, ?, ?, ?, ?, ?) |
23 |
398 |
17 |
INSERT INTO ofMucConversationLog (roomID, sender, nickname, logTime, subject, body) VALUES (?, ?, ?, ?, ?, ?) |
9 |
122 |
13 |
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 (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?) |
4 |
42 |
10 |
|
|
UPDATE Query Statistics
Total # of operations |
1.869 |
Total time for all operations (ms) |
9.047 |
Average time for each operation (ms) |
4.84 |
Operations per second |
0.00 |
Most common SQL queries |
|
|
Query |
Count |
Total Time |
Avg. Time |
UPDATE ofRoster SET sub=?, ask=?, recv=?, nick=? WHERE rosterID=? |
984 |
1.437 |
1 |
UPDATE ofVCard SET vcard=? WHERE username=? |
567 |
6.969 |
12 |
UPDATE ofMucRoom SET emptyDate=? WHERE roomID=? |
130 |
284 |
2 |
UPDATE ofID SET id=? WHERE idType=? AND id=? |
90 |
123 |
1 |
UPDATE ofGatewayRegistration SET lastLogin=? WHERE registrationID=? |
57 |
180 |
3 |
UPDATE ofGatewayAvatars SET legacyIdentifier=? WHERE jid=? |
36 |
41 |
1 |
UPDATE helgaUser SET sub=? WHERE jid=? |
2 |
1 |
0 |
UPDATE ofUser SET plainPassword=?, encryptedPassword=? WHERE username=? |
1 |
0 |
0 |
UPDATE ofPrivate SET privateData=?, name=? WHERE username=? AND namespace=? |
1 |
11 |
11 |
UPDATE helgaUser SET source=? WHERE jid=? |
1 |
1 |
1 |
|
|
DELETE Query Statistics
Total # of operations |
7.289 |
Total time for all operations (ms) |
11.942 |
Average time for each operation (ms) |
1.64 |
Operations per second |
0.00 |
Most common SQL queries |
|
|
Query |
Count |
Total Time |
Avg. Time |
DELETE FROM ofPresence WHERE username=? |
5.415 |
5.768 |
1 |
DELETE FROM ofRosterGroups WHERE rosterID=? |
1.002 |
751 |
0 |
DELETE FROM ofPubsubItem WHERE serviceID=? AND nodeID=? AND id=? |
751 |
3.255 |
4 |
DELETE FROM ofOffline WHERE username=? |
41 |
1.038 |
25 |
DELETE FROM webregRegistrations WHERE reg_date < ? |
29 |
193 |
6 |
DELETE FROM ofGatewayAvatars WHERE jid=? |
23 |
470 |
20 |
DELETE FROM ofRoster WHERE rosterID=? |
18 |
350 |
19 |
DELETE FROM helgaMessage WHERE event_id = ? |
4 |
57 |
14 |
DELETE FROM helgaEvent WHERE event_id = ? |
4 |
58 |
14 |
DELETE FROM webregRegistrations WHERE username = ? |
2 |
2 |
1 |
|
|
|