We are running some tests in Google Cloud and we are using CloudSQL Postgres 12 with cloudsqlproxy and pgbouncer.
[x ] bug report Describe the issue When we run tests in Google cloud using K8s and CloudSQL Postgres 12 with cloudsql authproxy and pgbouncer we are observing lot of Network I/O while executing queries.
Driver Version? 42.5.0 DT method hotspots DT Network IO Java Version? 11
OS Version? Centos
PostgreSQL Version? 12
To Reproduce Steps to reproduce the behaviour: Happening almost all the time when using both pgbouncer and Postgres. Didn't observe earlier when directly using Postgres.
Logs There are no error logs it's just that queries are taking lot of time to execute. Even queries as simple as which get by primary key are just hung up on SocketRead.
Any ideas will be really helpful. Let me know if more information need to be shared. What could be possible reasons of so much of network I/O? And it only seem to be an issue when working with pgbouncer.
We looked into pgbouncer logs and found nothing concrete there. There isn't any waiting showing up in the logs. We played around with configuration in pgbouncer.ini as well but nothing worked. If anyone has faced similar issue then share if anything worked.
