I've got postgres with slow query logging on, and got some logs today: Jun 19 11:18:20 db.zmi.at postgres[8035]: [2-1] 2007-06-19 11:18:20 CEST DB=dbmail HOST=212.69.162.198(49440) SESSTRT=2007-06-19 10:30:01 CEST LOG: Dauer: 14147.986 ms Jun 19 11:18:20 db.zmi.at postgres[8035]: [2-2] Anweisung: SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN Jun 19 11:18:20 db.zmi.at postgres[8035]: [2-3] dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 953 AND Jun 19 11:18:20 db.zmi.at postgres[8035]: [2-4] status IN (0,1) AND headername ILIKE 'MESSAGE-ID' AND headervalue ILIKE Jun 19 11:18:20 db.zmi.at postgres[8035]: [2-5] '%<[EMAIL PROTECTED]>%' ORDER BY message_idnr
Jun 19 12:13:22 db.zmi.at postgres[6513]: [2-1] 2007-06-19 12:13:22 CEST DB=dbmail HOST=212.69.162.198(42632) SESSTRT=2007-06-19 07:35:27 CEST LOG: Dauer: 13141.858 ms Jun 19 12:13:22 db.zmi.at postgres[6513]: [2-2] Anweisung: SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN Jun 19 12:13:22 db.zmi.at postgres[6513]: [2-3] dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 711 AND Jun 19 12:13:22 db.zmi.at postgres[6513]: [2-4] status IN (0,1) AND headername ILIKE 'MESSAGE-ID' AND headervalue ILIKE '%<[EMAIL PROTECTED]>%' Jun 19 12:13:22 db.zmi.at postgres[6513]: [2-5] ORDER BY message_idnr Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-1] 2007-06-19 12:15:09 CEST DB=dbmail HOST=212.69.162.198(42632) SESSTRT=2007-06-19 07:35:27 CEST LOG: Dauer: 11383.227 ms Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-2] Anweisung: SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-3] dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 711 AND Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-4] status IN (0,1) AND headername ILIKE 'MESSAGE-ID' AND headervalue ILIKE '%<[EMAIL PROTECTED]>%' Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-5] ORDER BY message_idnr Where is such a SELECT coming from? Must be dbmail, but who causes such queries? And why are they so slow? mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
