=?UTF-8?Q?Eudald_Valc=C3=A0rcel_Lacasa?= <eudald.valcarcel@xxxxxxxxx> 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
