Message-ID: <f92bcd70863ee54fa3c85b7ddad7caa844899cb6.camel@cybertec.at>
Subject: Re: Performance issues in query with multiple joins
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?UTF-8?Q?=CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85=CE=B7_?=
	=?UTF-8?Q?=CE=A0=CE=B1=CF=83=CF=83=CE=B1=CF=81=CE=B7?=
	 <passari.paraskevi@gmail.com>, pgsql-performance@lists.postgresql.org
Date: Mon, 01 May 2023 06:15:56 +0200
In-Reply-To: 
 <CAKcH_XZNmmquh2w8oGtRyT+HyrEeodayaBd1QvcgmR69i=hN0A@mail.gmail.com>
References: 
	<CAKcH_XZNmmquh2w8oGtRyT+HyrEeodayaBd1QvcgmR69i=hN0A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/f92bcd70863ee54fa3c85b7ddad7caa844899cb6.camel%40cybertec.at>
Precedence: bulk

On Fri, 2023-04-28 at 15:19 +0300, =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=
=B5=CF=85=CE=B7 =CE=A0=CE=B1=CF=83=CF=83=CE=B1=CF=81=CE=B7 wrote:
> We are facing a performance issue with the following query. Executing thi=
s query takes about 20 seconds.
> (the database version is 14.1)

The execution plan seems to be incomplete.

Yours,
Laurenz Albe