EXPLAIN PLAN

Explain plan is mainly used to how Postgres will execute given a query and also Understanding this tells you how you can optimize your database with indexes to improve performance Most commonly, explain is run on SELECT statements. However, you …