How can I time SQL-queries using psql?

Question

I would like to benchmark some SQL-queries agains my PostgreSQL database. Is there any way I can time SQL-queries using psql?

For more details on benchmarking PostgreSQL queries: dba.stackexchange.com/q/42012/9622

Caleb · Accepted Answer · 2011-06-03 10:39:23Z

up vote 22 down vote accepted

Just turn on timing by entering: \timing

answered Jun 3 '11 at 10:39

Caleb
48835

Jack Douglas · Answer 2 · 2012-02-20 21:50:22Z

Timing can be turned on with \timing at the psql prompt (as Caleb already said).

If you are on 8.4 or above, you can add an optional on/off argument to \timing, which can be helpful if you want to be able to set timing on in .psqlrc - you can then set \timing on explicitly in a script where plain \timing would otherwise toggle it off

2 Answers