Profiling in MC
Navin_C
Vertica Customer ✭
Hello All,
I can see, there is something strange with MC new feature....
The explain tab.
When I put my query in the box and run Explain, it gives the explain plan perfectly and in understandable manner, but when I want to profile query, I hit profile query and it is same as explain plan,
Isn't the profile option same as profile option in database ( memory required for the complete query )
Where can I see the total memory required by the query using MC profile option.
Thanks
I can see, there is something strange with MC new feature....
The explain tab.
When I put my query in the box and run Explain, it gives the explain plan perfectly and in understandable manner, but when I want to profile query, I hit profile query and it is same as explain plan,
Isn't the profile option same as profile option in database ( memory required for the complete query )
Where can I see the total memory required by the query using MC profile option.
Thanks
0
Comments
rpm -qa | grep vertica
I am using MC 7.0 with Vertica 7.0.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Profiling/MonitoringProfilingProgress.htm?Highlight=profiling
Currently the MC's explain tab will not show you (neither Explain nor Profile button) the total memory required by the query.
It is, however, possible to view the total memory consumed by the query that has completed or currently running(up to the completed memory reservation) in the Query monitoring page.
If you have any specific questions, please let us know.
-Bo Hyun