timeofday() worked perfectly.
dev-mdb=# select load_contact(1317040);
NOTICE: Start Time 2003-06-19 08:49:46.3277-07
NOTICE: Loading Contact ID 1317040
NOTICE: Timestamp 1: 2003-06-19 08:49:46.593492-07
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE: Timestamp 2: 2003-06-19 08:49:55.557404-07
...
NOTICE: Timestamp 11: 2003-06-19 08:50:33.023047-07
NOTICE: Timestamp 12: 2003-06-19 08:50:33.026157-07
load_contact
--------------------
219817
(1 row)
dev-mdb=#
Next I need to figure out why creating a person (which happens between timestamp 1 and 2) should take 10 seconds and why the complete insert takes 47 seconds.
Best,
Carl