query-plan-1129

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
10.303 100.00% 
 HashAggregate (cost=470.57..470.89 rows=14 width=75) (actual time=10.296..10.303 rows=3 loops=1)
   Filter: (count(*) >= 10)
8.897 86.35% 
   -> Nested Loop (cost=6.72..470.36 rows=14 width=75) (actual time=0.558..8.897 rows=205 loops=1)
1.578 15.32% 
         -> Hash Join (cost=6.72..15.54 rows=53 width=107) (actual time=0.484..1.578 rows=210 loops=1)
               Hash Cond: (ac.palier_id = p.id_palier)
0.527 5.12% 
               -> Seq Scan on acte_code ac (cost=0.0..7.96 rows=87 width=69) (actual time=0.042..0.527 rows=210 loops=1)
                     Filter: ((phone_number IS NOT NULL) AND (phone_number <> ''::text) AND (palier_id > 0))
0.421 4.09% 
               -> Hash (cost=5.21..5.21 rows=121 width=42) (actual time=0.421..0.421 rows=121 loops=1)
0.212 2.06% 
                     -> Seq Scan on paliers p (cost=0.0..5.21 rows=121 width=42) (actual time=0.016..0.212 rows=121 loops=1)
6.510 63.19% 
         -> Index Scan using code_pkey on code c (cost=0.0..8.57 rows=1 width=12) (actual time=0.029..0.031 rows=1 loops=210)
               Index Cond: (c.code = ac.code)
               Filter: ((payment_mode_id = 1) AND (access_type = 'A'::bpchar) AND money_transfer)