Slow connection speed between cube and superset

[piyushunicommerce]

We are currently running cube in a docker container on an aws ec2 instance with centos os. Superset is running in another instance in a docker container.

We are facing significantly low speed when running query from superset to a cube table thorugh sql api. Superset is performing relatively very fast when connected to other self managed postgres instances.

Cube docker compose file

version: '2.2'

services:
cube_api:
restart: always
image: cubejs/cube:latest
ports:
- 4000:4000
- 5432:5432
environment:
- CUBEJS_DB_HOST=postgres-abc.infra
- CUBEJS_DB_PORT=5432
- CUBEJS_DB_NAME=db
- CUBEJS_DB_USER=XXXXXX
- CUBEJS_DB_PASS=XXXXX
- CUBEJS_DB_TYPE=postgres
- CUBEJS_DB_SCHEMA=public
- CUBEJS_CUBESTORE_HOST=cubestore_router
- CUBEJS_DEV_MODE=true
- CUBEJS_REFRESH_WORKER=true
- CUBEJS_PG_SQL_PORT=5432
- CUBEJS_SQL_PASSWORD=XXXXXX
- CUBEJS_SQL_USER=XXXXXX
- CUBEJS_DB_QUERY_TIMEOUT=40m
- CUBEJS_PRE_AGGREGATIONS_SCHEMA=prod_pre_aggregations
- CUBEJS_ROLLUP_ONLY=false
- CUBEJS_DEFAULT_API_SCOPES=meta,data,graphql,jobs
- CUBEJS_LOG_LEVEL=trace
- CUBESQL_REWRITE_MAX_NODES=30000
- CUBESQL_AUTH_EXPIRE_SECS=3000
volumes:
- .:/cube/conf
depends_on:
- cubestore_worker_1
- cubestore_worker_2
- cube_refresh_worker
- cubestore_router

cube_refresh_worker:
restart: always
image: cubejs/cube:latest
environment:
- CUBEJS_DB_HOST=postgres-abc.infra
- CUBEJS_DB_PORT=5432
- CUBEJS_DB_NAME=db
- CUBEJS_DB_USER=XXXXXX
- CUBEJS_DB_PASS=XXXXX
- CUBEJS_DB_TYPE=postgres
- CUBEJS_DB_SCHEMA=public
- CUBEJS_CUBESTORE_HOST=cubestore_router
- CUBEJS_DEV_MODE=true
- CUBEJS_REFRESH_WORKER=true
- CUBEJS_PG_SQL_PORT=5432
- CUBEJS_SQL_PASSWORD=XXXXXX
- CUBEJS_SQL_USER=XXXXXX
- CUBEJS_DB_QUERY_TIMEOUT=40m
- CUBEJS_PRE_AGGREGATIONS_SCHEMA=prod_pre_aggregations
- CUBEJS_ROLLUP_ONLY=false
- CUBEJS_DEFAULT_API_SCOPES=meta,data,graphql,jobs
- CUBEJS_LOG_LEVEL=trace
- CUBESQL_REWRITE_MAX_NODES=30000
- CUBESQL_AUTH_EXPIRE_SECS=3000
volumes:
- .:/cube/conf