Skip to main content

CodeWithFaisal/ Journal

Articles Topics Tags About Work ↗

© 2026 Faisal. Engineering notes from CodeWithFaisal.

Home
Topics
Tags
About the journal
RSS
Work
Experience
About Faisal
GitHub
LinkedIn

Home
Tags
#sql

Tagged articles

#sql

Articles about sql.

2 articles

Database
Sep 22, 2026
18 min read
How PostgreSQL Executes a Query: Reading EXPLAIN ANALYZE
Learn to read PostgreSQL execution plans, row estimates, scans, joins, sorts, buffers, and loops so you can diagnose slow production queries with evidence.
DatabaseSep 22, 202618 min read
Database
Sep 17, 2026
7 min read
Your Database Query Is Fast in Testing… Why Does It Become Slow in Production?
Why a query that is fast on test data becomes slow in production, with practical PostgreSQL checks for plans, indexes, statistics, locks, concurrency, and cache effects.
DatabaseSep 17, 20267 min read