Identification of a constant running query

RT Users
1

The following query runs an average of 20,000 times per hour.

We are unable to determine if this is Quick Search or some other report written that is being refreshed forever.

Any ideas?

Thanks

Joe

SELECT main.*
FROM
( SELECT DISTINCT main.id
FROM Users main
JOIN Principals Principals_1
ON ( Principals_1.id = main.id )
JOIN CachedGroupMembers CachedGroupMembers_2
ON ( CachedGroupMembers_2.MemberId = Principals_1.id )
WHERE (Principals_1.Disabled = ‘0’)
AND (CachedGroupMembers_2.GroupId = ‘919190’)
AND (CachedGroupMembers_2.Disabled = ‘0’)
AND (lower(Principals_1.PrincipalType) = ‘user’)
) distinctquery,
Users main
WHERE (main.id = distinctquery.id)
ORDER BY main.Name ASC

Joe Kirby , Assistant Vice President, Business Systems
Division of Information Technology (DoIT)
Support Response - http://www.umbc.edu/doit
Administration 627
Office - 410-455-3020
Email - kirby@umbc.edu

2

The following query runs an average of 20,000 times per hour.
We are unable to determine if this is Quick Search or some other report written that is being refreshed forever.

It’s got nothing to do with the Quick Search, note the lack of Queue.

Is it actually slow? Just because it runs a lot, doesn’t mean that
it’s inefficient. It’s a query to find out if someone is a member of
a group. Figure out what group id 919190 is, and show an explain of
the query.

Your RT version is also highly relevant.

-kevin