[PERFORM] Help interpreting explain analyze output

2004-08-15 Thread Ole Tange
Using this SQL: EXPLAIN ANALYZE SELECT DISTINCT sessionid, '2004-33' AS yearweek, nd.niveau INTO TEMP distinct_session FROM httplog h ,niveaudir nd WHERE hitDateTime('now'::timestamp with time zone-'1440 min'::interval) and h.hostid=(select

Re: [PERFORM] Help interpreting explain analyze output

2004-08-15 Thread Ole Tange
On Sun, 15 Aug 2004, Tom Lane wrote: Ole Tange [EMAIL PROTECTED] writes: As I read it the output tells me what was done during the milliseconds: No, you have a fundamental misconception here. The notation means that the first output row from a plan step was delivered after X milliseconds