Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE
Дата
Msg-id CAMkU=1ye8VMnyVjHND4DnsS0J+Nyjumg4HYGiK-TrB6XUtww=A@mail.gmail.com
обсуждение исходный текст
Ответ на Questions about "Output" in EXPLAIN ANALYZE VERBOSE  (Jerry Brenner <jbrenner@guidewire.com>)
Ответы Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, Jan 2, 2024 at 1:29 PM Jerry Brenner <jbrenner@guidewire.com> wrote:
We are currently on 13.9. 

Why not just use the latest minor release, 13.13?  For security reasons, that is the only minor release of v13 you should be using anyway.  I think it is a bit much to hope that people will spend their time for free researching obsolete minor releases.


Any node type accessing an index or table
  • It looks like "Output" includes more than just the columns with predicates and/or being accessed or returned in other nodes.
Not in my hands. For SELECTs it just lists the columns that are needed.  Your example is hard to follow because it appears to be just snippets of a plan, with no example of the query to which it belongs.

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jerry Brenner
Дата:
Сообщение: Questions about "Output" in EXPLAIN ANALYZE VERBOSE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE