Show query time in postgres terminal

In psql, run:

\timing

Now when you execute queries, you should be able to see the time it took the query to execute.

To turn this on by default put the same line in your ~/.psqlrc file (or equivalent).