Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Request distribution among cluster nodes
how to get Request distribution among cluster nodes in vertica?
thanks in advance
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Hi,
I am not sure what do you mean with distribuition but the table projection_storage can tell you how many rows an used bytes you have per node per projection. Maybe this is what you are looking for ?
HTH,
Eugenia
Thanks for replying. My question is like i want to know the work load distribution across the nodes when i pass some select query. If i am passing 'select xyz from abc where some_condition' , i want know, in each node how the load distributed among
Hi Rajzz,
Management Console will show you your workload distribution across your nodes in various areas.
For aggregated resource information (from all your running queries), you can go to the Query Monitoring page:
Management Console will also easily aggregate node information for you when profiling a query:
It works.
Thanks eugenia and chris