Re: slow query

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Ayub Khan <ayub(dot)hp(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: slow query
Date: 2021-06-08 16:08:15
Message-ID: 670FEF41-1843-43A8-B16E-3579685C0A6C@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> On Jun 8, 2021, at 09:03, Ayub Khan <ayub(dot)hp(at)gmail(dot)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 required to fulfill it.

In response to

  • slow query at 2021-06-08 16:03:48 from Ayub Khan

Browse pgsql-performance by date

  From Date Subject
Next Message Ayub Khan 2021-06-08 16:32:12 Re: slow query
Previous Message Ayub Khan 2021-06-08 16:03:48 slow query