Postgres Pro
Downloads
Home   >   mailing lists

Re: Query going to all paritions - Mailing list pgsql-performance

From aditya desai
Subject Re: Query going to all paritions
Date
Msg-id CAN0SRDEADFCN9k=5MsJAYn8yqqGAJwAqeK2h1Mx=yJw24C5hHg@mail.gmail.com
Whole thread Raw
In response to Re: Query going to all paritions  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Query going to all paritions
Next
From: Jeff Holt
Date:
Subject: Better, consistent instrumentation for postgreSQL using a similar API as Oracle