[rt-devel] Excessive Query Execution
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
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?
More information about the rt-devel