Api overview is taking too much time

[ernaneluis]

I have connected a number with more than 5k contacts, using postgresql for session storage and Store enabled in my session. When the Dashboard tries to call endpoint /api/test2/chats/overview?limit=20 it get error 504 for timeout, taking more than 1.5 min to run it. Even though I am using limit=20

ENGINE is GOWS

Error in container logs:

 {
    "level": 40,
    "time": 1743019304616,
    "pid": 1,
    "hostname": "bb5fef1219e0",
    "session": "test2",
    "name": "WhatsappSession",
    "err": {
        "type": "Error",
        "message": "2 UNKNOWN: info query timed out",
        "stack": "Error: 2 UNKNOWN: info query timed out\n at callErrorFromStatus (/app/node_modules/@grpc/grpc-js/build/src/call.js:31:19)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client.js:193:76)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:360:141)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:323:181)\n at /app/node_modules/@grpc/grpc-js/build/src/resolving-call.js:129:78\n at process.processTicksAndRejections (node:internal/process/task_queues:85:11)\nfor call at\n at MessageServiceClient.makeUnaryRequest (/app/node_modules/@grpc/grpc-js/build/src/client.js:161:32)\n at MessageServiceClient.GetProfilePicture (/app/node_modules/@grpc/grpc-js/build/src/make-client.js:105:19)\n at MessageServiceClient.GetProfilePicture (/app/dist/core/engines/gows/grpc/gows.js:6818:30)\n at node:internal/util:435:21\n at new Promise (<anonymous>)\n at node:internal/util:421:12\n at WhatsappSessionGoWSPlus.fetchContactProfilePicture (/app/dist/core/engines/gows/session.gows.core.js:230:84)\n at WhatsappSessionGoWSPlus.refreshProfilePicture (/app/dist/core/abc/session.abc.js:290:23)\n at WhatsappSessionGoWSPlus.getContactProfilePicture (/app/dist/core/abc/session.abc.js:280:24)\n at WhatsappSessionGoWSPlus.fetchChatSummary (/app/dist/core/engines/gows/session.gows.core.js:904:36)\n at WhatsappSessionGoWSPlus.getChatsOverview (/app/dist/core/engines/gows/session.gows.core.js:896:32)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)",
        "code": 2,
        "details": "info query timed out",
        "metadata": {
            "content-type": [
                "application/grpc"
            ]
        }
    },
    "msg": "Error: 2 UNKNOWN: info query timed out\n at callErrorFromStatus (/app/node_modules/@grpc/grpc-js/build/src/call.js:31:19)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client.js:193:76)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:360:141)\n at Object.onReceiveStatus (/app/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:323:181)\n at /app/node_modules/@grpc/grpc-js/build/src/resolving-call.js:129:78\n at process.processTicksAndRejections (node:internal/process/task_queues:85:11)\nfor call at\n at MessageServiceClient.makeUnaryRequest (/app/node_modules/@grpc/grpc-js/build/src/client.js:161:32)\n at MessageServiceClient.GetProfilePicture (/app/node_modules/@grpc/grpc-js/build/src/make-client.js:105:19)\n at MessageServiceClient.GetProfilePicture (/app/dist/core/engines/gows/grpc/gows.js:6818:30)\n at node:internal/util:435:21\n at new Promise (<anonymous>)\n at node:internal/util:421:12\n at WhatsappSessionGoWSPlus.fetchContactProfilePicture (/app/dist/core/engines/gows/session.gows.core.js:230:84)\n at WhatsappSessionGoWSPlus.refreshProfilePicture (/app/dist/core/abc/session.abc.js:290:23)\n at WhatsappSessionGoWSPlus.getContactProfilePicture (/app/dist/core/abc/session.abc.js:280:24)\n at WhatsappSessionGoWSPlus.fetchChatSummary (/app/dist/core/engines/gows/session.gows.core.js:904:36)\n at WhatsappSessionGoWSPlus.getChatsOverview (/app/dist/core/engines/gows/session.gows.core.js:896:32)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)"
}

[ernaneluis]

Max connection is set to 3000

[devlikepro]

Hi! Do you use 2025.3.1 version, right? I remember we added few fixes for GOWS chat overview there, but looks didn't cover all cases 🤔

created issue for that #881

[ernaneluis]

yes I am using latest version, and also tried in NOWEB version, and got same problem with the overview api connecting to the same number.

Any tips How I could speed up on my end? maybe some SQL query? @devlikepro thanks for your support!

[devlikepro]

no, likely some missed pictures for the profile, will double check it!

[devlikepro]

Hi! Could you try 2025.3.3 version? 🤞