On Wed, Mar 17, 2010 at 08:26:59AM +0100, Fabian Groffen wrote:

On 17-03-2010 10:22:33 +0530, anshul gangwar wrote:

...

Yes we are on monetdb/xquery

Then maybe someone else knows how to get the plan, but I don't know.

I (tried to) explain the closed you can get to the final get to see the final query execution plan for MonetDB/XQuery in my answers to your earlier questions: " Except from choosing algorithms and implementations based on the properties of operators' actual input(s) at runtime, the physical algebra plan (MIL program) is executed as is. Choosing the algorothms and implementations is done inside the operators' implementations (see e.g., the code in MonetDB/src/gdk/relop.(mx|c)), and can only be traced by single-stepping the execution in a debugger or by enabling debugging output via the Mserver commandline option --debug=2097152 (see MonetDB4/conf/MonetDB.conf[.in] or <prefix>/etc/MonetDB.conf for all available debug options.) " (see also https://sourceforge.net/mailarchive/forum.php?thread_name=20100308154105.GA11047%40cwi.nl&forum_name=monetdb-developers https://sourceforge.net/mailarchive/forum.php?thread_name=20100311093535.GA14067%40cwi.nl&forum_name=monetdb-developers ) Unfortunately, there is not (more convenient) way to "visualize" the final query execution plan for MonetDB/XQuery. Hope this helps you further. Stefan

...

On 15-03-2010 18:53:26 +0530, anshul gangwar wrote:

...

actually we are working on java based tool whose main focus is to visualize the plans used by the optimizer for final execution of query but in monetdb optimization is runtime so we have to somehow access that plan through jdbc and what are the maincomponents of the plan i.e can be represented as node in tree

We are not able to use that , actually that is giving error

MAPI = monetdb@localhost:50000 ACTION= mapi_start_talking ERROR = !xchange_challenge: frontend mal not found

So you're on MonetDB/XQuery?

------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |