3 ms·

What's the best resource for the equivalent of this page but for Postgres?

by SeanA208 4y ago

qsort 4y ago
[flagged]
- happytoexplain 4y ago
  Note that the official docs are not always the best resource for a given topic (in general - I don't know about Postgres specifically). "What is the best resource" is a totally reasonable question, and general opinion may be that the answer is the official docs.
mkl95 4y ago
Freshly translated (no affiliation whatsoever) https://postgrespro.com/community/books/internals https://postgrespro.com/community/books/internals
- deleted 4y ago
  [deleted]
fabian2k 4y ago
As a tool to read the output: https://explain.depesz.com/ https://explain.depesz.com/ Not entirely necessary when you're more familiar with it, but still useful. And when starting it's much easier to read. https://www.depesz.com/tag/unexplainable/ https://www.depesz.com/tag/unexplainable/ This series of blog posts is one option. But my impression is that most of this comes simply with experience. At first the main thing you'd look for is simply whether it uses the indexes you want it to use, or if it does full table scans. I'd also recommend to simply read the Postgres manual, at least the parts that are not entirely about the syntax of various commands. There is a lot of information in there that will help to understand how Postgres works.
- Strum355 4y ago
  I personally prefer https://explain.dalibo.com https://explain.dalibo.com over depesz's version, both from a visualization standpoint (I can more clearly see the hierarchy of operations) but also because I've had some not great experiences with depesz the individual. Great blog, but a really soured opinion of him.
wswope 4y ago
Markus Winand's "Use The Index, Luke" site is the classic reference. It covers most of the major DBs, but also gets into PG specifics. https://use-the-index-luke.com/sql/explain-plan/postgresql/operations https://use-the-index-luke.com/sql/explain-plan/postgresql/o... Understanding query plans is a universal skill that mostly transcends database particulars, so even this Planetscale article will serve as a good primer too.
avg_dev 4y ago
https://www.postgresql.org/docs/current/using-explain.html https://www.postgresql.org/docs/current/using-explain.html

What's the best resource for the equivalent of this page but for Postgres?

qsort 4y ago

[flagged]

happytoexplain 4y ago
Note that the official docs are not always the best resource for a given topic (in general - I don't know about Postgres specifically). "What is the best resource" is a totally reasonable question, and general opinion may be that the answer is the official docs.

mkl95 4y ago

Freshly translated (no affiliation whatsoever) https://postgrespro.com/community/books/internals https://postgrespro.com/community/books/internals

deleted 4y ago
[deleted]

fabian2k 4y ago

As a tool to read the output: https://explain.depesz.com/ https://explain.depesz.com/ Not entirely necessary when you're more familiar with it, but still useful. And when starting it's much easier to read. https://www.depesz.com/tag/unexplainable/ https://www.depesz.com/tag/unexplainable/ This series of blog posts is one option. But my impression is that most of this comes simply with experience. At first the main thing you'd look for is simply whether it uses the indexes you want it to use, or if it does full table scans. I'd also recommend to simply read the Postgres manual, at least the parts that are not entirely about the syntax of various commands. There is a lot of information in there that will help to understand how Postgres works.

Strum355 4y ago
I personally prefer https://explain.dalibo.com https://explain.dalibo.com over depesz's version, both from a visualization standpoint (I can more clearly see the hierarchy of operations) but also because I've had some not great experiences with depesz the individual. Great blog, but a really soured opinion of him.

wswope 4y ago

Markus Winand's "Use The Index, Luke" site is the classic reference. It covers most of the major DBs, but also gets into PG specifics. https://use-the-index-luke.com/sql/explain-plan/postgresql/operations https://use-the-index-luke.com/sql/explain-plan/postgresql/o... Understanding query plans is a universal skill that mostly transcends database particulars, so even this Planetscale article will serve as a good primer too.

avg_dev 4y ago

https://www.postgresql.org/docs/current/using-explain.html https://www.postgresql.org/docs/current/using-explain.html