How do you know how long a query took?
PostgreSQL lets you time the queries and print the output in your psql session.
Create a $HOME/.psqlrc file with:
in it and next time you log in to a psql session, PostgreSQL will show you how long the query took!
Doing it this way means ...