[rt-users] New installation of 4.0.13 - performance problem viewing tickets.

Richard Colley rcolley at cardaccess.com.au
Mon Jul 29 04:46:25 EDT 2013

I am having a strange performance problem viewing tickets in a recent
installation of RT v4.0.13 on RHEL6.4.  DB is Postgres 9.2.

I think the problem is related to SearchBuilder.

I have only about 20 tickets in the db, and when viewing a ticket, it can
take up to 10+ secs to display the ticket.

The problem doesn't happen everytime, but when it does, I have hundreds (if
not thousands) of the following query being executed:

    SELECT consrc FROM pg_catalog.pg_constraint WHERE contype = 'c' AND
conrelid = 75880 AND conkey = '{5}'

each query iwth different conrelid and conkey values.

A short time ago, I discovered that this problem doesn't *seem* to happen
if I log out and log back in.  But if I leave a user logged in overnight,
then re-use the same session, the problem seems to occur.

Grep'ping through code shows that this statement is in DBD:Pg
column_info().  That doesn't seem to be directly called from RT, but is
part from SearchBuilder.

I'm afraid that's all I've got to go on for now.  Any suggestions on how to
narrow down and eventually remove this issue?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130729/1d7fdc78/attachment.html>

More information about the rt-users mailing list