Explain in 5 Levels of Difficulty
TL;DR: In this series, I will explain several concepts to five different audiences ...
Jun 24, 20251 min read2 reactions5 comments
Back to articles Jun 24, 2025 
Sep 5, 2024
Nov 16, 2023
Tag archive
#explain
Efficiently Analyzing PostgreSQL Queries with EXPLAIN
The EXPLAIN plan in PostgreSQL is a powerful tool that allows developers and database administrators...
Sep 5, 20242 min read0 reactions0 comments
Using the EXPLAIN plan to analyze Query execution in PostgreSQL
As a developer or database administrator, queries running slow is the last thing you want. When...
Nov 16, 20236 min read0 reactions0 comments
E
Jul 8, 2021EXPLAIN ANALYZE on COUNT() pushdown
In a distributed database, some operations are offloaded to the storage layer in order to avoid...
Jul 8, 20217 min read6 reactions0 comments
I
Jul 24, 2019Is GPL v2 Software can be used commercially?
I want to know if a GPLv2 software can be used commercially.
Jul 24, 20190 min read7 reactions4 comments
E
Feb 9, 2019Explain What is DOM like I'm 🖐
A brief explanation of the DOM
Feb 9, 20192 min read43 reactions9 comments
E
Dec 14, 2018E
Jul 9, 2018Explain Mock-Up versus Proof of Concept
I recently joined a project and they are working on a proof of concept in order to see if it meets th...
Jul 9, 20181 min read13 reactions3 comments
Q
Jan 17, 2017Query optimization: from a few weeks to 24 hours
Everyone who writes SQL queries encounters them once in a while: those queries that just take too...
Jan 17, 20174 min read16 reactions0 comments