Thanks for the confirmation about this.
Good news: as IO is the bottleneck and most of the data are not required real time, I increased refresh_interval from default (1s) to 10s. This makes the different type of queries performance max from 20s+ to 4s.