kv_transient_batchmanagercache table update query is taking too much time in Nuxeo

[Ankush_Bandil]

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

[Florent_Guillau]

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.

[Ankush_Bandil]

[Florent Guillaume](https