explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oJrl

Settings
# 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)

  • Buffers: shared hit=28791519 read=868544 dirtied=1945 written=11096
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)

  • Buffers: shared hit=28791519 read=868544 dirtied=1945 written=11096
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)

  • Merge Cond: (l.id = l_1.id)
  • Buffers: shared hit=28789068 read=868251 dirtied=1912 written=11096
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)

  • Sort Key: l.id
  • Sort Method: quicksort Memory: 87207kB
  • Buffers: shared hit=8312989 read=819457 dirtied=1390 written=11096
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)

  • Buffers: shared hit=8312989 read=819457 dirtied=1390 written=11096
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)

  • Join Filter: (asm.id = cpa.account_status_master_id)
  • Rows Removed by Join Filter: 815172
  • Buffers: shared hit=7948914 read=817206 dirtied=1389 written=11069
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)

  • Hash Cond: (cpa.product_family_id = pf.id)
  • Buffers: shared hit=7948914 read=817205 dirtied=1389 written=11069
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)

  • Buffers: shared hit=7948913 read=817205 dirtied=1389 written=11069
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)

  • Buffers: shared hit=7475723 read=817199 dirtied=1389 written=11069
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)

  • Buffers: shared hit=5951855 read=817088 dirtied=1389 written=11069
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)

  • Buffers: shared hit=5162655 read=817088 dirtied=1389 written=11069
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)

  • Buffers: shared hit=3042036 read=139132 dirtied=1386 written=1684
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)

  • Buffers: shared hit=3012488 read=139130 dirtied=1386 written=1684
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)

  • Buffers: shared hit=2381433 read=138876 dirtied=1386 written=1684
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)

  • Buffers: shared hit=1751502 read=137704 dirtied=1386 written=1664
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)

  • Buffers: shared hit=1436008 read=137704 dirtied=1386 written=1664
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)

  • Buffers: shared hit=931125 read=11481 dirtied=240 written=125
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)

  • Buffers: shared hit=776173 read=10906 dirtied=240 written=117
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)

  • Hash Cond: (l.allocated_to = iu.id)
  • Buffers: shared hit=150295 read=5752 written=7
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)

  • Hash Cond: (l.product_status_id = ps.id)
  • Buffers: shared hit=150233 read=5752 written=7
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)

  • Hash Cond: (l.crm_status_id = cs.id)
  • Buffers: shared hit=150205 read=5752 written=7
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)

  • Buffers: shared hit=150200 read=5752 written=7
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
  • Buffers: shared hit=5
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)

  • Buffers: shared hit=5
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)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 69kB
  • Buffers: shared hit=28
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)

  • Buffers: shared hit=28
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)

  • Buckets: 4096 Batches: 1 Memory Usage: 141kB
  • Buffers: shared hit=62
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)

  • Buffers: shared hit=62
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)

  • Index Cond: (id = l.user_lender_account_id)
  • Buffers: shared hit=625878 read=5154 dirtied=240 written=110
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)

  • Index Cond: (id = ula.user_lender_payment_plan_id)
  • Buffers: shared hit=154952 read=575 written=8
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)

  • Index Cond: (user_id = l.user_id)
  • Buffers: shared hit=504883 read=126223 dirtied=1146 written=1539
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)

  • Index Cond: (id = l.tblfacilitystatus_id)
  • Buffers: shared hit=315494
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)

  • Index Cond: (id = l.user_service_order_id)
  • Buffers: shared hit=629931 read=1172 written=20
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)

  • Index Cond: (id = uso.order_payment_id)
  • Buffers: shared hit=631055 read=254
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)

  • Index Cond: (id = l.lead_priority_id)
  • Buffers: shared hit=29548 read=2
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)

  • Buffers: shared hit=2120619 read=677956 dirtied=3 written=9385
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)

  • Index Cond: (customer_profile_account_id = $14)
  • Buffers: shared hit=712754 read=76866 written=1000
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)

  • Index Cond: ((account_no)::text = ($15)::text)
  • Filter: (created_on <= o.payment_date)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1407865 read=601090 dirtied=3 written=8385
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)

  • Index Cond: (customer_profile_account_id = ula.report_account_id)
  • Buffers: shared hit=789200
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)

  • Buffers: shared hit=1523868 read=111
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)

  • Recheck Cond: ((product_family_id = cpa.product_family_id) AND (account_status_id = cpa.account_status_master_id) AND (lender_id = cpa.lender_id))
  • Heap Blocks: exact=108429
  • Buffers: shared hit=1523868 read=111
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)

  • Buffers: shared hit=1415488 read=62
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)

  • Index Cond: (product_family_id = cpa.product_family_id)
  • Buffers: shared hit=485641 read=19
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)

  • Index Cond: (account_status_id = cpa.account_status_master_id)
  • Buffers: shared hit=468843 read=22
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)

  • Index Cond: (lender_id = cpa.lender_id)
  • Buffers: shared hit=461004 read=21
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)

  • Index Cond: (id = cpa.lender_id)
  • Buffers: shared hit=473190 read=6
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=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)

  • Buffers: shared hit=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)

  • Buffers: shared read=1
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)

  • Buffers: shared read=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)

  • Buffers: shared hit=364075 read=2251 dirtied=1 written=27
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)

  • Index Cond: (lender_account_id = ula.id)
  • Filter: (is_active = 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=364075 read=2251 dirtied=1 written=27
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)

  • Buffers: shared hit=20476079 read=48794 dirtied=522
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)

  • Buffers: shared read=5 dirtied=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)

  • Buffers: shared read=5 dirtied=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)

  • Index Cond: (modified_ts IS NOT NULL)
  • Heap Fetches: 1
  • Buffers: shared read=5 dirtied=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)

  • Merge Cond: (l_1.id = ll.lead_id)
  • Buffers: shared hit=20476079 read=48794 dirtied=522
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)

  • Heap Fetches: 16340533
  • Buffers: shared hit=20425921 read=48788 dirtied=521
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)

  • Buffers: shared hit=50158 read=6 dirtied=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)

  • Sort Key: ll.lead_id
  • Sort Method: quicksort Memory: 8986kB
  • Buffers: shared hit=50158 read=6 dirtied=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)

  • Hash Cond: (ll.lead_log_type_id = llt.id)
  • Buffers: shared hit=50154 read=6 dirtied=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)

  • Index Cond: (updated_at >= ($24 - '03:00:00'::interval))
  • Buffers: shared hit=50153 read=6 dirtied=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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=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)

  • Buffers: shared hit=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)

  • Buffers: shared hit=525 read=181
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)

  • Hash Cond: (ll_1.product_status_id = ps_1.id)
  • Buffers: shared hit=525 read=181
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)

  • Buffers: shared hit=497 read=181
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)

  • Index Cond: (id = l.id)
  • Heap Fetches: 28
  • Buffers: shared hit=164
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)

  • Hash Cond: (ll_1.lead_log_type_id = llt_1.id)
  • Buffers: shared hit=333 read=181
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)

  • Index Cond: (lead_id = l.id)
  • Buffers: shared hit=332 read=181
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=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)

  • Buffers: shared hit=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)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 69kB
  • Buffers: shared hit=28
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)

  • Buffers: shared hit=28
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)

  • Buffers: shared hit=277 read=22 dirtied=13
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)

  • Index Cond: (user_id = l.user_id)
  • Filter: ((user_lender_account_id IS NULL) AND (user_bureau_dispute_id IS NULL) AND (user_service_order_id = uso.id))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=263 read=22
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)

  • Buffers: shared hit=229 read=22 dirtied=20
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)

  • Index Cond: (user_id = l.user_id)
  • Buffers: shared hit=229 read=22 dirtied=20
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)

  • Buffers: shared hit=238
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)

  • Index Cond: (user_id = l.user_id)
  • Buffers: shared hit=238
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)

  • Buffers: shared hit=513
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)

  • Index Cond: (lead_id = l.id)
  • Filter: (lead_log_type_id = ANY ('{5,8}'::integer[]))
  • Rows Removed by Filter: 10
  • Buffers: shared hit=513
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)

  • Buffers: shared hit=513
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)

  • Index Cond: (lead_id = l.id)
  • Filter: ((source = 'CRM'::lead_logs_source_type) AND (lead_log_type_id = 1) AND (updated_by <> ALL ('{7777,8888,9999}'::integer[])))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=513
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)

  • Index Cond: ((account_no)::text = (cpa.account_no)::text)
  • Filter: ((lender_id = cpa.lender_id) AND ((base_type)::text = 'lenderbase'::text))
  • Buffers: shared hit=37 read=47
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)

  • Filter: ((base_type)::text = 'lenderbase'::text)
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)

  • Index Cond: (user_id = l.user_id)
  • Heap Fetches: 0
  • Buffers: shared hit=63 read=21
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)

  • Heap Fetches: 0