Date: Fri, 1 Oct 2021 12:33:25 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: aditya desai <admad123@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
	Pgsql Performance <pgsql-performance@lists.postgresql.org>
Subject: Re: Query going to all paritions
Message-ID: <20211001103325.GA22890@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CAN0SRDFTummB0w5L_ijZq+ufZx8s6+Wdm96SEwqkQZYeUjpf=w@mail.gmail.com>
 <9b0fc158ae0701e0e3cbd03d7f022735dc4e3f24.camel@cybertec.at>
 <CAN0SRDF3vkvOj6i8pApOWMj3EE=EgcmBdX8vXPkOQ4ZgSoynqw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAN0SRDF3vkvOj6i8pApOWMj3EE=EgcmBdX8vXPkOQ4ZgSoynqw@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20211001103325.GA22890%40depesz.com>
Precedence: bulk

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