I would like to benchmark some SQL-queries agains my PostgreSQL database. Is there any way I can time SQL-queries using psql
?
PostgreSQL – How to Time SQL Queries Using psql
benchmarkpostgresqlpsql
Related Question
- PostgreSQL Benchmarking – How to Benchmark a PostgreSQL Query
- Postgresql – How to generate TPC-DS queries for PostgreSQL
- PostgreSQL Performance – How to Time SQL Queries Using psql
- Postgresql – Running queries one after the other in psql/scripting environment
- PostgreSQL Logging – How to Log psql Time and Statements to a Text File
- PostgreSQL – How to Disable Parallel Queries
Best Answer
Just turn on timing by entering:
\timing