Re: Performance issues in query with multiple joins

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Παρασκευη Πασσαρη <passari(dot)paraskevi(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance issues in query with multiple joins
Date: 2023-05-01 04:15:56
Message-ID: f92bcd70863ee54fa3c85b7ddad7caa844899cb6.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2023-04-28 at 15:19 +0300, Παρασκευη Πασσαρη wrote:
> We are facing a performance issue with the following query. Executing this query takes about 20 seconds.
> (the database version is 14.1)

The execution plan seems to be incomplete.

Yours,
Laurenz Albe

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ProfiVPS Support 2023-05-04 17:31:45 Fsync IO issue
Previous Message Tom Lane 2023-04-28 14:07:47 Re: Performance issues in query with multiple joins