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