topic Re: kv_transient_batchmanagercache table update query is taking too much time in Nuxeo in Nuxeo Forum

kv_transient_batchmanagercache table update query is taking too much time in Nuxeo

Ankush_Bandil — Wed, 20 Jan 2021 15:46:02 GMT

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

Re: kv_transient_batchmanagercache table update query is taking too much time in Nuxeo

Florent_Guillau — Wed, 20 Jan 2021 16:18:04 GMT

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.

Re: kv_transient_batchmanagercache table update query is taking too much time in Nuxeo

Ankush_Bandil — Wed, 20 Jan 2021 20:55:42 GMT

[Florent Guillaume](https