On Fri, Sep 16, 2011 at 05:08:24PM +0300, Michael Stepanov wrote: > Hi, > > Our RT3 system is a big and it crashes time to time. Today we found one > query in the slow queries log which killed the system: > * > # Query_time: 97 Lock_time: 0 Rows_sent: 15906633 Rows_examined: 39069181 > SELECT main.* FROM Transactions main WHERE (main.Type = 'Create' OR > main.Type = 'Comment' OR main.Type = 'Correspond') ORDER BY main.Created > ASC, main.id ASC; > * > Is there a way to reduce a number of returning records on the application > level?
That doesn't looks like a standard RT query, but you haven't provided your version. You'll probably want to turn on the StatementLog option and figure out where that query is coming from so you can fix the source. -kevin
pgpHK7g0r9LfJ.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
