query-plan-1126

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
9.239 100.00% 
 HashAggregate (cost=22.39..22.41 rows=1 width=75) (actual time=9.232..9.239 rows=3 loops=1)
   Filter: (count(*) >= 10)
8.233 89.11% 
   -> Nested Loop (cost=0.0..22.38 rows=1 width=75) (actual time=0.148..8.233 rows=206 loops=1)
1.436 15.54% 
         -> Nested Loop (cost=0.0..13.8 rows=1 width=107) (actual time=0.095..1.436 rows=206 loops=1)
0.175 1.89% 
               -> Seq Scan on paliers p (cost=0.0..5.51 rows=1 width=42) (actual time=0.056..0.175 rows=46 loops=1)
                     Filter: (type_palier = 1)
0.782 8.46% 
               -> Index Scan using idx_acte_code_palier_id on acte_code ac (cost=0.0..8.28 rows=1 width=69) (actual time=0.005..0.017 rows=4 loops=46)
                     Index Cond: ((ac.palier_id > 0) AND (ac.palier_id = p.id_palier))
                     Filter: ((phone_number IS NOT NULL) AND (phone_number <> ''::text))
5.974 64.66% 
         -> Index Scan using code_pkey on code c (cost=0.0..8.56 rows=1 width=12) (actual time=0.027..0.029 rows=1 loops=206)
               Index Cond: (ac.code = c.code)