Did you enabled query logging in PostgreSQL? This should return problematic queries. And you should give the “Performance Log” of OTRS a chance.
Thanks.
I had already tried logging in postgresql and nothing really jumped out as being an issue. I have enable the performance log so will see whether that shows anything interesting.
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand 4446 Ph +64 6 357 8168, Mob +64 27 542 4015
“Specialising in providing low-cost professional Internet Services since 1997"