Resource Usage on Vertica

Moderator: NorbertKrupa

Post Reply
aligardezi
Newbie
Newbie
Posts: 5
Joined: Wed May 22, 2013 8:25 pm

Resource Usage on Vertica

Post by aligardezi » 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?

scutter
Master
Master
Posts: 301
Joined: Tue Aug 07, 2012 2:15 am

Re: Resource Usage on Vertica

Post by scutter » Thu May 30, 2013 2:07 am

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
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

Post Reply

Return to “Vertica Performance Tuning”