Hello! 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? Thanks! Eudald
