query-plan-1127

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
11.448 100.00% 
 HashAggregate (cost=470.56..471.05 rows=22 width=75) (actual time=11.440..11.448 rows=3 loops=1)
   Filter: (count(*) >= 10)
10.609 92.67% 
   -> Nested Loop (cost=6.72..470.23 rows=22 width=75) (actual time=0.546..10.609 rows=205 loops=1)
1.647 14.39% 
         -> Hash Join (cost=6.72..15.54 rows=53 width=107) (actual time=0.487..1.647 rows=210 loops=1)
               Hash Cond: (ac.palier_id = p.id_palier)
0.539 4.71% 
               -> Seq Scan on acte_code ac (cost=0.0..7.96 rows=87 width=69) (actual time=0.036..0.539 rows=210 loops=1)
                     Filter: ((phone_number IS NOT NULL) AND (phone_number <> ''::text) AND (palier_id > 0))
0.429 3.75% 
               -> Hash (cost=5.21..5.21 rows=121 width=42) (actual time=0.429..0.429 rows=121 loops=1)
0.219 1.91% 
                     -> Seq Scan on paliers p (cost=0.0..5.21 rows=121 width=42) (actual time=0.014..0.219 rows=121 loops=1)
6.510 56.87% 
         -> 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: (ac.code = c.code)
               Filter: (payment_mode_id = 1)
Run-time
0.011695 seconds (11.695 ms)