\timing
If set to on, returns how long (in milliseconds) each SQL statement runs. Results include:
- Length of time required to fetch the first block of rows
- Total time until the last block is formatted.
Unqualified, \timing
toggles timing on and off. You can explicitly turn timing on and off by qualifying the command with options ON
and OFF
, respectively.
You can also enable \timing
from the command line using the vsql -i
command.
Syntax
\timing [ON | OFF]
Examples
The following unqualified \timing
commands toggle timing on and off:
=> \timing Timing is on => \timing Timing is off
The following example shows a SQL command with timing on:
=> \timing Timing is on. => SELECT user_name, ssl_state, authentication_method, client_authentication_name, client_type FROM sessions WHERE session_id=(SELECT session_id FROM current_session); user_name | ssl_state | authentication_method | client_authentication_name | client_type -----------+-----------+-----------------------+----------------------------+------------- dbadmin | None | ImpTrust | default: Implicit Trust | vsql (1 row) Time: First fetch (1 row): 73.684 ms. All rows formatted: 73.770 ms