Hi all,
MonetDB version: 11.23.7
Ubuntu version: 14.04
How could I obtain the running time information in the MAL interface of mclient? I tried to use the *--interactive* option but it did not work.
Specifically, I do the following:
===============================================
$ mclient -dnba2009 -lmsql --interactive=ms
Welcome to mclient, the MonetDB interactive terminal (Jun2016-SP1)
Type \q to quit, \? for a list of available commands
msql>\<query.txt // I save the MAL instructions of a query (obtained from EXPLAIN statement) in this file
msql>user.s1_3("1998"); // call the function of that query
% sys.player, sys.player, sys.player # table_name
% p_lastname, p_lastseason, p_weight # name
% char, int, int # type
% 100, 4, 3 # length
[ "Wheeler", 1998, 165 ]
[ "Baker", 1998, 175 ]
[ "Garnett", 1998, 186 ]
......
========================================================
I would like to obtain the running time information after getting the result of that query. How can I do it?
Any help would be appreciated.
Best,
Wenjian