PostgreSQL Cheat Sheet/Toggle query timing

Show execution time after each statement.

Section: Connect and Inspect with psql

Toggle query timing

sql
sql
\timing on
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Connect and Inspect with psql
Connect to a database
Open an interactive psql session to a database.
OpenIn sheetbashsame section
Connect with URI
Connect using a full PostgreSQL connection string.
OpenIn sheetbashsame section
List databases
Show all databases in the cluster.
OpenIn sheetsqlsame section
List roles
Show roles and memberships.
OpenIn sheetsqlsame section
List schemas
Show schemas in the current database.
OpenIn sheetsqlsame section
List tables views and sequences
List relations across schemas.
OpenIn sheetsqlsame section