This is useful, thanks! When running from the SSD it spends much more time in 'sleeping' than 'running' compared to the local disk. And the CPU usage is way less (>50%) when running from SSD. Usually I multithread these things, but single-threading doesn't seem to make much difference. I think the bottleneck is reading in the database to memory / cache the first instance, which I think is single-thread only on BLAST and for this particular job takes the biggest proportion of overall runtime.
I guess I'll just have to plead with my PI for a hardware upgrade...
Is it a USB-C drive?
How much memory do you have available? Any
nt*databases are going to need several tens of GB of memory. Perhaps that is your real issue.