Re: slow query - Mailing list pgsql-performance

From Christophe Pettus
Subject Re: slow query
Date
Msg-id 670FEF41-1843-43A8-B16E-3579685C0A6C@thebuild.com
Whole thread Raw
In response to slow query  (Ayub Khan <ayub.hp@gmail.com>)
List pgsql-performance

> On Jun 8, 2021, at 09:03, Ayub Khan <ayub.hp@gmail.com> wrote:
> I checked all the indexes are defined on the tables however the query seems slow, below is the plan.

It's currently running in slightly under six milliseconds.  That seems reasonably fast given the number of operations
requiredto fulfill it. 


pgsql-performance by date:

Previous
From: Ayub Khan
Date:
Subject: slow query
Next
From: Ayub Khan
Date:
Subject: Re: slow query