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.

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 4.67 out of 5)
Loading...

Leave a Reply