SELECT connect_time, disconnect_time
		FROM mera_traffic
		WHERE disconnect_time>='20080901_000000' AND connect_time<='20080930_235959' AND elapsed_time> 0  AND hub_id= 1 

CREATE INDEX mera_traffic_connect_time
  ON mera_traffic
  USING btree
  (hub_id, connect_time, disconnect_time, elapsed_time);

"Seq Scan on mera_traffic  (cost=0.00..543120.68 rows=798672 width=16)"
"  Filter: ((disconnect_time >= '2008-09-01 00:00:00'::timestamp without time zone) AND (connect_time <= '2008-09-30 23:59:59'::timestamp without time zone) AND (elapsed_time > 0) AND (hub_id = 1))"

CREATE INDEX mera_traffic_connect_time2
  ON mera_traffic
  USING btree
  (disconnect_time, elapsed_time, (connect_time> 0 ));

EXPLAIN ANALYZE SELECT connect_time, disconnect_time
		FROM mera_traffic
		WHERE disconnect_time>='20080901_000000' AND connect_time<='20080930_235959' AND elapsed_time> 0 

Bitmap Heap Scan on mera_traffic  (cost= 62230 . 96 .. 409273 . 29  rows= 801075  width= 16 ) (actual time= 3545 . 171 .. 42675 . 544  rows= 868195  loops= 1 )
  Recheck Cond: ((disconnect_time >= '2008-09-01 00:00:00'::timestamp without time zone) AND (connect_time <= '2008-09-30 23:59:59'::timestamp without time zone))
  Filter: (elapsed_time >  0 )
  ->  Bitmap Index Scan on mera_traffic_connect_time2  (cost= 0 . 00 .. 62030 . 69  rows= 1003105  width= 0 ) (actual time= 3512 . 238 .. 3512 . 238  rows= 868195  loops= 1 )
        Index Cond: ((disconnect_time >= '2008-09-01 00:00:00'::timestamp without time zone) AND (connect_time <= '2008-09-30 23:59:59'::timestamp without time zone) AND ((elapsed_time >  0 ) = true))
Total runtime:  43959 . 783  ms

SELECT connect_time, disconnect_time
		FROM mera_traffic
		WHERE ((connect_time BETWEEN '20080901_000000' AND '20080930_235959') OR (disconnect_time BETWEEN '20080901_000000' AND '20080930_235959')) AND elapsed_time> 0 

CREATE OR REPLACE FUNCTION mera_calc_peak(IN i_hub_id bigint, IN t_from timestamp without time zone, IN t_to timestamp without time zone, OUT peak_time timestamp without time zone, OUT peak bigint)
  RETURNS record AS
$BODY$
BEGIN
	BEGIN DROP TABLE temp_calls; EXCEPTION WHEN others THEN END;
	CREATE TEMP TABLE temp_calls AS (
		SELECT connect_time, disconnect_time
		FROM mera_traffic
		WHERE disconnect_time>=t_from AND connect_time<=t_to AND elapsed_time> 0  AND hub_id=i_hub_id
	);
	SELECT times, MAX(entries) INTO peak_time, peak FROM (
		SELECT q.times, COUNT(*) AS entries
		FROM (
			SELECT DISTINCT connect_time as times FROM temp_calls
		) AS q
		LEFT JOIN temp_calls tc ON tc.connect_time<=q.times AND tc.disconnect_time>=q.times
		GROUP BY q.times
	) AS w
	GROUP BY times
	ORDER BY  2  DESC;
	DROP TABLE temp_calls;
	RETURN;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST  100 ;

EXPLAIN ANALYZE SELECT connect_time, disconnect_time
	FROM mera_traffic
LEFT JOIN (
	SELECT 
		CASE 
			WHEN MIN(connect_time) IS NULL THEN '20080901_000000'
			ELSE MIN(connect_time)
		END AS begin_time
	FROM mera_traffic
	WHERE '20080901_000000' BETWEEN connect_time AND disconnect_time AND elapsed_time> 0 
) AS q ON  1 = 1 
LEFT JOIN (
	SELECT 
		CASE 
			WHEN MAX(connect_time) IS NULL THEN '20080929_235959'
			ELSE MAX(connect_time)
		END AS end_time
	FROM mera_traffic
	WHERE '20080929_235959' BETWEEN connect_time AND disconnect_time AND elapsed_time> 0 
	) AS w ON  1 = 1 
WHERE connect_time BETWEEN q.begin_time AND w.end_time AND elapsed_time> 0 

CREATE INDEX mera_traffic_connect_time
  ON mera_traffic
  USING btree
  (connect_time, (elapsed_time >  0 ));
CREATE INDEX mera_traffic_connect_time2
  ON mera_traffic
  USING btree
  (disconnect_time, connect_time, (elapsed_time >  0 ));

"Nested Loop  (cost=4076.72..23345.90 rows=24386 width=16) (actual time=87.862..1352.042 rows=128369 loops=1)"
"  Join Filter: (public.mera_traffic.connect_time >= (CASE WHEN ($0 IS NULL) THEN '2008-09-01 00:00:00'::timestamp without time zone ELSE $0 END))"
"  ->  Result  (cost=2.73..2.74 rows=1 width=0) (actual time=0.476..0.478 rows=1 loops=1)"
"        InitPlan"
"          ->  Limit  (cost=0.00..2.73 rows=1 width=8) (actual time=0.468..0.468 rows=0 loops=1)"
"                ->  Index Scan using mera_traffic_connect_time on mera_traffic  (cost=0.00..59.96 rows=22 width=8) (actual time=0.464..0.464 rows=0 loops=1)"
"                      Index Cond: (('2008-09-01 00:00:00'::timestamp without time zone >= connect_time) AND ((elapsed_time > 0) = true))"
"                      Filter: ((connect_time IS NOT NULL) AND ('2008-09-01 00:00:00'::timestamp without time zone <= disconnect_time) AND (elapsed_time > 0))"
"  ->  Nested Loop  (cost=4073.99..22428.69 rows=73157 width=16) (actual time=87.374..942.433 rows=128369 loops=1)"
"        ->  Result  (cost=1.23..1.24 rows=1 width=0) (actual time=0.094..0.096 rows=1 loops=1)"
"              InitPlan"
"                ->  Limit  (cost=0.00..1.23 rows=1 width=8) (actual time=0.083..0.085 rows=1 loops=1)"
"                      ->  Index Scan Backward using mera_traffic_connect_time on mera_traffic  (cost=0.00..64325.86 rows=52247 width=8) (actual time=0.080..0.080 rows=1 loops=1)"
"                            Index Cond: (('2008-09-29 23:59:59'::timestamp without time zone >= connect_time) AND ((elapsed_time > 0) = true))"
"                            Filter: ((connect_time IS NOT NULL) AND ('2008-09-29 23:59:59'::timestamp without time zone <= disconnect_time) AND (elapsed_time > 0))"
"        ->  Bitmap Heap Scan on mera_traffic  (cost=4072.76..21336.10 rows=87307 width=16) (actual time=87.267..539.106 rows=128369 loops=1)"
"              Recheck Cond: (public.mera_traffic.connect_time <= (CASE WHEN ($1 IS NULL) THEN '2008-09-29 23:59:59'::timestamp without time zone ELSE $1 END))"
"              Filter: (public.mera_traffic.elapsed_time > 0)"
"              ->  Bitmap Index Scan on mera_traffic_connect_time  (cost=0.00..4054.47 rows=87307 width=0) (actual time=81.984..81.984 rows=128369 loops=1)"
"                    Index Cond: ((public.mera_traffic.connect_time <= (CASE WHEN ($1 IS NULL) THEN '2008-09-29 23:59:59'::timestamp without time zone ELSE $1 END)) AND ((public.mera_traffic.elapsed_time > 0) = true))"
"Total runtime: 1540.309 ms"

SELECT connect_time, disconnect_time
	FROM mera_traffic
WHERE connect_time BETWEEN '20080901_000000' AND '20080929_235959' AND elapsed_time> 0 

"Seq Scan on mera_traffic  (cost=0.00..25354.94 rows=133803 width=16) (actual time=0.024..5592.228 rows=128369 loops=1)"
"  Filter: ((connect_time >= '2008-09-01 00:00:00'::timestamp without time zone) AND (connect_time <= '2008-09-29 23:59:59'::timestamp without time zone) AND (elapsed_time > 0))"
"Total runtime: 5786.737 ms"