timer

The .timer command toggles the display of the time taken to execute each query in rsql. This is useful for performance monitoring, query optimization, and benchmarking different SQL statements or data sources.

Usage

.timer <on|off>

When to use

  • Enable .timer on to see how long each query takes—helpful for tuning queries or comparing database performance.
  • Disable .timer off for a cleaner output if you do not need timing information.

Examples

Show the current timer setting:

.timer

Turn on the timer:

.timer on

Turn off the timer:

.timer off

Troubleshooting

  • If you do not see timing information, ensure .timer on is set.
  • For minimal output, use .timer off in combination with .header off, .footer off, and .rows off.

Demonstration