I have been doing a lot of PostgreSQL work recently using the psql command line programme as a rapid iteration experimentation process, most of my experience is with MySQL. One feature I miss from mysql command is that it would tell you how long it too to execute a query after that query has returned.

You can turn this on in psql by entering this command:

\timing

psql will then show you the time (in milliseconds) that each query/command took.