Re: The query plan get all columns but I'm using only one column.

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: The query plan get all columns but I'm using only one column.
Дата
Msg-id CAHOFxGoem0SAFg54e7njOjfjZWDON03iQcwE6f3Npfmt2HgLqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The query plan get all columns but I'm using only one column.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: The query plan get all columns but I'm using only one column.
Список pgsql-performance
Дерево обсуждения
The example is nonsensical so I expect it is too contrived to be useful for analyzing the actual problem.

Additionally, the total query time is under 1ms and most of it is planning time. Use a prepared statement or do something else to reduce planning time like reducing statistics target if that actually makes sense for your use case.

Else, show us something much closer to the real problem.

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

Предыдущее
От: Arcadio Ortega Reinoso
Дата:
Сообщение: Re: PostgreSQL does not choose my indexes well
Следующее
От: Jean-Christophe Boggio
Дата:
Сообщение: Recursive query slow on strange conditions