=?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