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@xxxxxxxxxxxxxxx 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
