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
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