On 3 Oct 2006, at 16:04, Merlin Moncure wrote:
On 10/3/06, Carlo Stonebanks <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
