explain-analyze.info | query-plan-1162

Time	Node
Node (ms)	Percent
74574.054	100.00%	¶	`Nested Loop Left Join (cost=68948.34..202765.74 rows=1 width=244) (actual time=74574.054..74574.054 rows=0 loops=1)`
74574.044	100.00%	¶	`-> Nested Loop Left Join (cost=68948.34..202759.87 rows=1 width=176) (actual time=74574.044..74574.044 rows=0 loops=1)`
74574.040	100.00%	¶	`-> Nested Loop (cost=68948.34..202753.97 rows=1 width=176) (actual time=74574.040..74574.040 rows=0 loops=1)`
74574.031	100.00%	¶	`-> Hash Join (cost=68948.34..202748.07 rows=1 width=164) (actual time=74574.031..74574.031 rows=0 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)))`
15921.901	21.35%	¶	`-> Bitmap Heap Scan on application_history_archive h (cost=3479.8..57770.15 rows=472776 width=48) (actual time=699.737..15921.901 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))`
650.711	0.87%	¶	`-> BitmapOr (cost=3479.8..3479.8 rows=610230 width=0) (actual time=650.711..650.711 rows=0 loops=1)`
150.868	0.20%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=150.868..150.868 rows=64844 loops=1) Index Cond: (status_new = 40)`
15.257	0.02%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=15.257..15.257 rows=13510 loops=1) Index Cond: (status_new = 60)`
0.044	0.00%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=0.044..0.044 rows=0 loops=1) Index Cond: (status_new = 65)`
125.332	0.17%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=125.332..125.332 rows=111238 loops=1) Index Cond: (status_new = 70)`
328.393	0.44%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..1619.46 rows=284418 width=0) (actual time=328.393..328.393 rows=289070 loops=1) Index Cond: (status_new = 100)`
30.725	0.04%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=30.725..30.725 rows=27606 loops=1) Index Cond: (status_new = 110)`
0.046	0.00%	¶	`-> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=0.046..0.046 rows=0 loops=1) Index Cond: (status_new = 115)`
39254.262	52.64%	¶	`-> Hash (cost=54082.63..54082.63 rows=540763 width=124) (actual time=39254.262..39254.262 rows=540763 loops=1)`
33388.237	44.77%	¶	`-> Seq Scan on application_archive a (cost=0.0..54082.63 rows=540763 width=124) (actual time=20.950..33388.237 rows=540763 loops=1)`
0.000	0.00%	¶	`-> Index Scan using system_user__user_id_index on system_user c (never executed) Index Cond: (c.user_id = "outer".creator_user_id)`
0.000	0.00%	¶	`-> Index Scan using system_user__user_id_index on system_user u (never executed) Index Cond: (u.user_id = "outer".user_id)`
0.000	0.00%	¶	`-> Index Scan using shop__shop_id_index on shop s (never executed) Index Cond: (s.shop_id = "outer".shop_id)`

74574.054

100.00%

 Nested Loop Left Join (cost=68948.34..202765.74 rows=1 width=244) (actual time=74574.054..74574.054 rows=0 loops=1)

74574.044

100.00%

¶

   -> Nested Loop Left Join (cost=68948.34..202759.87 rows=1 width=176) (actual time=74574.044..74574.044 rows=0 loops=1)

74574.040

100.00%

¶

         -> Nested Loop (cost=68948.34..202753.97 rows=1 width=176) (actual time=74574.040..74574.040 rows=0 loops=1)

74574.031

100.00%

¶

               -> Hash Join (cost=68948.34..202748.07 rows=1 width=164) (actual time=74574.031..74574.031 rows=0 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)))

15921.901

21.35%

¶

                     -> Bitmap Heap Scan on application_history_archive h (cost=3479.8..57770.15 rows=472776 width=48) (actual time=699.737..15921.901 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))

650.711

0.87%

¶

                           -> BitmapOr (cost=3479.8..3479.8 rows=610230 width=0) (actual time=650.711..650.711 rows=0 loops=1)

150.868

0.20%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=150.868..150.868 rows=64844 loops=1)
                                       Index Cond: (status_new = 40)

15.257

0.02%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=15.257..15.257 rows=13510 loops=1)
                                       Index Cond: (status_new = 60)

0.044

0.00%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=0.044..0.044 rows=0 loops=1)
                                       Index Cond: (status_new = 65)

125.332

0.17%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=125.332..125.332 rows=111238 loops=1)
                                       Index Cond: (status_new = 70)

328.393

0.44%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..1619.46 rows=284418 width=0) (actual time=328.393..328.393 rows=289070 loops=1)
                                       Index Cond: (status_new = 100)

30.725

0.04%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=30.725..30.725 rows=27606 loops=1)
                                       Index Cond: (status_new = 110)

0.046

0.00%

¶

                                 -> Bitmap Index Scan on application_history_archive__status_new_index (cost=0.0..310.06 rows=54302 width=0) (actual time=0.046..0.046 rows=0 loops=1)
                                       Index Cond: (status_new = 115)

39254.262

52.64%

¶

                     -> Hash (cost=54082.63..54082.63 rows=540763 width=124) (actual time=39254.262..39254.262 rows=540763 loops=1)

33388.237

44.77%

¶

                           -> Seq Scan on application_archive a (cost=0.0..54082.63 rows=540763 width=124) (actual time=20.950..33388.237 rows=540763 loops=1)

0.000

0.00%

¶

               -> Index Scan using system_user__user_id_index on system_user c (never executed)
                     Index Cond: (c.user_id = "outer".creator_user_id)

0.000

0.00%

¶

         -> Index Scan using system_user__user_id_index on system_user u (never executed)
               Index Cond: (u.user_id = "outer".user_id)

0.000

0.00%

¶

   -> Index Scan using shop__shop_id_index on shop s (never executed)
         Index Cond: (s.shop_id = "outer".shop_id)