Is it a parallel query? If yes the total time is only the time spent in the
main process, and the IO time is sum of all IO time spent in main process and
the parallel workers, which can obviously be a lot more than the total
execution time.
Yes, there are parallel workers, that explains it. Thank you.
Regards,
Jay