Re: Query going to all paritions

Поиск
Список
Период
Сортировка
От aditya desai
Тема Re: Query going to all paritions
Дата
Msg-id CAN0SRDEADFCN9k=5MsJAYn8yqqGAJwAqeK2h1Mx=yJw24C5hHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query going to all paritions  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-performance
Will try to get a query in text format. It looks difficult though.

Regards,
Aditya.


On Fri, Oct 1, 2021 at 4:03 PM hubert depesz lubaczewski <depesz@depesz.com> wrote:
On Fri, Oct 01, 2021 at 02:24:11PM +0530, aditya desai wrote:
> Hi Laurenz,
> Please find attached explain query plan and query.

Can you show us \d of the table, and exact query you ran?

Also, please, don't send images. This is text, so you can copy-paste it
directly into mail.

Or, put it on some paste site - for explains, I suggest
https://explain.depesz.com/

It's impossible to select text from image. It's much harder to read (it
doesn't help that it's not even screenshot, but, what looks like,
a photo of screen ?!

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Query going to all paritions
Следующее
От: Jeff Holt
Дата:
Сообщение: Better, consistent instrumentation for postgreSQL using a similar API as Oracle