\timing

This meta-command reports, in milliseconds, the length of time each SQL statement runs. The results include:

• the length of time required to fetch the first block of rows
• the total time until the last block is formatted

For example:

=> SELECT * from allsales;
state | name | sales
---------------------
NY    | B    |    20
NY    | C    |    15
MA    | A    |    40
(3 rows)

Time: First fetch (7 rows): 59.264 ms. All rows formatted: 59.362 ms

Timing is off by default. To determine the state of the timing function, enter the following:

=> \timing
Timing is on

This example indicates that timing is off.

Toggle \timing function

You can set the timing state by entering on or off:

=> \timing on
Timing is on

=> \timing off
Timing is off

Alternatively, enter the function name without an argument to automatically toggle the state, whether it's on or off. For example, if you run \timing on, running \timing disables timing:

=> \timing on
Timing is on


=> \timing
Timing is off

Enable \timing from the vsql Command Line

You can enable \timing from the command line using the vsql -i command. You can only use -i with the -c (command) and -f (filename) commands. For more information see Command-Line Options.

From the command line enter the -i option before running a session to turn timing on. For example:

$VSQL -h host1 -U user1 -d VMart -p 15 -w ****** -i -f transactions.sql

$VSQL-h host1 -U user1 -d VMart -p 15 -w ****** -i -c "SELECT user_name, 
ssl_state, authentication_method, client_authentication_name, client_type FROM sessions 
WHERE session_id=(SELECT session_id FROM current_session);"

Example

The following example shows a SQL command with timing 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): 44.388 ms. All rows formatted: 40.502 ms

The following table provides a quick guide on what occurs when you run \timing commands starting with the \timing being on:

=> \timing on

=> \timing 

=> \timing off