query-plan-1150

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
5024.838 100.00% 
 Sort (cost=440267.26..440267.27 rows=1 width=41) (actual time=5024.824..5024.838 rows=203 loops=1)
   Sort Key: (sum(date_part('epoch'::text, duration)))
   Sort Method:  quicksort  Memory: 40kB
5024.659 100.00% 
   -> HashAggregate (cost=440267.22..440267.25 rows=1 width=41) (actual time=5024.545..5024.659 rows=203 loops=1)
         Filter: ((count(*) >= 1) AND (sum(date_part('epoch'::text, duration)) >= 1::double precision))
5024.215 99.99% 
         -> Seq Scan on call_detail_record (cost=0.0..440267.09 rows=9 width=41) (actual time=768.695..5024.215 rows=236 loops=1)
               Filter: ((origin IS NOT NULL) AND (origin <> ''::text) AND (dialled_number ~~ '%899230777%'::text) AND (date >= to_date('22-10-2008'::text, 'DD-MM-YYYY'::text)) AND (("time" + duration) >= '10:00:00'::time without time zone) AND (date <= to_date('22-10-2008'::text, 'DD-MM-YYYY'::text)) AND (("time" + duration) <= '10:10:00'::time without time zone))
Run-time
5.024908 seconds (5024.908 ms)