On Wed, Feb 07, 2007 at 09:00:32AM -0800, Andrew Edson wrote:
> What is the command I should be looking for to measure the
> runtime on my statements?
In psql, use \timing.
In your postgresql.conf file, you can set
log_min_duration_statement=0.
You can also use EXPLAIN ANALYSE to see the full execution plan, plus
information about how long each step _actually_ takes.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz