proxy=# \d detail
                  Table "public.detail"
  Column   |            Type             |   Modifiers
-----------+-----------------------------+---------------
 time      | timestamp without time zone | default now()
 bytesin   | integer                     |
 bytesout  | integer                     |
 username  | character varying( 255 )      |
 source_ip | character( 16 )               |
 dest_ip   | character( 16 )               |
 dest_p    | integer                     |
 host      | character varying( 255 )      |
Indexes:
    "idx_detail_time" btree ("time")
    "idx_detail_usertime" btree ("time", username)
Triggers:
    day_stat_insert AFTER INSERT ON detail FOR EACH ROW EXECUTE PROCEDURE inser_day_stat()

proxy=# SELECT SUM(bytesin+bytesout), username FROM detail WHERE username='Satana' AND time > to_date('2007-08-06', 'yyyy-mm-dd') AND time < to_
date('2007-08-06', 'yyyy-mm-dd') + interval '1 day' GROUP by username;

                                                                                                QUERY PLAN

----------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------
 HashAggregate  (cost= 8 . 83 .. 8 . 86  rows= 2  width= 17 ) (actual time= 1 . 807 .. 1 . 808  rows= 1  loops= 1 )
   ->  Seq Scan on detail  (cost= 0 . 00 .. 8 . 13  rows= 141  width= 17 ) (actual time= 0 . 048 .. 1 . 488  rows= 207  loops= 1 )
         Filter: (((username)::text = 'Satana'::text) AND ("time" > to_date('2007-08-06'::text, 'yyyy-mm-dd'::text)) AND ("time" < (to_date('2007-08-06'::text,
'yyyy-mm-dd'::text) + '1 day'::interval)))
 Total runtime:  1 . 962  ms
( 4  rows)