Explaining and Analysing Postgres EXPLAIN ANALYSE
Introduction
SQL is a declarative query language. That means, you tell it what you want, you do not tell it how it's supposed to get it.
This blogs aims to give an intuition about how a query is internally run (on a very high-level). Understanding th...
blog.akjn.dev16 min read
Sameer Raj
One of the use cases of EXPLAIN is estimating the number of rows in your table. select count() from table1 is costly, alternatively, explain select count(*) from table1 will give an estimated result much faster.