[rt-users] Identification of a constant running query

[Joe Kirby]

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 at umbc.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140515/c536d4c2/attachment.htm>