#
# Anzahl Sätze in der DB, von Datum, bis Datum, Anzahl Tage
#
                                                     QUERY PLAN                                                     
--------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=41037.49..41037.50 rows=1 width=4) (actual time=6307.81..6307.82 rows=1 loops=1)
   ->  Seq Scan on flows  (cost=0.00..31493.88 rows=763488 width=4) (actual time=0.02..3134.26 rows=763488 loops=1)
 Total runtime: 6323.81 msec
(3 rows)

#
# Tagesstatistik je Protokoll
#
                                                                   QUERY PLAN                                                                    
-------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=14991.34..14991.66 rows=131 width=52) (actual time=16473.23..16473.77 rows=159 loops=1)
   Sort Key: f.date, (sum(f.sdbytes) + sum(f.dsbytes))
   ->  HashAggregate  (cost=14984.76..14986.73 rows=131 width=52) (actual time=16471.51..16472.41 rows=159 loops=1)
         ->  Hash Join  (cost=2.62..14947.53 rows=2482 width=52) (actual time=1.53..11924.14 rows=753800 loops=1)
               Hash Cond: ("outer"."type" = "inner".pnum)
               ->  Index Scan using flows_2 on flows f  (cost=0.00..14786.46 rows=3818 width=24) (actual time=0.15..4180.55 rows=753800 loops=1)
                     Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
               ->  Hash  (cost=2.30..2.30 rows=130 width=36) (actual time=1.17..1.17 rows=0 loops=1)
                     ->  Seq Scan on protos p  (cost=0.00..2.30 rows=130 width=36) (actual time=0.06..0.62 rows=130 loops=1)
 Total runtime: 16499.55 msec
(10 rows)

#
# Tagesstatistik gesamt
#
                                                                QUERY PLAN                                                                 
-------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=14834.22..14834.23 rows=2 width=20) (actual time=8519.01..8519.12 rows=31 loops=1)
   Sort Key: date, (sum(sdbytes) + sum(dsbytes))
   ->  GroupAggregate  (cost=0.00..14834.21 rows=2 width=20) (actual time=309.70..8518.71 rows=31 loops=1)
         ->  Index Scan using flows_2 on flows f  (cost=0.00..14786.46 rows=3818 width=20) (actual time=0.19..3989.96 rows=753800 loops=1)
               Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
 Total runtime: 8519.59 msec
(6 rows)

#
# Top 50: max( Bytes )
#
                                                                   QUERY PLAN                                                                    
-------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=14884.07..14884.20 rows=50 width=72) (actual time=15852.17..15852.70 rows=50 loops=1)
   ->  Sort  (cost=14884.07..14884.58 rows=201 width=72) (actual time=15852.16..15852.34 rows=50 loops=1)
         Sort Key: (sum(sdbytes) + sum(dsbytes))
         ->  HashAggregate  (cost=14872.36..14876.38 rows=201 width=72) (actual time=15406.83..15551.54 rows=23410 loops=1)
               ->  Index Scan using flows_2 on flows f  (cost=0.00..14824.64 rows=3818 width=72) (actual time=0.21..6820.67 rows=753800 loops=1)
                     Index Cond: ((date >= '2003-07-01'::date) AND (date <= '2003-08-01'::date))
 Total runtime: 15907.26 msec
(7 rows)