Thursday, November 4, 2010

turn on query timing in postgres

11. How to turn on timing, and checking how much time a query takes to execute ?

# \timing — After this if you execute a query it will show how much time it took for doing it.
# \timingTiming is on.

# SELECT * from pg_catalog.pg_attribute ;
Time: 9.583 ms
 
 
more stuff on: http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/ 

1 comment: