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 st

[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=(selec