If you want to see how long a query is taking to run, you can either run explain analyze or enable timing for the client by typing \timing.