Tag: #explain
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 6 posts
How to Read EXPLAIN ANALYZE — Finding the Real Bottleneck in a Query Plan
A walkthrough of how to read EXPLAIN ANALYZE output from beginning to end. Which order to read the nodes in, why cost is not a unit of time, what the gap between estimated and actual row counts tells you, and how to avoi
2026-07-26 · 13 min read #database#postgresql#explain#query-optimization#performanceDatabase Query Optimizer Complete Guide 2025: Volcano, Cascades, Cost-Based, Cardinality Estimation — PostgreSQL/MySQL In-Depth Analysis
A single SQL statement can turn into hundreds of different execution plans. From Volcano to Cascades, how cost-based optimizers work, the pitfalls of cardinality estimation, and the internals of PostgreSQL and MySQL — a
2026-04-15 · 24 min read #database#query-optimizer#volcano#cascades#cost-basedDatabase Complete Guide — Internals, Indexes, Query Planner, Partitioning, Vector DB (Season 2 Ep 13, 2025)
Treat a database as nothing but "the place where SQL goes" and you stay junior forever. The internals of B-Tree, LSM-Tree, and Hash Index; how the query planner turns a query into an execution plan; the four transaction
2026-04-15 · 14 min read #database#postgresql#b-tree#lsm-tree#indexingDatabase Performance Tuning Complete Guide: Query Optimization, Index Strategy, Connection Pool Management
Everything about DB performance tuning! EXPLAIN ANALYZE interpretation, index design (B-Tree/GIN/BRIN), slow query analysis, connection pooling (HikariCP/PgBouncer), N+1 resolution, partitioning, read replicas, query cac
2026-03-24 · 22 min read #database#performance#tuning#indexing#query-optimizationMySQL Query Optimization Practical Guide: From EXPLAIN Analysis to Index Design and Slow Query Tuning
A comprehensive guide covering MySQL EXPLAIN/EXPLAIN ANALYZE output interpretation, B-Tree/Hash/Full-text index types, composite index design (leftmost prefix rule, covering index), query rewriting patterns (subquery to
2026-03-11 · 17 min read #database#mysql#query-optimization#explain#index-tuningPostgreSQL Performance Tuning Practical Guide — Query Optimization, Index Strategy, EXPLAIN Analysis
A hands-on guide to the core of PostgreSQL performance tuning. Covers how to read EXPLAIN output, index strategies, query optimization patterns, and configuration tuning with practical code examples you can apply immedia
2026-03-02 · 11 min read #database#postgresql#performance#sql#indexing