explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HCvR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

CTE Scan on cs_postal_sendouts (cost=5,729,916,627,565,910.00..30,559,105,722,385,688.00 rows=95,496,881,133,922,208 width=1,218) (actual rows= loops=)

  • Functions: 1092
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2.          

CTE params

3. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=4) (actual rows= loops=)

4.          

CTE new_cs_data

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,399,630.38..3,416,697.29 rows=1,706,691 width=47) (actual rows= loops=)

  • Group Key: map.kredit_privat_id, ptm.user_id
6.          

Initplan (forHashAggregate)

7. 0.000 0.000 ↓ 0.0

CTE Scan on params (cost=0.00..0.01 rows=1 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,262,194.60..3,386,830.18 rows=1,706,691 width=46) (actual rows= loops=)

  • Hash Cond: (log.print_to_mail_id = ptm.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on print_to_mail_log log (cost=0.00..100,641.09 rows=2,473,766 width=8) (actual rows= loops=)

  • Filter: ((action)::text = ANY ('{SEND,PRINTED}'::text[]))
10. 0.000 0.000 ↓ 0.0

Hash (cost=3,250,729.31..3,250,729.31 rows=1,528,706 width=62) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,126,345.61..3,250,729.31 rows=1,528,706 width=62) (actual rows= loops=)

  • Hash Cond: (ptm_file.print_to_mail_id = ptm.id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on print_to_mail_file ptm_file (cost=0.00..97,905.24 rows=5,022,648 width=31) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=3,121,914.15..3,121,914.15 rows=590,861 width=31) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,835,873.49..3,121,914.15 rows=590,861 width=31) (actual rows= loops=)

  • Hash Cond: ((ptm.ext_ref_id)::bigint = map.brokerage_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using idx_print_to_mail_creation_date on print_to_mail ptm (cost=0.43..37,879.47 rows=590,861 width=33) (actual rows= loops=)

  • Index Cond: (created_at >= $1)
  • Filter: (((channel)::text = ANY ('{cs,campaign}'::text[])) AND ((status)::text = ANY ('{PRINTED,SENT}'::text[])) AND ((ext_ref_id)::text <> '12663387;0369449184;DD766B2DC35AC9A8CFE9093B64A29C2BD36CA3AC738559300C0CC2BD8B46998F'::text) AND ((mandator)::text = 'brokerage'::text) AND (id <> ALL ('{630568,634871,743928,753949,780611,799710}'::bigint[])))
16. 0.000 0.000 ↓ 0.0

Hash (cost=2,012,431.23..2,012,431.23 rows=109,792,245 width=16) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on brokerage_entity_map map (cost=0.00..2,012,431.23 rows=109,792,245 width=16) (actual rows= loops=)

18.          

CTE raw_ba_eff

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,643,299.95..14,375,589.68 rows=2,953,182 width=87) (actual rows= loops=)

  • Hash Cond: (ba.loan_application = la1.la_id)
20.          

Initplan (forHash Join)

21. 0.000 0.000 ↓ 0.0

CTE Scan on params params_1 (cost=0.00..0.01 rows=1 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Append (cost=0.12..12,665,843.27 rows=2,953,182 width=63) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m1_loan_application_idx on ba_y2012m1 ba (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
24. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m2_loan_application_idx on ba_y2012m2 ba_1 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
25. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m3_loan_application_idx on ba_y2012m3 ba_2 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
26. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m4_loan_application_idx on ba_y2012m4 ba_3 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
27. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m5_ba_creation_day_idx on ba_y2012m5 ba_4 (cost=0.29..910.50 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
28. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m6_ba_creation_day_idx on ba_y2012m6 ba_5 (cost=0.29..1,378.11 rows=1 width=84) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
29. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m7_ba_creation_day_idx on ba_y2012m7 ba_6 (cost=0.29..1,684.87 rows=1 width=84) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
30. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m8_ba_creation_day_idx on ba_y2012m8 ba_7 (cost=0.29..2,123.71 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
31. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m9_ba_creation_day_idx on ba_y2012m9 ba_8 (cost=0.29..3,617.76 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
32. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m10_ba_creation_day_idx on ba_y2012m10 ba_9 (cost=0.29..3,722.60 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
33. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m11_ba_creation_day_idx on ba_y2012m11 ba_10 (cost=0.29..3,606.20 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
34. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m12_ba_creation_day_idx on ba_y2012m12 ba_11 (cost=0.29..3,802.76 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
35. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m1_ba_creation_day_idx on ba_y2013m1 ba_12 (cost=0.29..6,753.25 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
36. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m2_ba_creation_day_idx on ba_y2013m2 ba_13 (cost=0.29..5,881.40 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
37. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m3_ba_creation_day_idx on ba_y2013m3 ba_14 (cost=0.29..5,884.52 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
38. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m4_ba_creation_day_idx on ba_y2013m4 ba_15 (cost=0.29..6,178.51 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
39. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m5_ba_creation_day_idx on ba_y2013m5 ba_16 (cost=0.29..6,878.33 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
40. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m6_ba_creation_day_idx on ba_y2013m6 ba_17 (cost=0.29..7,477.28 rows=1 width=86) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
41. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m7_ba_creation_day_idx on ba_y2013m7 ba_18 (cost=0.42..9,472.27 rows=6,061 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
42. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m8_ba_creation_day_idx on ba_y2013m8 ba_19 (cost=0.42..11,466.12 rows=15,403 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
43. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m9_ba_creation_day_idx on ba_y2013m9 ba_20 (cost=0.42..10,764.44 rows=14,705 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
44. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m10_ba_creation_day_idx on ba_y2013m10 ba_21 (cost=0.42..10,565.41 rows=14,244 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
45. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m11_ba_creation_day_idx on ba_y2013m11 ba_22 (cost=0.42..9,570.18 rows=12,828 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
46. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m12_ba_creation_day_idx on ba_y2013m12 ba_23 (cost=0.29..6,300.93 rows=8,394 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
47. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m1_ba_creation_day_idx on ba_y2014m1 ba_24 (cost=0.42..11,034.59 rows=16,135 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
48. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m2_ba_creation_day_idx on ba_y2014m2 ba_25 (cost=0.42..10,436.16 rows=14,173 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
49. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m3_ba_creation_day_idx on ba_y2014m3 ba_26 (cost=0.42..11,430.16 rows=14,316 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
50. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m4_ba_creation_day_idx on ba_y2014m4 ba_27 (cost=0.42..12,717.77 rows=15,379 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
51. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m5_ba_creation_day_idx on ba_y2014m5 ba_28 (cost=0.42..13,949.79 rows=17,159 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
52. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m6_ba_creation_day_idx on ba_y2014m6 ba_29 (cost=0.42..14,208.47 rows=17,742 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
53. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m7_ba_creation_day_idx on ba_y2014m7 ba_30 (cost=0.42..18,011.61 rows=22,910 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
54. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m8_ba_creation_day_idx on ba_y2014m8 ba_31 (cost=0.42..15,717.16 rows=17,873 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
55. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m9_ba_creation_day_idx on ba_y2014m9 ba_32 (cost=0.42..18,865.13 rows=21,167 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
56. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m10_ba_creation_day_idx on ba_y2014m10 ba_33 (cost=0.42..18,905.32 rows=21,189 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
57. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m11_ba_creation_day_idx on ba_y2014m11 ba_34 (cost=0.42..16,305.23 rows=19,419 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
58. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m12_ba_creation_day_idx on ba_y2014m12 ba_35 (cost=0.42..15,504.63 rows=16,653 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
59. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m1_ba_creation_day_idx on ba_y2015m1 ba_36 (cost=0.42..26,585.31 rows=29,193 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
60. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m2_ba_creation_day_idx on ba_y2015m2 ba_37 (cost=0.42..22,996.77 rows=26,665 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
61. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m3_ba_creation_day_idx on ba_y2015m3 ba_38 (cost=0.42..28,328.23 rows=31,330 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
62. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m4_ba_creation_day_idx on ba_y2015m4 ba_39 (cost=0.42..26,622.45 rows=27,057 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
63. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m5_ba_creation_day_idx on ba_y2015m5 ba_40 (cost=0.42..30,407.23 rows=30,601 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
64. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m6_ba_creation_day_idx on ba_y2015m6 ba_41 (cost=0.42..35,167.75 rows=32,748 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
65. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m7_ba_creation_day_idx on ba_y2015m7 ba_42 (cost=0.42..44,352.24 rows=36,632 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
66. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m8_ba_creation_day_idx on ba_y2015m8 ba_43 (cost=0.42..32,654.69 rows=25,554 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
67. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m9_ba_creation_day_idx on ba_y2015m9 ba_44 (cost=0.42..38,239.34 rows=28,281 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
68. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m10_ba_creation_day_idx on ba_y2015m10 ba_45 (cost=0.42..41,538.84 rows=28,531 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
69. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m11_ba_creation_day_idx on ba_y2015m11 ba_46 (cost=0.42..42,688.59 rows=26,766 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
70. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m12_ba_creation_day_idx on ba_y2015m12 ba_47 (cost=0.42..35,283.52 rows=21,982 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
71. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m1_ba_creation_day_idx on ba_y2016m1 ba_48 (cost=0.42..54,146.52 rows=38,063 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
72. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m2_ba_creation_day_idx on ba_y2016m2 ba_49 (cost=0.42..52,904.62 rows=35,544 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
73. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m3_ba_creation_day_idx on ba_y2016m3 ba_50 (cost=0.42..42,219.41 rows=29,396 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
74. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m4_ba_creation_day_idx on ba_y2016m4 ba_51 (cost=0.42..43,706.24 rows=29,916 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
75. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m5_ba_creation_day_idx on ba_y2016m5 ba_52 (cost=0.42..43,368.81 rows=28,762 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
76. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m6_ba_creation_day_idx on ba_y2016m6 ba_53 (cost=0.42..48,689.22 rows=30,420 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
77. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m7_ba_creation_day_idx on ba_y2016m7 ba_54 (cost=0.42..51,201.02 rows=27,348 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
78. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m8 ba_55 (cost=3,432.14..145,810.78 rows=33,380 width=62) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m8_ba_creation_day_idx (cost=0.00..3,423.80 rows=235,383 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
80. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m9 ba_56 (cost=3,357.36..143,946.11 rows=34,215 width=62) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
81. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m9_ba_creation_day_idx (cost=0.00..3,348.81 rows=230,984 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
82. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m10 ba_57 (cost=3,616.44..155,703.83 rows=37,453 width=62) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
83. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m10_ba_creation_day_idx (cost=0.00..3,607.07 rows=249,153 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
84. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m11 ba_58 (cost=3,724.52..159,434.19 rows=36,852 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
85. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m11_ba_creation_day_idx (cost=0.00..3,715.31 rows=256,651 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
86. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m12 ba_59 (cost=3,263.84..140,301.40 rows=31,544 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
87. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m12_ba_creation_day_idx (cost=0.00..3,255.96 rows=224,471 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
88. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m1 ba_60 (cost=5,289.51..228,072.98 rows=54,248 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
89. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m1_ba_creation_day_idx (cost=0.00..5,275.95 rows=363,670 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
90. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m2 ba_61 (cost=6,223.25..254,696.58 rows=50,625 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
91. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m2_ba_creation_day_idx (cost=0.00..6,210.60 rows=339,756 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
92. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m3 ba_62 (cost=10,265.58..421,997.59 rows=65,506 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
93. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m3_ba_creation_day_idx (cost=0.00..10,249.20 rows=449,970 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
94. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m4_ba_creation_day_idx on ba_y2017m4 ba_63 (cost=0.42..275,934.57 rows=49,510 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
95. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m5 ba_64 (cost=13,271.65..556,770.31 rows=73,599 width=64) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
96. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m5_ba_creation_day_idx (cost=0.00..13,253.25 rows=554,777 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
97. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m6 ba_65 (cost=12,535.79..446,116.95 rows=60,288 width=64) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
98. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m6_ba_creation_day_idx (cost=0.00..12,520.72 rows=420,839 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
99. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m7_ba_creation_day_idx on ba_y2017m7 ba_66 (cost=0.43..586,882.77 rows=153,535 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
100. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m8 ba_67 (cost=11,882.40..483,953.62 rows=71,897 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m8_ba_creation_day_idx (cost=0.00..11,864.43 rows=481,867 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
102. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m9_ba_creation_day_idx on ba_y2017m9 ba_68 (cost=0.42..112,898.29 rows=30,338 width=64) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
103. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m10_ba_creation_day_idx on ba_y2017m10 ba_69 (cost=0.42..119,458.84 rows=30,891 width=64) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
104. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m11 ba_70 (cost=5,868.13..233,936.59 rows=30,793 width=64) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
105. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m11_ba_creation_day_idx (cost=0.00..5,860.43 rows=232,801 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
106. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m12 ba_71 (cost=4,900.17..191,660.52 rows=23,885 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
107. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m12_ba_creation_day_idx (cost=0.00..4,894.20 rows=190,636 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
108. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m1 ba_72 (cost=10,784.67..420,109.99 rows=58,400 width=64) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
109. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m1_ba_creation_day_idx (cost=0.00..10,770.07 rows=417,819 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
110. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m2 ba_73 (cost=11,865.71..464,424.70 rows=66,649 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
111. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m2_ba_creation_day_idx (cost=0.00..11,849.05 rows=461,950 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
112. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m3_ba_creation_day_idx on ba_y2018m3 ba_74 (cost=0.43..287,379.05 rows=82,897 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
113. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m4 ba_75 (cost=9,246.47..361,814.00 rows=59,646 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
114. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m4_ba_creation_day_idx (cost=0.00..9,231.56 rows=359,884 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
115. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m5_ba_creation_day_idx on ba_y2018m5 ba_76 (cost=0.43..206,553.66 rows=59,873 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
116. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m6_ba_creation_day_idx on ba_y2018m6 ba_77 (cost=0.43..218,986.53 rows=60,960 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
117. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m7_ba_creation_day_idx on ba_y2018m7 ba_78 (cost=0.43..223,072.39 rows=68,182 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
118. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m8_ba_creation_day_idx on ba_y2018m8 ba_79 (cost=0.43..221,430.90 rows=68,284 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
119. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m9_ba_creation_day_idx on ba_y2018m9 ba_80 (cost=0.43..228,775.43 rows=82,196 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
120. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m10_ba_creation_day_idx on ba_y2018m10 ba_81 (cost=0.43..221,144.46 rows=77,809 width=63) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
121. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m11 ba_82 (cost=8,795.00..360,338.26 rows=69,153 width=64) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
122. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m11_ba_creation_day_idx (cost=0.00..8,777.71 rows=358,838 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
123. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m12 ba_83 (cost=6,671.71..208,806.99 rows=31,665 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
124. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m12_ba_creation_day_idx (cost=0.00..6,663.79 rows=159,649 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
125. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m1 ba_84 (cost=13,031.11..409,994.21 rows=60,950 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
126. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m1_ba_creation_day_idx (cost=0.00..13,015.87 rows=313,526 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
127. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m2 ba_85 (cost=49,221.72..1,548,809.47 rows=209,399 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
128. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m2_ba_creation_day_idx (cost=0.00..49,169.37 rows=1,184,392 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
129. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m3 ba_86 (cost=14,749.41..461,908.81 rows=56,787 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
130. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m3_ba_creation_day_idx (cost=0.00..14,735.21 rows=353,171 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
131. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m4 ba_87 (cost=11,456.87..358,885.49 rows=41,682 width=63) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
132. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m4_ba_creation_day_idx (cost=0.00..11,446.45 rows=274,403 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
133. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m5 ba_88 (cost=13,597.49..423,980.56 rows=40,521 width=62) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
134. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m5_ba_creation_day_idx (cost=0.00..13,587.36 rows=324,125 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
135. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m6_ba_creation_day_idx on ba_y2019m6 ba_89 (cost=0.42..338,201.62 rows=39,007 width=62) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $3)
  • Filter: ((ba_eff IS NOT NULL) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
136. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m7_loan_application_idx on ba_y2019m7 ba_90 (cost=0.38..4.39 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
137. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m8_loan_application_idx on ba_y2019m8 ba_91 (cost=0.38..4.39 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
138. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m9_loan_application_idx on ba_y2019m9 ba_92 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
139. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m10_loan_application_idx on ba_y2019m10 ba_93 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
140. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m11_loan_application_idx on ba_y2019m11 ba_94 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
141. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m12_loan_application_idx on ba_y2019m12 ba_95 (cost=0.12..4.14 rows=1 width=154) (actual rows= loops=)

  • Filter: ((ba_eff IS NOT NULL) AND (ba_creation_day >= $3) AND ((la_initiator_type)::text = 'CUSTOMER'::text))
142. 0.000 0.000 ↓ 0.0

Hash (cost=1,551,021.12..1,551,021.12 rows=12,303,825 width=32) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Seq Scan on la_info la1 (cost=0.00..1,551,021.12 rows=12,303,825 width=32) (actual rows= loops=)

144.          

CTE bas_ranked_ba_eff

145. 0.000 0.000 ↓ 0.0

WindowAgg (cost=22,942,715,520.56..23,506,899,604.92 rows=25,074,848,194 width=444) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Sort (cost=22,942,715,520.56..23,005,402,641.04 rows=25,074,848,194 width=424) (actual rows= loops=)

  • Sort Key: raw_ba_eff.loan_application, raw_ba_eff.ba_eff
147. 0.000 0.000 ↓ 0.0

WindowAgg (cost=11,316,383,283.10..11,755,193,126.49 rows=25,074,848,194 width=424) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Sort (cost=11,316,383,283.10..11,379,070,403.58 rows=25,074,848,194 width=416) (actual rows= loops=)

  • Sort Key: raw_ba_eff.account_id, raw_ba_eff.return_no, raw_ba_eff.ba_eff
149. 0.000 0.000 ↓ 0.0

Merge Join (cost=539,696.30..251,296,669.03 rows=25,074,848,194 width=416) (actual rows= loops=)

  • Merge Cond: (new_cs_data.ba_id = raw_ba_eff.ba_id)
150. 0.000 0.000 ↓ 0.0

Sort (cost=192,788.39..197,033.78 rows=1,698,158 width=258) (actual rows= loops=)

  • Sort Key: new_cs_data.ba_id
151. 0.000 0.000 ↓ 0.0

CTE Scan on new_cs_data (cost=0.00..17,066.91 rows=1,698,158 width=258) (actual rows= loops=)

  • Filter: (cs_user_id IS NOT NULL)
152. 0.000 0.000 ↓ 0.0

Sort (cost=346,907.91..354,290.86 rows=2,953,182 width=166) (actual rows= loops=)

  • Sort Key: raw_ba_eff.ba_id
153. 0.000 0.000 ↓ 0.0

CTE Scan on raw_ba_eff (cost=0.00..29,531.82 rows=2,953,182 width=166) (actual rows= loops=)

154.          

CTE bas_system_ranked_capped_3

155. 0.000 0.000 ↓ 0.0

CTE Scan on bas_ranked_ba_eff (cost=0.00..314,062,473.63 rows=125,374,241 width=452) (actual rows= loops=)

  • Filter: ((cs_user_id)::text = 'system'::text)
156.          

CTE cs_postal_sendouts

157. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=79,539,302,044.92..5,729,892,788,811,544.00 rows=95,496,881,133,922,208 width=435) (actual rows= loops=)

  • Merge Cond: (bas_system_ranked_capped_3.ba_id = ba_96.ba_id)
158.          

Initplan (forMerge Right Join)

159. 0.000 0.000 ↓ 0.0

CTE Scan on params params_2 (cost=0.00..0.01 rows=1 width=4) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Sort (cost=18,117,622.02..18,431,057.62 rows=125,374,241 width=24) (actual rows= loops=)

  • Sort Key: bas_system_ranked_capped_3.ba_id
161. 0.000 0.000 ↓ 0.0

CTE Scan on bas_system_ranked_capped_3 (cost=0.00..1,253,742.41 rows=125,374,241 width=24) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Materialize (cost=79,521,184,422.89..80,282,879,013.20 rows=152,338,918,062 width=413) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Sort (cost=79,521,184,422.89..79,902,031,718.05 rows=152,338,918,062 width=413) (actual rows= loops=)

  • Sort Key: ba_96.ba_id
164. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,574,241.19..10,314,047,275.87 rows=152,338,918,062 width=413) (actual rows= loops=)

  • Hash Cond: ((((ba_96.brokerage_ba_id)::character varying)::text = (p2m.ext_ref_id)::text) AND ((new_cs_data_1.cs_user_id)::text = (p2m.user_id)::text))
165. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=20,452,956.13..1,934,300,081.16 rows=152,338,918,062 width=362) (actual rows= loops=)

  • Merge Cond: (ba_96.ba_id = new_cs_data_1.ba_id)
  • Filter: ((ba_96.ba_applied = 1) OR (new_cs_data_1.cs_user_id IS NOT NULL))
166. 0.000 0.000 ↓ 0.0

Sort (cost=20,259,223.06..20,304,076.11 rows=17,941,220 width=112) (actual rows= loops=)

  • Sort Key: ba_96.ba_id
167. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,835,873.19..18,097,595.38 rows=17,941,220 width=112) (actual rows= loops=)

  • Hash Cond: (ba_96.ba_id = bem.kredit_privat_id)
168. 0.000 0.000 ↓ 0.0

Append (cost=0.12..12,660,245.42 rows=17,941,220 width=103) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m1_ba_id_idx on ba_y2012m1 ba_96 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
170. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m2_ba_id_idx on ba_y2012m2 ba_97 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
171. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m3_ba_id_idx on ba_y2012m3 ba_98 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
172. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m4_ba_id_idx on ba_y2012m4 ba_99 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
173. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m5_ba_creation_day_idx on ba_y2012m5 ba_100 (cost=0.29..900.22 rows=4,111 width=142) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
174. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m6_ba_creation_day_idx on ba_y2012m6 ba_101 (cost=0.29..1,362.50 rows=6,247 width=137) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
175. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m7_ba_creation_day_idx on ba_y2012m7 ba_102 (cost=0.29..1,665.78 rows=7,640 width=135) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
176. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m8_ba_creation_day_idx on ba_y2012m8 ba_103 (cost=0.29..2,099.64 rows=9,630 width=136) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
177. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m9_ba_creation_day_idx on ba_y2012m9 ba_104 (cost=0.29..3,576.45 rows=16,523 width=133) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
178. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m10_ba_creation_day_idx on ba_y2012m10 ba_105 (cost=0.29..3,679.98 rows=17,049 width=132) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
179. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m11_ba_creation_day_idx on ba_y2012m11 ba_106 (cost=0.29..3,564.92 rows=16,513 width=132) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
180. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2012m12_ba_creation_day_idx on ba_y2012m12 ba_107 (cost=0.29..3,759.08 rows=17,471 width=131) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
181. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m1_ba_creation_day_idx on ba_y2013m1 ba_108 (cost=0.29..6,676.26 rows=30,797 width=129) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
182. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m2_ba_creation_day_idx on ba_y2013m2 ba_109 (cost=0.29..5,814.43 rows=26,789 width=130) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
183. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m3_ba_creation_day_idx on ba_y2013m3 ba_110 (cost=0.29..5,817.63 rows=26,759 width=130) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
184. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m4_ba_creation_day_idx on ba_y2013m4 ba_111 (cost=0.29..6,108.55 rows=27,984 width=131) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
185. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m5_ba_creation_day_idx on ba_y2013m5 ba_112 (cost=0.29..6,800.53 rows=31,122 width=130) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
186. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m6_ba_creation_day_idx on ba_y2013m6 ba_113 (cost=0.29..7,392.88 rows=33,763 width=130) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
187. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m7_ba_creation_day_idx on ba_y2013m7 ba_114 (cost=0.42..9,366.08 rows=42,478 width=106) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
188. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m8_ba_creation_day_idx on ba_y2013m8 ba_115 (cost=0.42..11,338.15 rows=51,191 width=105) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
189. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m9_ba_creation_day_idx on ba_y2013m9 ba_116 (cost=0.42..10,644.83 rows=47,845 width=105) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
190. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m10_ba_creation_day_idx on ba_y2013m10 ba_117 (cost=0.42..10,448.02 rows=46,958 width=105) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
191. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m11_ba_creation_day_idx on ba_y2013m11 ba_118 (cost=0.42..9,464.12 rows=42,423 width=106) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
192. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2013m12_ba_creation_day_idx on ba_y2013m12 ba_119 (cost=0.29..6,230.87 rows=28,021 width=105) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
193. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m1_ba_creation_day_idx on ba_y2014m1 ba_120 (cost=0.42..10,912.77 rows=48,727 width=105) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
194. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m2_ba_creation_day_idx on ba_y2014m2 ba_121 (cost=0.42..10,320.62 rows=46,216 width=106) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
195. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m3_ba_creation_day_idx on ba_y2014m3 ba_122 (cost=0.42..11,303.42 rows=50,696 width=106) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
196. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m4_ba_creation_day_idx on ba_y2014m4 ba_123 (cost=0.42..12,578.00 rows=55,909 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
197. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m5_ba_creation_day_idx on ba_y2014m5 ba_124 (cost=0.42..13,797.69 rows=60,841 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
198. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m6_ba_creation_day_idx on ba_y2014m6 ba_125 (cost=0.42..14,053.94 rows=61,814 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
199. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m7_ba_creation_day_idx on ba_y2014m7 ba_126 (cost=0.42..17,816.16 rows=78,181 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
200. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m8_ba_creation_day_idx on ba_y2014m8 ba_127 (cost=0.42..15,554.41 rows=65,097 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
201. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m9_ba_creation_day_idx on ba_y2014m9 ba_128 (cost=0.42..18,671.65 rows=77,392 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
202. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m10_ba_creation_day_idx on ba_y2014m10 ba_129 (cost=0.42..18,711.61 rows=77,485 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
203. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m11_ba_creation_day_idx on ba_y2014m11 ba_130 (cost=0.42..16,125.39 rows=71,939 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
204. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2014m12_ba_creation_day_idx on ba_y2014m12 ba_131 (cost=0.42..15,332.67 rows=68,786 width=109) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
205. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m1_ba_creation_day_idx on ba_y2015m1 ba_132 (cost=0.42..26,290.69 rows=117,846 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
206. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m2_ba_creation_day_idx on ba_y2015m2 ba_133 (cost=0.42..22,742.58 rows=101,677 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
207. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m3_ba_creation_day_idx on ba_y2015m3 ba_134 (cost=0.42..28,014.63 rows=125,442 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
208. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m4_ba_creation_day_idx on ba_y2015m4 ba_135 (cost=0.42..26,333.70 rows=115,503 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
209. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m5_ba_creation_day_idx on ba_y2015m5 ba_136 (cost=0.42..30,075.13 rows=132,839 width=109) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
210. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m6_ba_creation_day_idx on ba_y2015m6 ba_137 (cost=0.42..34,785.89 rows=152,744 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
211. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m7_ba_creation_day_idx on ba_y2015m7 ba_138 (cost=0.42..43,901.17 rows=180,426 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
212. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m8_ba_creation_day_idx on ba_y2015m8 ba_139 (cost=0.42..32,320.08 rows=133,844 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
213. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m9_ba_creation_day_idx on ba_y2015m9 ba_140 (cost=0.42..37,845.65 rows=157,474 width=109) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
214. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m10_ba_creation_day_idx on ba_y2015m10 ba_141 (cost=0.42..41,116.01 rows=169,131 width=108) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
215. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m11_ba_creation_day_idx on ba_y2015m11 ba_142 (cost=0.42..42,249.45 rows=175,654 width=109) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
216. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2015m12_ba_creation_day_idx on ba_y2015m12 ba_143 (cost=0.42..34,920.07 rows=145,382 width=109) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
217. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m1_ba_creation_day_idx on ba_y2016m1 ba_144 (cost=0.42..53,560.19 rows=234,529 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
218. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m2_ba_creation_day_idx on ba_y2016m2 ba_145 (cost=0.42..52,320.60 rows=233,608 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
219. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m3_ba_creation_day_idx on ba_y2016m3 ba_146 (cost=0.42..41,753.94 rows=186,188 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
220. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m4_ba_creation_day_idx on ba_y2016m4 ba_147 (cost=0.42..43,226.47 rows=191,908 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
221. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m5_ba_creation_day_idx on ba_y2016m5 ba_148 (cost=0.42..42,909.64 rows=183,668 width=107) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
222. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m6_ba_creation_day_idx on ba_y2016m6 ba_149 (cost=0.42..48,168.80 rows=208,168 width=101) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
223. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2016m7_ba_creation_day_idx on ba_y2016m7 ba_150 (cost=0.42..50,657.34 rows=217,539 width=103) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
224. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m8 ba_151 (cost=3,482.64..145,272.83 rows=235,383 width=103) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
225. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m8_ba_creation_day_idx (cost=0.00..3,423.80 rows=235,383 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
226. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m9 ba_152 (cost=3,406.55..143,417.84 rows=230,984 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
227. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m9_ba_creation_day_idx (cost=0.00..3,348.81 rows=230,984 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
228. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m10 ba_153 (cost=3,669.36..155,133.87 rows=249,153 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
229. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m10_ba_creation_day_idx (cost=0.00..3,607.07 rows=249,153 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
230. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m11 ba_154 (cost=3,779.47..158,847.51 rows=256,651 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
231. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m11_ba_creation_day_idx (cost=0.00..3,715.31 rows=256,651 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
232. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2016m12 ba_155 (cost=3,312.08..139,788.45 rows=224,471 width=103) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
233. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2016m12_ba_creation_day_idx (cost=0.00..3,255.96 rows=224,471 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
234. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m1 ba_156 (cost=5,366.87..227,241.16 rows=363,670 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
235. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m1_ba_creation_day_idx (cost=0.00..5,275.95 rows=363,670 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
236. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m2 ba_157 (cost=6,295.53..253,919.47 rows=339,756 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
237. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m2_ba_creation_day_idx (cost=0.00..6,210.60 rows=339,756 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
238. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m3 ba_158 (cost=10,361.69..420,968.78 rows=449,970 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
239. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m3_ba_creation_day_idx (cost=0.00..10,249.20 rows=449,970 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
240. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m4_ba_creation_day_idx on ba_y2017m4 ba_159 (cost=0.42..275,069.69 rows=345,951 width=101) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
241. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m5 ba_160 (cost=13,391.95..555,503.67 rows=554,777 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
242. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m5_ba_creation_day_idx (cost=0.00..13,253.25 rows=554,777 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
243. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m6 ba_161 (cost=12,625.93..445,154.99 rows=420,839 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
244. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m6_ba_creation_day_idx (cost=0.00..12,520.72 rows=420,839 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
245. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m7_ba_creation_day_idx on ba_y2017m7 ba_162 (cost=0.43..584,320.61 rows=1,024,863 width=100) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
246. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m8 ba_163 (cost=11,984.90..482,851.45 rows=481,867 width=102) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
247. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m8_ba_creation_day_idx (cost=0.00..11,864.43 rows=481,867 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
248. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m9_ba_creation_day_idx on ba_y2017m9 ba_164 (cost=0.42..112,380.41 rows=207,151 width=101) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
249. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2017m10_ba_creation_day_idx on ba_y2017m10 ba_165 (cost=0.42..118,915.64 rows=217,278 width=101) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
250. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m11 ba_166 (cost=5,918.63..233,405.09 rows=232,801 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
251. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m11_ba_creation_day_idx (cost=0.00..5,860.43 rows=232,801 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
252. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2017m12 ba_167 (cost=4,941.85..191,225.62 rows=190,636 width=100) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
253. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2017m12_ba_creation_day_idx (cost=0.00..4,894.20 rows=190,636 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
254. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m1 ba_168 (cost=10,874.52..419,155.30 rows=417,819 width=104) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
255. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m1_ba_creation_day_idx (cost=0.00..10,770.07 rows=417,819 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
256. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m2 ba_169 (cost=11,964.54..463,368.65 rows=461,950 width=104) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
257. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m2_ba_creation_day_idx (cost=0.00..11,849.05 rows=461,950 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
258. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m3_ba_creation_day_idx on ba_y2018m3 ba_170 (cost=0.43..286,054.40 rows=529,861 width=104) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
259. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m4 ba_171 (cost=9,321.53..360,989.35 rows=359,884 width=104) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
260. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m4_ba_creation_day_idx (cost=0.00..9,231.56 rows=359,884 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
261. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m5_ba_creation_day_idx on ba_y2018m5 ba_172 (cost=0.43..205,604.28 rows=379,754 width=103) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
262. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m6_ba_creation_day_idx on ba_y2018m6 ba_173 (cost=0.43..218,017.79 rows=387,496 width=103) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
263. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m7_ba_creation_day_idx on ba_y2018m7 ba_174 (cost=0.43..222,047.80 rows=409,837 width=102) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
264. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m8_ba_creation_day_idx on ba_y2018m8 ba_175 (cost=0.43..220,414.97 rows=406,372 width=102) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
265. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m9_ba_creation_day_idx on ba_y2018m9 ba_176 (cost=0.43..227,724.93 rows=420,203 width=103) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
266. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2018m10_ba_creation_day_idx on ba_y2018m10 ba_177 (cost=0.43..220,124.14 rows=408,129 width=103) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
267. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m11 ba_178 (cost=8,867.42..359,513.59 rows=358,838 width=103) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
268. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m11_ba_creation_day_idx (cost=0.00..8,777.71 rows=358,838 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
269. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2018m12 ba_179 (cost=6,703.70..208,439.87 rows=159,649 width=100) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
270. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2018m12_ba_creation_day_idx (cost=0.00..6,663.79 rows=159,649 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
271. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m1 ba_180 (cost=13,094.25..409,273.54 rows=313,526 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
272. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m1_ba_creation_day_idx (cost=0.00..13,015.87 rows=313,526 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
273. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m2 ba_181 (cost=49,465.47..1,546,092.24 rows=1,184,392 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
274. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m2_ba_creation_day_idx (cost=0.00..49,169.37 rows=1,184,392 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
275. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m3 ba_182 (cost=14,823.50..461,099.98 rows=353,171 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
276. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m3_ba_creation_day_idx (cost=0.00..14,735.21 rows=353,171 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
277. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m4 ba_183 (cost=11,515.05..358,257.66 rows=274,403 width=101) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
278. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m4_ba_creation_day_idx (cost=0.00..11,446.45 rows=274,403 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
279. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ba_y2019m5 ba_184 (cost=13,668.39..423,241.15 rows=324,125 width=100) (actual rows= loops=)

  • Recheck Cond: (ba_creation_day >= $7)
280. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ba_y2019m5_ba_creation_day_idx (cost=0.00..13,587.36 rows=324,125 width=0) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
281. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m6_ba_creation_day_idx on ba_y2019m6 ba_185 (cost=0.42..337,432.54 rows=307,633 width=100) (actual rows= loops=)

  • Index Cond: (ba_creation_day >= $7)
282. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m7_ba_id_idx on ba_y2019m7 ba_186 (cost=0.38..4.39 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
283. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m8_ba_id_idx on ba_y2019m8 ba_187 (cost=0.38..4.39 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
284. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m9_ba_id_idx on ba_y2019m9 ba_188 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
285. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m10_ba_id_idx on ba_y2019m10 ba_189 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
286. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m11_ba_id_idx on ba_y2019m11 ba_190 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
287. 0.000 0.000 ↓ 0.0

Index Scan using ba_y2019m12_ba_id_idx on ba_y2019m12 ba_191 (cost=0.12..4.14 rows=1 width=462) (actual rows= loops=)

  • Filter: (ba_creation_day >= $7)
288. 0.000 0.000 ↓ 0.0

Hash (cost=2,012,431.23..2,012,431.23 rows=109,792,245 width=16) (actual rows= loops=)

289. 0.000 0.000 ↓ 0.0

Seq Scan on brokerage_entity_map bem (cost=0.00..2,012,431.23 rows=109,792,245 width=16) (actual rows= loops=)

290. 0.000 0.000 ↓ 0.0

Sort (cost=193,733.07..197,999.80 rows=1,706,691 width=258) (actual rows= loops=)

  • Sort Key: new_cs_data_1.ba_id
291. 0.000 0.000 ↓ 0.0

CTE Scan on new_cs_data new_cs_data_1 (cost=0.00..17,066.91 rows=1,706,691 width=258) (actual rows= loops=)

292. 0.000 0.000 ↓ 0.0

Hash (cost=101,872.00..101,872.00 rows=1,941,306 width=76) (actual rows= loops=)

293. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=68,693.32..101,872.00 rows=1,941,306 width=76) (actual rows= loops=)

  • Hash Cond: (cs.container_id = p2m.id)
294. 0.000 0.000 ↓ 0.0

Seq Scan on computer_share cs (cost=0.00..28,396.64 rows=1,821,727 width=14) (actual rows= loops=)

295. 0.000 0.000 ↓ 0.0

Hash (cost=54,133.53..54,133.53 rows=1,941,306 width=74) (actual rows= loops=)

296. 0.000 0.000 ↓ 0.0

Seq Scan on print_to_mail p2m (cost=0.00..54,133.53 rows=1,941,306 width=74) (actual rows= loops=)