On Mon, 2013-10-28 at 09:54 -0400, Tod Detre wrote: > Adding the index did indeed fix the issue. I've pasted the line from > the SQL log below. It looks like the query is coming from > RT::Transaction. I'm not that great at perl so I'm not sure, but I > think it might be the method LoadCustomFieldByIdentifier. I do know > that the URL that starts the query is /Helpers/TicketHistory. > > [29826] [Mon Oct 28 13:33:12 2013] [debug]: SQL(2.188469s): SELECT > count(main.id) FROM ObjectCustomFieldValues main WHERE (main.Disabled > = '0') AND (main.ObjectId = '307581') AND (main.ObjectType = > 'RT::Transaction') ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1292)
To be useful, we'd unfortunately need to know the full stack trace. The full stack trace is shown in the UI in the Admin → Tools → SQL Queries page if StatementLog is enabled. - Alex
