Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Show time after execution in isql [CORE2681] #3084

Closed
firebird-automations opened this issue Oct 14, 2009 · 4 comments
Closed

Show time after execution in isql [CORE2681] #3084

firebird-automations opened this issue Oct 14, 2009 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Ivan (patuljak)

Show time after execution in isql for during query.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

What time do you need to show ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Claudio Valderrama C. (robocop)

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: Claudio Valderrama C. (robocop)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant