I've got a query that is doing a search with wildcards:
OR (description LIKE '%change%')
Query: - Taking > 14 secs to run
SELECT j.id, ff.gtime FROM public.status AS s JOIN public.job AS j ON j.status_label_id = s.id AND j.clientid = 3369 JOIN public.log AS ff ON ff.jobid = j.id AND ff.clientid = 3369 AND (ff.description LIKE '%change%') ORDER BY gtime DESC LIMIT 100