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