What is Postgres Query plan?

A quick peek into the underlying mechanism of the Postgres query execution process.

In my last article, I have discussed performance tuning in Java backend applications and database layer optimizations briefly. To continue that discussion, in this article I’m going to walk you through the Postgres SQL query execution process and query planner which is an…