max_connections =  100 

# - Memory -

shared_buffers =  100000          # min  16 , at least max_connections* 2 , 8KB each
work_mem =  1248576               # min  64 , size in KB
maintenance_work_mem =  163840    # min  1024 , size in KB
max_stack_depth =  2048           # min  100 , size in KB
sort_mem =  10240 

CREATE TABLE "traffic"."squidlog" (
  "dt" TIMESTAMP WITH TIME ZONE NOT NULL, 
  "replytime" NUMERIC( 10 , 0 ), 
  "dip" VARCHAR( 15 ) NOT NULL, 
  "r_mnemo" VARCHAR( 128 ), 
  "r_code" NUMERIC( 3 , 0 ), 
  "bytes" NUMERIC( 12 , 0 ) NOT NULL, 
  "method" VARCHAR( 12 ), 
  "url" TEXT NOT NULL, 
  "login" VARCHAR( 128 ) NOT NULL, 
  "connect" VARCHAR( 64 ), 
  "mimetype" VARCHAR( 100 ), 
  "surl" VARCHAR( 254 ), 
  "unixdt" NUMERIC( 14 , 3 )
) WITH OIDS;

CREATE INDEX "squidlog_bytes" ON "traffic"."squidlog"
  USING btree ("bytes");

CREATE INDEX "squidlog_connect" ON "traffic"."squidlog"
  USING btree ("connect");

CREATE INDEX "squidlog_dip" ON "traffic"."squidlog"
  USING btree ("dip");

CREATE INDEX "squidlog_dt" ON "traffic"."squidlog"
  USING btree ("dt");

CREATE INDEX "squidlog_login" ON "traffic"."squidlog"
  USING btree ("login");

CREATE INDEX "squidlog_method" ON "traffic"."squidlog"
  USING btree ("method");

CREATE INDEX "squidlog_mimetype" ON "traffic"."squidlog"
  USING btree ("mimetype");

CREATE INDEX "squidlog_rcode" ON "traffic"."squidlog"
  USING btree ("r_code");

CREATE INDEX "squidlog_rmnemo" ON "traffic"."squidlog"
  USING btree ("r_mnemo");

CREATE INDEX "squidlog_surl" ON "traffic"."squidlog"
  USING btree ("surl");

CREATE INDEX "squidlog_unixdt" ON "traffic"."squidlog"
  USING btree ("unixdt");

REATE OR REPLACE VIEW "traffic"."curr_squidlog" (
    dt,
    replytime,
    dip,
    r_mnemo,
    r_code,
    bytes,
    method,
    url,
    login,
    connect,
    mimetype,
    surl,
    unixdt)
AS
SELECT squidlog.dt, squidlog.replytime, squidlog.dip, squidlog.r_mnemo,
    squidlog.r_code, squidlog.bytes, squidlog.method, squidlog.url,
    squidlog.login, squidlog.connect, squidlog.mimetype, squidlog.surl, squidlog.unixdt
FROM traffic.squidlog
WHERE ((squidlog.dt >= date_trunc('month'::text, now())) AND (squidlog.dt <
    (date_trunc('month'::text, now()) + '1 mon'::interval)))
ORDER BY squidlog.dt;

select tsl.login, tsl.surl, sum(bytes) from traffic.curr_squidlog tsl
group by login, surl

QUERY PLAN
HashAggregate  (cost= 3 . 05 .. 3 . 05  rows= 1  width= 241 )
  ->  Subquery Scan curr_squidlog  (cost= 0 . 01 .. 3 . 04  rows= 1  width= 241 )
        ->  Index Scan using squidlog_dt on squidlog  (cost= 0 . 01 .. 3 . 03  rows= 1  width= 196 )
              Index Cond: ((dt >= date_trunc('month'::text, now())) AND (dt < (date_trunc('month'::text, now()) + '1 mon'::interval)))

WHERE ((squidlog.dt >= date_trunc('month'::text, now())) AND (squidlog.dt <
    (date_trunc('month'::text, now()) + '1 mon'::interval)))

WHERE date_part('month', dt) = date_part('month', now())