query-plan-1130

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
6776.405 100.00% 
 HashAggregate (cost=249184.11..249298.73 rows=5094 width=39) (actual time=6771.318..6776.405 rows=134 loops=1)
   Filter: (count(*) >= 10)
6729.516 99.31% 
   -> Nested Loop (cost=0.0..249107.7 rows=5094 width=39) (actual time=5022.038..6729.516 rows=21725 loops=1)
6657.922 98.25% 
         -> Nested Loop (cost=0.0..247680.87 rows=5094 width=18) (actual time=5022.015..6657.922 rows=21725 loops=1)
6214.463 91.71% 
               -> Seq Scan on code c (cost=0.0..157365.27 rows=11404 width=12) (actual time=5021.939..6214.463 rows=25088 loops=1)
                     Filter: ((payment_mode_id = 1) AND (access_type = 'A'::bpchar) AND money_transfer AND ((creation_date)::date = to_date('2008-10-17'::text, 'YYYY-MM-DD'::text)))
426.496 6.29% 
               -> Index Scan using acte_code_pkey on acte_code ac (cost=0.0..7.91 rows=1 width=30) (actual time=0.016..0.017 rows=1 loops=25088)
                     Index Cond: (c.code = ac.code)
                     Filter: ((phone_number IS NOT NULL) AND (phone_number <> ''::text) AND (palier_id > 0))
43.450 0.64% 
         -> Index Scan using paliers_pkey on paliers p (cost=0.0..0.27 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=21725)
               Index Cond: (ac.palier_id = p.id_palier)
Run-time
6.777025 seconds (6777.025 ms)