Poor performance on TrueNAS

[tarianjed]

This was the solution to my performance issues -

Identified another slow query during backup

So I just started testing out Duplicati and ran into some major issues with query performance causing major delays in my backup successfully completing. They are running on a ~300GB dataset that is a subset of the almost 40TB I will be eventually backing up. (more info here: Poor performance on TrueNAS) Luckily I am good with databases so I will be following up with some proposed solutions after this backup successfully completes. Problem queries: Runtime - 3:42:24.304 - Location LocalDatab…