Skip to main content

Profiling in MC

  • May 8, 2014
  • 4 replies
  • 12 views

Navin_C
Forum|alt.badge.img+2
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

4 replies

Raul_1
Forum|alt.badge.img
  • Participating Frequently
  • October 13, 2014
What version of the MC are you running -
rpm -qa | grep vertica

Navin_C
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 13, 2014
Raul,

I am using MC 7.0 with Vertica 7.0.


Raul_1
Forum|alt.badge.img
  • Participating Frequently
  • October 13, 2014

bohyun
Forum|alt.badge.img
  • Participating Frequently
  • November 12, 2014
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