Profiling in MC

Navin_C

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

Raul_1

What version of the MC are you running -
rpm -qa | grep vertica

Navin_C

Raul,

I am using MC 7.0 with Vertica 7.0.

Raul_1

The following about the 7.1 release could be helpful -
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Profiling/MonitoringProfilingProgress.htm?Highlight=profiling

bohyun

Hi Navin,

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