Re: Issue executing query from container - Mailing list pgsql-general

From Tom Lane
Subject Re: Issue executing query from container
Date
Msg-id 2961873.1594763498@sss.pgh.pa.us
Whole thread Raw
In response to Issue executing query from container  (Eudald Valcàrcel Lacasa <eudald.valcarcel@gmail.com>)
Responses Re: Issue executing query from container
List pgsql-general
=?UTF-8?Q?Eudald_Valc=C3=A0rcel_Lacasa?= <eudald.valcarcel@gmail.com> writes:
> I'm running a docker container that executes a php script running a
> sequence of queries.
> One of the queries gets stuck (takes more than 2 hours in execution,
> active in pg_stat_activity).
> The query is executed with a JOIN between a FOREIGN TABLE and a local table.

> Executing this query from the psql console takes less than 5 seconds to resolve.
> If I execute the query from the container created, manually, it
> resolves as well within 5 seconds.

> Can anyone guide me in a way I can troubleshoot what is causing the
> query to get stuck?

It's a very good bet that it's something about the query being
parameterized or not.  You could try installing auto_explain to
compare the plans that are generated.

            regards, tom lane



pgsql-general by date:

Previous
From: Eudald Valcàrcel Lacasa
Date:
Subject: Issue executing query from container
Next
From: Tom Lane
Date:
Subject: Re: single table - fighting a seq scan