SELECT to_char(LAW.data, 'DD/MM/YYYY HH24:MI:SS') as data_hora, LAW.ip_terminal, LAW.bytes, LAW.status, LAW.url, U.nome AS full_name FROM (SELECT * FROM log_acesso_web WHERE date_trunc('day', data) = '2012-03-20') as LAW LEFT OUTER JOIN logs.usuario U ON U.id = LAW.fk_logs_usuario_idCREATE TABLE log_acesso_web( id serial NOT NULL, ip_terminal inet NOT NULL, data timestamp without time zone NOT NULL DEFAULT now(), status character varying(100) NOT NULL, url text NOT NULL, tipo character varying(100) NOT NULL, bytes integer NOT NULL, tempo integer NOT NULL DEFAULT 0, fk_logs_usuario_id integer, CONSTRAINT log_acesso_web_pkey PRIMARY KEY (id ), CONSTRAINT log_acesso_web_fk_logs_usuario_id_fkey FOREIGN KEY (fk_logs_usuario_id) REFERENCES logs.usuario (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION)CREATE INDEX log_acesso_web_day_idx ON log_acesso_web USING btree (date_trunc('day'::text, data) );CREATE INDEX log_acesso_web_data_idx ON log_acesso_web USING btree (data );