Michael Monnerie wrote: > 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?
Maybe because you were doing running the analysis queries on the headervalue table at the time? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
