Search code examples
sqlmonetdb

how to get the complete time when I run a sql script using monetdb

when I use the command-line interface of sql after I type "mclient -dmydatabase", if I type the "select...." instruction directly, I will get the complete time like this

(query result)

7 tuples (15.4s)

but if I put the same instruction into the sql script like default_22.sql, after I run the script I will only get the answer without the time like this:

(query result)

7 tuples

so I hope to know that how can I get the complete time when I run the script using the monetdb? thank you.

Solution

  • You could use the -i flag e.g.

    mclient -dmydatabase -i scriptfile