Using AI to Investigate a Slow Query: Why Django icontains Skipped Our pg_trgm Index

We used AI to find out why Django's icontains filter was quietly bypassing our PostgreSQL pg_trgm trigram index while product searches slowed to several seconds. Django's icontains lookup performs a c