Slow in production, fast in pgAdmin


Ever came across with a mysterious performance issue of a database query, while executing the exact same query directly on the same database instance performs fast as it should? Are you using prepared statements with your ORM or query builder? Are you on Postgres? Chances are, you're not really running the exact same queries. And in this post I'm about to elaborate on the importance of using proper data types during any interaction with a database.