query-plan-1134

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
27195.243 100.00% 
 Nested Loop Left Join (cost=60802.39..165055.03 rows=4 width=220) (actual time=11338.190..27195.243 rows=3 loops=1)
4065.036 14.95% 
   -> Nested Loop Left Join (cost=60802.39..165031.64 rows=4 width=142) (actual time=2346.133..4065.036 rows=3 loops=1)
4064.906 14.95% 
         -> Nested Loop (cost=60802.39..165007.99 rows=4 width=142) (actual time=2346.108..4064.906 rows=3 loops=1)
4064.602 14.95% 
               -> Hash Join (cost=60802.39..164984.35 rows=4 width=146) (actual time=2345.954..4064.602 rows=3 loops=1)
                     Hash Cond: ("outer".application_id = "inner".application_id)
                     Join Filter: ((("inner".customer_entity = 1) AND (("inner".person_id)::text = '130965-10016'::text)) OR ((("outer".guarantor_id)::text = '130965-10016'::text) AND ("outer".status_new = 60)))
959.472 3.53% 
                     -> Bitmap Heap Scan on application_history_archive h (cost=3388.85..55547.09 rows=456594 width=48) (actual time=105.067..959.472 rows=504567 loops=1)
                           Recheck Cond: ((status_new = 40) OR (status_new = 60) OR (status_new = 65) OR (status_new = 70) OR (status_new = 100) OR (status_new = 110) OR (status_new = 115))
                           Filter: ((status_old <> 40) AND (status_old <> 60) AND (status_old <> 65) AND (status_old <> 70) AND (status_old <> 100) AND (status_old <> 110) AND (status_old <> 115))
94.787 0.35% 
                           -> BitmapOr (cost=3388.85..3388.85 rows=593672 width=0) (actual time=94.787..94.787 rows=0 loops=1)
14.141 0.05% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=14.141..14.141 rows=64844 loops=1)
                                       Index Cond: (status_new = 40)
2.523 0.01% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=2.523..2.523 rows=13510 loops=1)
                                       Index Cond: (status_new = 60)
0.006 0.00% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=0.006..0.006 rows=0 loops=1)
                                       Index Cond: (status_new = 65)
19.856 0.07% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=19.856..19.856 rows=111238 loops=1)
                                       Index Cond: (status_new = 70)
52.869 0.19% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..1674.11 rows=294032 width=0) (actual time=52.869..52.869 rows=289070 loops=1)
                                       Index Cond: (status_new = 100)
5.375 0.02% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=5.375..5.375 rows=27606 loops=1)
                                       Index Cond: (status_new = 110)
0.008 0.00% 
                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..285.79 rows=49940 width=0) (actual time=0.008..0.008 rows=0 loops=1)
                                       Index Cond: (status_new = 115)
2098.125 7.72% 
                     -> Hash (cost=56061.63..56061.63 rows=540763 width=106) (actual time=2098.125..2098.125 rows=540763 loops=1)
1300.031 4.78% 
                           -> Seq Scan on application_archive a (cost=0.0..56061.63 rows=540763 width=106) (actual time=0.028..1300.031 rows=540763 loops=1)
0.282 0.00% 
               -> Index Scan using system_user__user_id_index on system_user c (cost=0.0..5.9 rows=1 width=8) (actual time=0.093..0.094 rows=1 loops=3)
                     Index Cond: (c.user_id = "outer".creator_user_id)
0.111 0.00% 
         -> Index Scan using system_user__user_id_index on system_user u (cost=0.0..5.9 rows=1 width=12) (actual time=0.035..0.037 rows=1 loops=3)
               Index Cond: (u.user_id = "outer".user_id)
0.144 0.00% 
   -> Index Scan using shop__shop_id_index on shop s (cost=0.0..5.82 rows=1 width=86) (actual time=0.045..0.048 rows=1 loops=3)
         Index Cond: (s.shop_id = "outer".shop_id)
Run-time
27.207198 seconds (27207.198 ms)