On 3 Oct 2006, at 16:04, Merlin Moncure wrote:
> On 10/3/06, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> wrote:
>> Some very helpful people had asked that I post the troublesome
>> code that was
>> generated by my import program.
>>
>> I installed a SQL log feature in my import program. I have
>> posted samples of the SQL statements that cause the biggest delays.
>
> explain analyze is more helpful because it prints the times.
You can always use the \timing flag in psql ;)
l1_historical=# \timing
Timing is on.
l1_historical=# select 1;
?column?
----------
1
(1 row)
Time: 4.717 ms