hello ,
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

Dear Anshul,

Op 15-03-10 05:42, anshul gangwar schreef:
> We want to debug the monetdb server , in other words we want final
> execution plan and query execution times etc.

Then most likely you will love the stethoscope tool! It gives an awesome
view in the MonetDB kernel *and* it provides you realtime information
about the queries that have been executed. That is not all, you can just
start and stop it without(!) restarting the server, while still making
nifty graphs from this program.

I think this is totally what you need.

There is a lot documentation written for this tool, so you don't have to
be a rocket scientist to use it :)

<http://monetdb.cwi.nl/MonetDB/Documentation/Stethoscope.html>

The last line on the page will give you an example commandline. If you
did not yet change your default monetdb password you can use this one:

stethoscope -umonetdb -Pmonetdb +tis algebra.* bat.* group.* sql.* aggr.*

Please report back how useful this was for your debuging and use of
MonetDB. We appreciate your interest.

Yours Sincerely,

Stefan de Konink
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkudwdMACgkQYH1+F2Rqwn0+AwCfTg5FruAc6QDgOIT4ZJZ4bOWB
hTAAnjkWylxX7JafSLI21qZFE6BMydoO
=8rz4
-----END PGP SIGNATURE-----