At our work, all our logs are stored in a postgres database. We don’t utilise fts, so if I want to find a log line that matches some text, I have to use LIKE or ILIKE. The problem is that searching like this does not utilise indexes unless you search for something like ‘sometext%’ which is rarely helpful. So unless I can specify a small timespam within which to search, the query takes very long.