Re: Query going to all paritions

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: aditya desai <admad123(at)gmail(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 10:33:25
Message-ID: 20211001103325.GA22890@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ?!

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message aditya desai 2021-10-01 11:33:12 Re: Query going to all paritions
Previous Message aditya desai 2021-10-01 08:54:11 Re: Query going to all paritions