Resource Usage on Vertica
Posted: Fri May 24, 2013 7:09 pm
When I look at the resource usage for my query I see that the thread count is 37. Why is my query using so many threads?
37 threads really isn't that many for a query running in vertica. The number of threads will depend on the number of cores and the number of operators in the query plan. For larger tables, the scan operator that reads data from disk will fan out across all cores. Other operators will have their own threads, and do work whenever data is available to them. Some will run on multiple threads, some will run with a single thread.
--Sharon