| From: | aditya desai <admad123(at)gmail(dot)com> |
|---|---|
| To: | Hubert Lubaczewski <depesz(at)depesz(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query going to all paritions |
| Date: | 2021-10-01 11:33:12 |
| Message-ID: | CAN0SRDEADFCN9k=5MsJAYn8yqqGAJwAqeK2h1Mx=yJw24C5hHg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)depesz(dot)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 ?!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Holt | 2021-10-01 20:06:02 | Better, consistent instrumentation for postgreSQL using a similar API as Oracle |
| Previous Message | hubert depesz lubaczewski | 2021-10-01 10:33:25 | Re: Query going to all paritions |