kv_transient_batchmanagercache table update query is taking too much time in Nuxeo

I am using Nuxeo rest APIs to upload images and some APIs are taking too much time on less tps (tested for 4 and 6 tps). After monitoring, I found that there is an update query for kv_transient_batchmanagercache table which is taking too much time to execute. Any suggestion on how I can minimize the execution time?

API: nuxeo/api/v1/upload/ Query: UPDATE “kv_transient_batchmanagercache” SET “long” = ?, “ttl” = ? WHERE “key” = ? AND “long” = ? Database: Postgres

0 votes

0 answers

673 views

ANSWER

This is a very simple query on a table that should be mostly empty, and with an index on the key column. It shouldn't be slow at all. Please check your database metrics for the reason.
01/20/2021

Florent Guillaume is there any document available online which can describe the purpose and details of tables created by Nuxeo?
01/20/2021