Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.Sign up
Large amount of active connections on Wings GCP sql DB that degrade overall performance #2254
What challenge are you facing?
Running the following query on Wings db shows there is a large amount of active connections (about 158 out of 196)
All of them are used for a kind of query that is for getting versioned resource, for example
Running above query manually shows it take about 10 sec on wings db. Using postgres analyze matches the result
When this happens on Wings, since there is no available connection for fetching new resource version, the resource checking will fail and causes builds being in pending state much longer.
A Modest Proposal
Concourse version: v3.13.1-rc.38
The commit with the migration that cause the issue is found:
This is coming from
This query is hitting a lot of rows for something called so often, and this approach may only get worse with concourse/rfcs#1. Can we reduce it to a simple join by tracking