pg_canary watches queries executed in development/test, parses them with PostgreSQL's own parser (pg_query), and combines the AST with schema metadata (indexes, column types) to warn about anti-patterns that can become slow queries in production: leading-wildcard LIKEs, function-wrapped columns in WHERE, ORDER BY RANDOM(), NOT IN (SELECT ...), and more.