HowTo Show time after execution in isql after a query
Claudio answered to a “new feature” request
This command exists in all Firebird versions:
SQL> set stats on;
SQL> select 1 from rdb$database;
CONSTANT
============
1
Current memory = 10135512
Delta memory = 164708
Max memory = 10263380
Elapsed time= 0.11 sec
Buffers = 2048
Reads = 12
Writes 0
Fetches = 157
SQL>
Elapsed time is the time the query needed to complete. Run it a second time and the elapsed time is only 0.02 seconds because metadata is already loaded.