query-plan-1128

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
9.660 100.00% 
 HashAggregate (cost=470.57..470.89 rows=14 width=75) (actual time=9.654..9.660 rows=3 loops=1)
   Filter: (count(*) >= 10)
8.888 92.01% 
   -> Nested Loop (cost=6.72..470.36 rows=14 width=75) (actual time=0.536..8.888 rows=205 loops=1)
1.573 16.28% 
         -> Hash Join (cost=6.72..15.54 rows=53 width=107) (actual time=0.468..1.573 rows=210 loops=1)
               Hash Cond: (ac.palier_id = p.id_palier)
0.524 5.42% 
               -> Seq Scan on acte_code ac (cost=0.0..7.96 rows=87 width=69) (actual time=0.036..0.524 rows=210 loops=1)
                     Filter: ((phone_number IS NOT NULL) AND (phone_number <> ''::text) AND (palier_id > 0))
0.412 4.27% 
               -> Hash (cost=5.21..5.21 rows=121 width=42) (actual time=0.412..0.412 rows=121 loops=1)
0.211 2.18% 
                     -> Seq Scan on paliers p (cost=0.0..5.21 rows=121 width=42) (actual time=0.015..0.211 rows=121 loops=1)
6.510 67.39% 
         -> 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) AND (access_type = 'A'::bpchar) AND money_transfer)
Run-time
0.009907 seconds (9.907 ms)