From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Eudald Valcàrcel Lacasa <eudald(dot)valcarcel(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Issue executing query from container |
Date: | 2020-07-14 21:51:38 |
Message-ID: | 2961873.1594763498@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
=?UTF-8?Q?Eudald_Valc=C3=A0rcel_Lacasa?= <eudald(dot)valcarcel(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-07-14 22:06:04 | Re: single table - fighting a seq scan |
Previous Message | Eudald Valcàrcel Lacasa | 2020-07-14 20:25:07 | Issue executing query from container |