Search code examples
monetdb

Show runtime of a query on monetdb

I am testing monetdb for a colunmnar storage.

I already installed and run the server but, when I connect to the client and run a query, the response does not show the time to execute the query. I am connecting as:

mclient -u monetdb -d voc

I already tried to connect with interactive like:

mclient -u monetdb -d voc -i

Output example:

sql>select count(*) from voc.regions;
+---------+
| L3      |
+=========+
| 5570699 |
+---------+
1 tuple
Solution

  • If you use the latest version MonetDB-Mar18 you have good control over the performance timers, which includes parsing, optimization, and runtime at server. See mclient --help.