[rt-devel] Excessive Query Execution

Alex Vandiver alexmv at bestpractical.com
Mon Jan 27 16:18:05 EST 2014

On Fri, 2014-01-24 at 15:34 -0500, Jeremy Gude wrote:
> We have an RT 4 system with a query that executes 90,000+ an hour,
> accounting for approximately 25% of database time.  The query is
> below: [snip]

It's a little tough to determine, from all of the placeholders, but that
looks to be "find me 10 groups that this user is a member of."  

> Any idea what option is turned on causing this to run so often?  Is it
> required?

You may need to spin up a development instance with $StatementLog
enabled, and see where it's being triggered from.  It's a generic enough
query that I can't guess what is triggering it, offhand.
  Do you have any local customizations or extensions installed?
 - Alex

More information about the rt-devel mailing list