# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 409,970.649 | 409,970.649 | ↓ 1.8 | 28 | 1 |
→
CTE Scan on dbt_incr_sbq (cost=16,642,969.98..16,642,970.30 rows=16 width=3,818) (actual time=377,829.933..409,970.649 rows=28 loops=1)
|
2. |
CTE dbt_incr_sbq |
|||||
3. | 2.924 | 409,970.470 | ↓ 1.8 | 28 | 1 |
→
Nested Loop Left Join (cost=14,044,107.16..16,642,969.98 rows=16 width=498) (actual time=377,829.926..409,970.470 rows=28 loops=1)
|
4. | 89.643 | 409,850.170 | ↓ 1.8 | 28 | 1 |
→
Merge Join (cost=14,044,020.07..16,640,129.68 rows=16 width=448) (actual time=377,818.391..409,850.170 rows=28 loops=1)
|
5. | 514.143 | 368,063.279 | ↓ 9,859.2 | 157,748 | 1 |
→
Sort (cost=8,920.70..8,920.74 rows=16 width=448) (actual time=367,979.727..368,063.279 rows=157,748 loops=1)
|
6. | 379.590 | 367,549.136 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=213.21..8,920.38 rows=16 width=448) (actual time=21.097..367,549.136 rows=157,748 loops=1)
|
7. | 688.665 | 365,592.066 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=210.48..8,876.22 rows=16 width=384) (actual time=18.862..365,592.066 rows=157,748 loops=1)
|
8. | 262.060 | 364,430.157 | ↓ 9,859.2 | 157,748 | 1 |
→
Hash Left Join (cost=210.48..8,830.87 rows=16 width=388) (actual time=18.311..364,430.157 rows=157,748 loops=1)
|
9. | 362.660 | 364,167.997 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=208.54..8,828.73 rows=16 width=388) (actual time=18.190..364,167.997 rows=157,748 loops=1)
|
10. | 440.045 | 363,332.093 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=208.26..8,801.18 rows=16 width=361) (actual time=18.169..363,332.093 rows=157,748 loops=1)
|
11. | 422.002 | 354,058.160 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=194.72..8,564.73 rows=16 width=357) (actual time=11.644..354,058.160 rows=157,748 loops=1)
|
12. | 505.003 | 352,847.418 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=194.15..8,520.12 rows=16 width=277) (actual time=11.621..352,847.418 rows=157,748 loops=1)
|
13. | 249.568 | 56,091.671 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=180.85..8,306.80 rows=16 width=269) (actual time=8.431..56,091.671 rows=157,748 loops=1)
|
14. | 394.914 | 55,684.355 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=180.70..8,282.99 rows=16 width=241) (actual time=8.421..55,684.355 rows=157,748 loops=1)
|
15. | 346.641 | 54,500.701 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=180.28..8,251.25 rows=16 width=241) (actual time=8.387..54,500.701 rows=157,748 loops=1)
|
16. | 385.429 | 53,049.824 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=179.86..8,215.28 rows=16 width=229) (actual time=7.981..53,049.824 rows=157,748 loops=1)
|
17. | 301.543 | 52,348.899 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop (cost=179.72..8,203.09 rows=16 width=205) (actual time=7.961..52,348.899 rows=157,748 loops=1)
|
18. | 337.060 | 5,353.948 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop Left Join (cost=179.28..8,157.84 rows=16 width=186) (actual time=7.507..5,353.948 rows=157,748 loops=1)
|
19. | 424.405 | 4,543.644 | ↓ 9,859.2 | 157,748 | 1 |
→
Nested Loop (cost=178.86..8,126.15 rows=16 width=143) (actual time=7.493..4,543.644 rows=157,748 loops=1)
|
20. | 215.479 | 1,595.271 | ↓ 60.1 | 157,748 | 1 |
→
Hash Left Join (cost=178.44..2,240.99 rows=2,623 width=112) (actual time=6.693..1,595.271 rows=157,748 loops=1)
|
21. | 205.720 | 1,376.126 | ↓ 60.1 | 157,748 | 1 |
→
Hash Left Join (cost=63.68..2,093.12 rows=2,623 width=108) (actual time=3.000..1,376.126 rows=157,748 loops=1)
|
22. | 293.077 | 1,168.944 | ↓ 60.1 | 157,748 | 1 |
→
Hash Left Join (cost=12.73..2,009.06 rows=2,623 width=103) (actual time=1.521..1,168.944 rows=157,748 loops=1)
|
23. | 875.292 | 875.292 | ↓ 60.1 | 157,748 | 1 |
→
Index Scan using idx_coll_leads on leads l (cost=0.42..1,963.70 rows=2,623 width=100) (actual time=0.930..875.292 rows=157,748 loops=1)
|
24. | 0.259 | 0.575 | ↓ 1.2 | 381 | 1 |
→
Hash (cost=8.25..8.25 rows=325 width=23) (actual time=0.575..0.575 rows=381 loops=1)
|
25. | 0.316 | 0.316 | ↓ 1.2 | 381 | 1 |
→
Seq Scan on crm_status cs (cost=0.00..8.25 rows=325 width=23) (actual time=0.010..0.316 rows=381 loops=1)
|
26. | 0.647 | 1.462 | ↓ 1.1 | 1,146 | 1 |
→
Hash (cost=38.20..38.20 rows=1,020 width=13) (actual time=1.462..1.462 rows=1,146 loops=1)
|
27. | 0.815 | 0.815 | ↓ 1.1 | 1,146 | 1 |
→
Seq Scan on product_status ps (cost=0.00..38.20 rows=1,020 width=13) (actual time=0.016..0.815 rows=1,146 loops=1)
|
28. | 1.483 | 3.666 | ↑ 1.0 | 2,345 | 1 |
→
Hash (cost=85.45..85.45 rows=2,345 width=12) (actual time=3.666..3.666 rows=2,345 loops=1)
|
29. | 2.183 | 2.183 | ↑ 1.0 | 2,345 | 1 |
→
Seq Scan on internal_users iu (cost=0.00..85.45 rows=2,345 width=12) (actual time=0.007..2.183 rows=2,345 loops=1)
|
30. | 2,523.968 | 2,523.968 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using user_lender_accounts_pkey on user_lender_accounts ula (cost=0.42..2.24 rows=1 width=31) (actual time=0.016..0.016 rows=1 loops=157,748)
|
31. | 473.244 | 473.244 | ↓ 0.0 | 0 | 157,748 |
→
Index Scan using user_lender_payment_plans_pkey on user_lender_payment_plans ulpp (cost=0.42..1.98 rows=1 width=51) (actual time=0.003..0.003 rows=0 loops=157,748)
|
32. | 46,693.408 | 46,693.408 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using users_pkey on users u (cost=0.43..2.83 rows=1 width=27) (actual time=0.296..0.296 rows=1 loops=157,748)
|
33. | 315.496 | 315.496 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using tblfacilitystatus_pkey on tblfacilitystatus tfs (cost=0.14..0.76 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=157,748)
|
34. | 1,104.236 | 1,104.236 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using user_service_orders_pkey on user_service_orders uso (cost=0.42..2.25 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=157,748)
|
35. | 788.740 | 788.740 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using orders_pkey on orders o (cost=0.42..1.98 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=157,748)
|
36. | 157.748 | 157.748 | ↓ 0.0 | 0 | 157,748 |
→
Index Scan using lead_priorities_pkey on lead_priorities lp (cost=0.15..1.49 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=157,748)
|
37. | 946.488 | 296,250.744 | ↑ 1.0 | 1 | 157,748 |
→
Aggregate (cost=13.30..13.31 rows=1 width=8) (actual time=1.878..1.878 rows=1 loops=157,748)
|
38. |
Initplan (forAggregate) |
|||||
39. | 37,544.024 | 37,544.024 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using customer_profile_accounts_pkey on customer_profile_accounts customer_profile_accounts_1 (cost=0.57..2.99 rows=1 width=28) (actual time=0.237..0.238 rows=1 loops=157,748)
|
40. | 257,760.232 | 257,760.232 | ↑ 1.0 | 2 | 157,748 |
→
Index Scan using idx_account_no_cpa on customer_profile_accounts (cost=0.57..10.31 rows=2 width=8) (actual time=1.187..1.634 rows=2 loops=157,748)
|
41. | 788.740 | 788.740 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using customer_profile_accounts_pkey on customer_profile_accounts cpa (cost=0.57..2.79 rows=1 width=88) (actual time=0.005..0.005 rows=1 loops=157,748)
|
42. | 315.496 | 8,833.888 | ↑ 1.0 | 1 | 157,748 |
→
Limit (cost=13.54..14.76 rows=1 width=4) (actual time=0.056..0.056 rows=1 loops=157,748)
|
43. | 630.992 | 8,518.392 | ↑ 1.0 | 1 | 157,748 |
→
Bitmap Heap Scan on lender_account_status las (cost=13.54..14.76 rows=1 width=4) (actual time=0.054..0.054 rows=1 loops=157,748)
|
44. | 1,135.604 | 7,887.400 | ↓ 0.0 | 0 | 157,748 |
→
BitmapAnd (cost=13.54..13.54 rows=1 width=0) (actual time=0.050..0.050 rows=0 loops=157,748)
|
45. | 2,997.212 | 2,997.212 | ↓ 1.4 | 378 | 157,748 |
→
Bitmap Index Scan on idx_las_product_family_id (cost=0.00..3.45 rows=262 width=0) (actual time=0.019..0.019 rows=378 loops=157,748)
|
46. | 1,883.880 | 1,883.880 | ↓ 1.0 | 242 | 156,990 |
→
Bitmap Index Scan on idx_las_account_status_id (cost=0.00..4.47 rows=239 width=0) (actual time=0.012..0.012 rows=242 loops=156,990)
|
47. | 1,870.704 | 1,870.704 | ↑ 1.2 | 261 | 155,892 |
→
Bitmap Index Scan on idx_las_lender_id (cost=0.00..5.11 rows=324 width=0) (actual time=0.012..0.012 rows=261 loops=155,892)
|
48. | 473.244 | 473.244 | ↑ 1.0 | 1 | 157,748 |
→
Index Scan using lenders_pkey on lenders len (cost=0.28..1.72 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=157,748)
|
49. | 0.041 | 0.100 | ↓ 1.2 | 49 | 1 |
→
Hash (cost=1.42..1.42 rows=42 width=8) (actual time=0.100..0.100 rows=49 loops=1)
|
50. | 0.059 | 0.059 | ↓ 1.2 | 49 | 1 |
→
Seq Scan on product_families pf (cost=0.00..1.42 rows=42 width=8) (actual time=0.010..0.059 rows=49 loops=1)
|
51. | 472.709 | 473.244 | ↑ 23.3 | 6 | 157,748 |
→
Materialize (cost=0.00..12.10 rows=140 width=4) (actual time=0.001..0.003 rows=6 loops=157,748)
|
52. | 0.535 | 0.535 | ↑ 23.3 | 6 | 1 |
→
Seq Scan on account_status_master asm (cost=0.00..11.40 rows=140 width=4) (actual time=0.530..0.535 rows=6 loops=1)
|
53. | 473.244 | 1,577.480 | ↑ 1.0 | 1 | 157,748 |
→
Aggregate (cost=2.73..2.74 rows=1 width=72) (actual time=0.009..0.010 rows=1 loops=157,748)
|
54. | 1,104.236 | 1,104.236 | ↓ 0.0 | 0 | 157,748 |
→
Index Scan using idx_lai_ulap on user_lender_account_payments (cost=0.29..2.71 rows=1 width=22) (actual time=0.007..0.007 rows=0 loops=157,748)
|
55. | 68.046 | 41,697.248 | ↑ 632.2 | 41,470 | 1 |
→
Unique (cost=14,035,099.36..16,303,505.01 rows=26,216,298 width=8) (actual time=1,112.230..41,697.248 rows=41,470 loops=1)
|
56. |
Initplan (forUnique) |
|||||
57. | 0.004 | 1.738 | ↑ 1.0 | 1 | 1 |
→
Result (cost=0.45..0.46 rows=1 width=8) (actual time=1.738..1.738 rows=1 loops=1)
|
58. |
Initplan (forResult) |
|||||
59. | 0.001 | 1.734 | ↑ 1.0 | 1 | 1 |
→
Limit (cost=0.42..0.45 rows=1 width=8) (actual time=1.734..1.734 rows=1 loops=1)
|
60. | 1.733 | 1.733 | ↑ 182,549.0 | 1 | 1 |
→
Index Only Scan Backward using collections_leads__index_on_modified_ts on collections_leads (cost=0.42..5,645.03 rows=182,549 width=8) (actual time=1.733..1.733 rows=1 loops=1)
|
61. | 10,471.578 | 41,627.464 | ↑ 571.7 | 125,228 | 1 |
→
Merge Join (cost=14,035,098.90..16,124,536.54 rows=71,587,203 width=8) (actual time=1,112.228..41,627.464 rows=125,228 loops=1)
|
62. | 30,728.952 | 30,728.952 | ↓ 1.0 | 26,226,808 | 1 |
→
Index Only Scan using leads_pkey on leads l_1 (cost=0.56..900,185.07 rows=26,216,298 width=8) (actual time=0.048..30,728.952 rows=26,226,808 loops=1)
|
63. | 97.694 | 426.934 | ↑ 571.7 | 125,228 | 1 |
→
Materialize (cost=14,035,090.07..14,393,026.08 rows=71,587,203 width=4) (actual time=270.591..426.934 rows=125,228 loops=1)
|
64. | 132.732 | 329.240 | ↑ 571.7 | 125,228 | 1 |
→
Sort (cost=14,035,090.07..14,214,058.07 rows=71,587,203 width=4) (actual time=270.587..329.240 rows=125,228 loops=1)
|
65. | 112.892 | 196.508 | ↑ 567.5 | 126,153 | 1 |
→
Hash Join (cost=1.91..4,108,154.82 rows=71,587,203 width=4) (actual time=2.285..196.508 rows=126,153 loops=1)
|
66. | 83.581 | 83.581 | ↑ 605.3 | 126,153 | 1 |
→
Index Scan using idx_updated_at_ll on lead_logs ll (cost=0.57..3,186,468.24 rows=76,359,683 width=28) (actual time=2.238..83.581 rows=126,153 loops=1)
|
67. | 0.014 | 0.035 | ↓ 1.5 | 22 | 1 |
→
Hash (cost=1.15..1.15 rows=15 width=4) (actual time=0.035..0.035 rows=22 loops=1)
|
68. | 0.021 | 0.021 | ↓ 1.5 | 22 | 1 |
→
Seq Scan on lead_log_types llt (cost=0.00..1.15 rows=15 width=4) (actual time=0.011..0.021 rows=22 loops=1)
|
69. | 0.896 | 69.328 | ↑ 1.0 | 1 | 28 |
→
Aggregate (cost=87.09..87.10 rows=1 width=16) (actual time=2.475..2.476 rows=1 loops=28)
|
70. | 0.557 | 68.432 | ↑ 2.9 | 15 | 28 |
→
Hash Left Join (cost=53.42..86.87 rows=43 width=17) (actual time=0.267..2.444 rows=15 loops=28)
|
71. | 0.448 | 66.752 | ↑ 2.9 | 15 | 28 |
→
Nested Loop (cost=2.47..35.38 rows=43 width=12) (actual time=0.223..2.384 rows=15 loops=28)
|
72. | 0.364 | 0.364 | ↑ 1.0 | 1 | 28 |
→
Index Only Scan using leads_pkey on leads l_2 (cost=0.56..2.98 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=28)
|
73. | 0.640 | 65.940 | ↑ 2.9 | 15 | 28 |
→
Hash Join (cost=1.91..31.97 rows=43 width=16) (actual time=0.207..2.355 rows=15 loops=28)
|
74. | 65.268 | 65.268 | ↑ 3.1 | 15 | 28 |
→
Index Scan using idx_lead_id_lead_logs on lead_logs ll_1 (cost=0.57..30.08 rows=46 width=36) (actual time=0.201..2.331 rows=15 loops=28)
|
75. | 0.014 | 0.032 | ↓ 1.5 | 22 | 1 |
→
Hash (cost=1.15..1.15 rows=15 width=4) (actual time=0.032..0.032 rows=22 loops=1)
|
76. | 0.018 | 0.018 | ↓ 1.5 | 22 | 1 |
→
Seq Scan on lead_log_types llt_1 (cost=0.00..1.15 rows=15 width=4) (actual time=0.008..0.018 rows=22 loops=1)
|
77. | 0.564 | 1.123 | ↓ 1.1 | 1,146 | 1 |
→
Hash (cost=38.20..38.20 rows=1,020 width=13) (actual time=1.123..1.123 rows=1,146 loops=1)
|
78. | 0.559 | 0.559 | ↓ 1.1 | 1,146 | 1 |
→
Seq Scan on product_status ps_1 (cost=0.00..38.20 rows=1,020 width=13) (actual time=0.007..0.559 rows=1,146 loops=1)
|
79. |
SubPlan (forNested Loop Left Join) |
|||||
80. | 0.112 | 6.636 | ↑ 1.0 | 1 | 28 |
→
Limit (cost=0.44..6.50 rows=1 width=8) (actual time=0.236..0.237 rows=1 loops=28)
|
81. | 6.524 | 6.524 | ↑ 1.0 | 1 | 28 |
→
Index Scan using idx_user_id_leads on leads (cost=0.44..6.50 rows=1 width=8) (actual time=0.233..0.233 rows=1 loops=28)
|
82. | 0.280 | 8.904 | ↑ 1.0 | 1 | 28 |
→
Aggregate (cost=8.59..8.60 rows=1 width=8) (actual time=0.318..0.318 rows=1 loops=28)
|
83. | 8.624 | 8.624 | ↑ 1.2 | 6 | 28 |
→
Index Scan using idx_user_id_customer_profiles on customer_profiles (cost=0.44..8.57 rows=7 width=8) (actual time=0.118..0.308 rows=6 loops=28)
|
84. | 0.224 | 0.448 | ↑ 1.0 | 1 | 28 |
→
Aggregate (cost=8.59..8.60 rows=1 width=8) (actual time=0.015..0.016 rows=1 loops=28)
|
85. | 0.224 | 0.224 | ↑ 1.2 | 6 | 28 |
→
Index Scan using idx_user_id_customer_profiles on customer_profiles customer_profiles_1 (cost=0.44..8.57 rows=7 width=8) (actual time=0.003..0.008 rows=6 loops=28)
|
86. | 0.168 | 0.672 | ↑ 1.0 | 1 | 28 |
→
Aggregate (cost=30.24..30.25 rows=1 width=8) (actual time=0.023..0.024 rows=1 loops=28)
|
87. | 0.504 | 0.504 | ↑ 3.4 | 5 | 28 |
→
Index Scan using idx_lead_id_lead_logs on lead_logs (cost=0.57..30.20 rows=17 width=8) (actual time=0.007..0.018 rows=5 loops=28)
|
88. | 0.196 | 0.616 | ↑ 1.0 | 1 | 28 |
→
Aggregate (cost=30.49..30.50 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=28)
|
89. | 0.420 | 0.420 | ↓ 5.0 | 10 | 28 |
→
Index Scan using idx_lead_id_lead_logs on lead_logs lead_logs_1 (cost=0.57..30.48 rows=2 width=8) (actual time=0.005..0.015 rows=10 loops=28)
|
90. | 22.092 | 22.092 | ↓ 0.0 | 0 | 28 |
→
Index Scan using idx_account_no_lb on lender_bases lb (cost=0.42..2.85 rows=1 width=0) (actual time=0.789..0.789 rows=0 loops=28)
|
91. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on lender_bases lb_1 (cost=0.00..36,855.79 rows=608,490 width=36) (never executed)
|
|
92. | 8.680 | 8.680 | ↓ 0.0 | 0 | 28 |
→
Index Only Scan using idx_user_id_dnd_users on dnd_users (cost=0.42..2.83 rows=1 width=0) (actual time=0.310..0.310 rows=0 loops=28)
|
93. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Only Scan using idx_user_id_dnd_users on dnd_users dnd_users_1 (cost=0.42..2,420.95 rows=79,371 width=8) (never executed)
|