Programming, Sql, Postgresql, Performance, Data Engineering.
other accounts and causing slowdown. Hunting for Clues Upon close inspection, we see that there is something different in this particular query. The following line needs to be examined: urls && array( select id from acc_{account_id}.urls where url ILIKE '%enterprise_customer.com/jobs%' )::text[]