#
# Anzahl S?tze in der DB, von Datum, bis Datum, Anzahl Tage
#
                             QUERY PLAN                             
--------------------------------------------------------------------
 Aggregate  (cost=41037.49..41037.50 rows=1 width=4)
   ->  Seq Scan on flows  (cost=0.00..31493.88 rows=763488 width=4)
(2 rows)

#
# Tagesstatistik je Protokoll
#
                                            QUERY PLAN                                             
---------------------------------------------------------------------------------------------------
 Sort  (cost=176464.17..176474.37 rows=4078 width=28)
   Sort Key: f.date, (sum(f.sdbytes) + sum(f.dsbytes))
   ->  GroupAggregate  (cost=163062.45..176219.62 rows=4078 width=28)
         ->  Sort  (cost=163062.45..164933.31 rows=748343 width=28)
               Sort Key: f.date, p.pname
               ->  Hash Join  (cost=2.62..46539.09 rows=748343 width=28)
                     Hash Cond: ("outer"."type" = "inner".pnum)
                     ->  Seq Scan on flows f  (cost=0.00..35311.32 rows=748343 width=24)
                           Filter: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
                     ->  Hash  (cost=2.30..2.30 rows=130 width=12)
                           ->  Seq Scan on protos p  (cost=0.00..2.30 rows=130 width=12)
(11 rows)

#
# Tagesstatistik gesamt
#
                                      QUERY PLAN                                       
---------------------------------------------------------------------------------------
 Sort  (cost=44666.89..44666.97 rows=32 width=20)
   Sort Key: date, (sum(sdbytes) + sum(dsbytes))
   ->  HashAggregate  (cost=44665.61..44666.09 rows=32 width=20)
         ->  Seq Scan on flows f  (cost=0.00..35311.32 rows=748343 width=20)
               Filter: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
(5 rows)

#
# Top 50: max( Bytes )
#
                                            QUERY PLAN                                             
---------------------------------------------------------------------------------------------------
 Limit  (cost=309333.47..309333.60 rows=50 width=30)
   ->  Sort  (cost=309333.47..311204.33 rows=748343 width=30)
         Sort Key: (sum(sdbytes) + sum(dsbytes))
         ->  GroupAggregate  (cost=162968.11..189160.11 rows=748343 width=30)
               ->  Sort  (cost=162968.11..164838.97 rows=748343 width=30)
                     Sort Key: network(set_masklen(sip, 16)), network(set_masklen(dip, 16))
                     ->  Seq Scan on flows f  (cost=0.00..42794.75 rows=748343 width=30)
                           Filter: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
(8 rows)