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