#
# 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=14991.34..14991.66 rows=131 width=52)
   Sort Key: f.date, (sum(f.sdbytes) + sum(f.dsbytes))
   ->  HashAggregate  (cost=14984.76..14986.73 rows=131 width=52)
         ->  Hash Join  (cost=2.62..14947.53 rows=2482 width=52)
               Hash Cond: ("outer"."type" = "inner".pnum)
               ->  Index Scan using flows_2 on flows f  (cost=0.00..14786.46 rows=3818 width=24)
                     Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
               ->  Hash  (cost=2.30..2.30 rows=130 width=36)
                     ->  Seq Scan on protos p  (cost=0.00..2.30 rows=130 width=36)
(9 rows)

#
# Tagesstatistik gesamt
#
                                        QUERY PLAN                                         
-------------------------------------------------------------------------------------------
 Sort  (cost=14834.22..14834.23 rows=2 width=20)
   Sort Key: date, (sum(sdbytes) + sum(dsbytes))
   ->  GroupAggregate  (cost=0.00..14834.21 rows=2 width=20)
         ->  Index Scan using flows_2 on flows f  (cost=0.00..14786.46 rows=3818 width=20)
               Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
(5 rows)

#
# Top 50: max( Bytes )
#
                                           QUERY PLAN                                            
-------------------------------------------------------------------------------------------------
 Limit  (cost=14884.07..14884.20 rows=50 width=72)
   ->  Sort  (cost=14884.07..14884.58 rows=201 width=72)
         Sort Key: (sum(sdbytes) + sum(dsbytes))
         ->  HashAggregate  (cost=14872.36..14876.38 rows=201 width=72)
               ->  Index Scan using flows_2 on flows f  (cost=0.00..14824.64 rows=3818 width=72)
                     Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
(6 rows)