How PostgreSQL generates all possible query execution plans before choosing the best one.

System Design for SDE-2 and above: arpitbhayani.me/masterclass
System Design for Beginners: arpitbhayani.me/sys-design
Redis Internals: arpitbhayani.me/redis
Build Your Own Redis / DNS / BitTorrent / SQLite - with CodeCrafters.
Sign up and get 40% off - app.codecrafters.io/join?via=...
Recommended videos and playlists
If you liked this video, you will find the following videos and playlists helpful
System Design: • PostgreSQL connection ...
Designing Microservices: • Advantages of adopting...
Database Engineering: • How nested loop, hash,...
Concurrency In-depth: • How to write efficient...
Research paper dissections: • The Google File System...
Outage Dissections: • Dissecting GitHub Outa...
Hash Table Internals: • Internal Structure of ...
Bittorrent Internals: • Introduction to BitTor...
Things you will find amusing
Knowledge Base: arpitbhayani.me/knowledge-base
Bookshelf: arpitbhayani.me/bookshelf
Papershelf: arpitbhayani.me/papershelf
Other socials
I keep writing and sharing my practical experience and learnings every day, so if you resonate then follow along. I keep it no fluff.
LinkedIn: / arpitbhayani
Twitter: / arpit_bhayani
Weekly Newsletter: arpit.substack.com
Thank you for watching and supporting! it means a ton.
I am on a mission to bring out the best engineering stories from around the world and make you all fall in
love with engineering. If you resonate with this then follow along, I always keep it no-fluff.

[@glokta1]

The last time I felt such joy and satisfaction of understanding something in depth was watching 3B1B. Thanks a lot, Arpit! You make studying this enjoyable.

[@AsliEngineering]

Never imagined someone referencing 3B1B in the same sentence :) That's a huge compliment. Thanks.

[@raj_kundalia]

Thank you for making this!

[@harshitgangwar4500]

Thanks Aprit for the video.
Could you please also share a few links to documentation, blogs, etc that might be helpful and might serve as starting point to dive deeper?

[@AsliEngineering]

Official documentation and source code is what I am referring to understand.
Have given walkthrough of the source in previous set of videos in the series.

[@mevinaypanday]

Peoples include me are always looks for the video on Write and read path in Postgres SQL

[@Chromecastviewing-po7vy]

Is this specific to postgresql?

[@AsliEngineering]

No. Almost every single SQL database works like this.

[@nofoobar]

EXPLAIN ANALYZE helped me tens of times to understand the query plans and timings.
Thanks for covering query execution plans. This is real-real-wold stuff :)

[@AsliEngineering]

Glad it was helpful 🙌

[@dikshantrajput8925]

A small tip: while reading explain query results always read from bottom

[@1990mt]

Postgres a blunder db

[@roonywalsh8183]

Tf?

[@prashanthb6521]

For majority of usecases Postgres is a rock solid db.

[@1990mt]

@@prashanthb6521 there is nothing poor like postgress, we have thousands use cases where postgress ia useless, nothing close to oracle