PostgreSQL EXPLAIN glossary

栏目: IT技术 · 发布时间: 5年前

内容简介：This tells us that Postgres would do aWe have documented many of the operations and field definitions you’re likely to come across while using EXPLAIN, along with performance advice and links to further learning resources.For advice in the context of your

↵ Back to pgMustard documentation

EXPLAIN

EXPLAIN is the command used to request the execution plan for a query. It is incredibly useful when you want to explore what is going on, and see if there could be a more efficient way.

PostgreSQL does an amazing job populating query plans with useful information, but reading and understanding them can be tricky.

Here is a simple example:

Query
----------
explain select * from t order by c;

Query plan
----------
 Sort  (cost=813.32..837.48 rows=9664 width=32)
   Sort Key: c
   ->  Seq Scan on t  (cost=0.00..173.64 rows=9664 width=32)

This tells us that Postgres would do a sequential scan of our table “t”, then a sort by column “c”. The numbers tell us the startup cost , the total cost , the plan rows , and the plan width at each stage.

We have documented many of the operations and field definitions you’re likely to come across while using EXPLAIN, along with performance advice and links to further learning resources.

For advice in the context of your query plans, check out our product pgMustard .

Main scan operations

Main join operations

All operations

EXPLAIN parameters

Official docs

复盘是围棋中的一种学习方法，指的是在写完一盘棋之后，要重新摆一遍，看看哪里下得好，哪里下得不好，对下得好和不好的，都要进行分析和推演。柳传志第一个将复盘引入到做事之中，成为联想三大方法论之一，在联想每一个重大决策的背后，都有复盘的身影。本书完整系统讲述了复盘的内容，清晰了复盘的价值，给出了复盘的操作步骤，我们可以在自己的工作生活中，应用复盘的方法，向自己学习，随时随地的提高自己，把......一起来看看《复盘》这本书的介绍吧!

码农工具