This topic was automatically generated from Slack. You can find the original thread here.
It seems Pipedream leaves the connection to postgres open after running a workflow, which is leading to my postgres instance reaching max connections and blocking any and all queries that come in. Basically rendering my application unusable. What do I need to do to make Pipedream close the connection? This seems to be happening since January 30 6PM UTC. See screenshot with open connections. I have confirmed that a new one gets added at 15 past the hour every hour, which is when I have a scheduled workflow running on pipedream.
Execute SQL Query (see attached). There are 3 of those in that workflow. Thing is I didn’t change that workflow over the past week and it was running every hour of every day and suddenly what you see in the graph started happening.