explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C8LO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 26,802.880 281,388.365 ↑ 3.0 22,979 1

Gather (cost=2,739.40..59,901,688.49 rows=69,007 width=53) (actual time=273,778.458..281,388.365 rows=22,979 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 22,465.804 254,585.485 ↑ 3.8 7,660 3 / 3

Hash Join (cost=1,739.40..59,893,787.79 rows=28,753 width=53) (actual time=246,506.257..254,585.485 rows=7,660 loops=3)

  • Hash Cond: ((r_4.state = b.state) AND (r_4.mortgage_amount_rounded = b.origloanamt) AND (r_4.lender_standard = lm.standard))
3. 12,733.398 232,116.291 ↑ 1.3 164,212,363 3 / 3

Parallel Append (cost=0.00..23,508,355.98 rows=206,430,666 width=37) (actual time=0.591..232,116.291 rows=164,212,363 loops=3)

4. 43,348.707 43,348.707 ↓ 2.4 89,487,730 1 / 3

Parallel Seq Scan on recorder_ca r_4 (cost=0.00..4,071,372.39 rows=37,647,839 width=39) (actual time=0.497..130,046.122 rows=89,487,730 loops=1)

5. 21,361.882 21,361.882 ↓ 2.4 42,552,765 1 / 3

Parallel Seq Scan on recorder_fl r_8 (cost=0.00..1,992,307.10 rows=17,802,010 width=37) (actual time=0.644..64,085.647 rows=42,552,765 loops=1)

6. 14,171.397 14,171.397 ↓ 2.4 28,986,110 1 / 3

Parallel Seq Scan on recorder_tx r_42 (cost=0.00..1,316,794.50 rows=12,091,550 width=37) (actual time=0.661..42,514.192 rows=28,986,110 loops=1)

7. 10,316.756 10,316.756 ↓ 2.4 20,590,216 1 / 3

Parallel Seq Scan on recorder_il r_13 (cost=0.00..957,714.99 rows=8,604,299 width=37) (actual time=1.446..30,950.267 rows=20,590,216 loops=1)

8. 9,251.068 9,251.068 ↓ 2.4 18,113,647 1 / 3

Parallel Seq Scan on recorder_oh r_34 (cost=0.00..853,637.09 rows=7,633,909 width=36) (actual time=0.477..27,753.205 rows=18,113,647 loops=1)

9. 8,940.267 8,940.267 ↓ 2.4 18,794,187 1 / 3

Parallel Seq Scan on recorder_az r_3 (cost=0.00..827,580.29 rows=7,858,529 width=40) (actual time=0.454..26,820.802 rows=18,794,187 loops=1)

10. 9,854.120 9,854.120 ↑ 1.3 4,984,948 3 / 3

Parallel Seq Scan on recorder_ny r_33 (cost=0.00..701,799.74 rows=6,261,474 width=39) (actual time=0.923..9,854.120 rows=4,984,948 loops=3)

11. 5,410.187 5,410.187 ↓ 2.4 14,575,438 1 / 3

Parallel Seq Scan on recorder_pa r_37 (cost=0.00..700,753.92 rows=6,148,992 width=37) (actual time=0.700..16,230.561 rows=14,575,438 loops=1)

12. 4,570.410 4,570.410 ↓ 2.4 14,412,773 1 / 3

Parallel Seq Scan on recorder_wa r_46 (cost=0.00..672,480.70 rows=6,026,870 width=39) (actual time=0.673..13,711.230 rows=14,412,773 loops=1)

13. 4,412.523 4,412.523 ↓ 2.4 14,601,987 1 / 3

Parallel Seq Scan on recorder_ga r_9 (cost=0.00..641,845.90 rows=6,103,390 width=36) (actual time=0.568..13,237.568 rows=14,601,987 loops=1)

14. 4,459.394 4,459.394 ↓ 2.4 13,693,802 1 / 3

Parallel Seq Scan on recorder_mi r_21 (cost=0.00..638,090.94 rows=5,716,394 width=35) (actual time=0.577..13,378.183 rows=13,693,802 loops=1)

15. 4,111.107 4,111.107 ↓ 2.4 12,624,694 1 / 3

Parallel Seq Scan on recorder_nc r_26 (cost=0.00..596,449.57 rows=5,345,558 width=39) (actual time=0.641..12,333.321 rows=12,624,694 loops=1)

16. 4,269.022 4,269.022 ↓ 1.2 5,791,855 2 / 3

Parallel Seq Scan on recorder_co r_5 (cost=0.00..549,450.75 rows=4,852,775 width=37) (actual time=0.781..6,403.533 rows=5,791,855 loops=2)

17. 3,619.481 3,619.481 ↓ 2.4 12,945,407 1 / 3

Parallel Seq Scan on recorder_ma r_18 (cost=0.00..535,371.57 rows=5,415,258 width=36) (actual time=0.648..10,858.444 rows=12,945,407 loops=1)

18. 3,684.571 3,684.571 ↓ 2.4 10,900,284 1 / 3

Parallel Seq Scan on recorder_nj r_30 (cost=0.00..526,957.28 rows=4,565,628 width=38) (actual time=0.589..11,053.714 rows=10,900,284 loops=1)

19. 3,639.320 3,639.320 ↓ 2.4 12,046,555 1 / 3

Parallel Seq Scan on recorder_tn r_41 (cost=0.00..525,983.88 rows=5,033,388 width=34) (actual time=0.504..10,917.959 rows=12,046,555 loops=1)

20. 3,367.406 3,367.406 ↓ 2.4 10,120,171 1 / 3

Parallel Seq Scan on recorder_md r_19 (cost=0.00..493,637.48 rows=4,224,048 width=38) (actual time=0.568..10,102.217 rows=10,120,171 loops=1)

21. 2,836.264 2,836.264 ↓ 2.4 8,680,996 1 / 3

Parallel Seq Scan on recorder_mo r_23 (cost=0.00..403,037.52 rows=3,642,652 width=36) (actual time=0.521..8,508.791 rows=8,680,996 loops=1)

22. 3,421.374 3,421.374 ↓ 2.4 8,230,054 1 / 3

Parallel Seq Scan on recorder_va r_44 (cost=0.00..397,785.17 rows=3,441,518 width=37) (actual time=0.816..10,264.123 rows=8,230,054 loops=1)

23. 3,952.162 3,952.162 ↓ 2.4 8,307,495 1 / 3

Parallel Seq Scan on recorder_wi r_47 (cost=0.00..374,866.93 rows=3,467,093 width=37) (actual time=0.513..11,856.487 rows=8,307,495 loops=1)

24. 3,843.086 3,843.086 ↓ 2.4 7,971,813 1 / 3

Parallel Seq Scan on recorder_nv r_32 (cost=0.00..360,846.60 rows=3,336,860 width=38) (actual time=0.610..11,529.257 rows=7,971,813 loops=1)

25. 3,809.483 3,809.483 ↓ 2.4 7,726,526 1 / 3

Parallel Seq Scan on recorder_or r_36 (cost=0.00..353,495.69 rows=3,235,469 width=39) (actual time=0.795..11,428.448 rows=7,726,526 loops=1)

26. 3,727.102 3,727.102 ↓ 2.4 7,527,685 1 / 3

Parallel Seq Scan on recorder_in r_14 (cost=0.00..345,453.15 rows=3,142,815 width=35) (actual time=2.131..11,181.306 rows=7,527,685 loops=1)

27. 3,328.381 3,328.381 ↓ 2.4 6,614,762 1 / 3

Parallel Seq Scan on recorder_sc r_39 (cost=0.00..306,303.04 rows=2,761,504 width=36) (actual time=0.440..9,985.143 rows=6,614,762 loops=1)

28. 3,106.666 3,106.666 ↓ 2.4 6,427,840 1 / 3

Parallel Seq Scan on recorder_ut r_43 (cost=0.00..292,155.76 rows=2,690,976 width=40) (actual time=1.441..9,319.997 rows=6,427,840 loops=1)

29. 3,034.691 3,034.691 ↓ 2.4 5,957,215 1 / 3

Parallel Seq Scan on recorder_mn r_22 (cost=0.00..279,791.44 rows=2,489,744 width=38) (actual time=0.883..9,104.073 rows=5,957,215 loops=1)

30. 2,841.599 2,841.599 ↓ 2.4 5,849,503 1 / 3

Parallel Seq Scan on recorder_ok r_35 (cost=0.00..260,489.05 rows=2,476,305 width=33) (actual time=0.758..8,524.797 rows=5,849,503 loops=1)

31. 2,392.973 2,392.973 ↓ 2.4 5,522,617 1 / 3

Parallel Seq Scan on recorder_ct r_6 (cost=0.00..226,564.08 rows=2,308,308 width=35) (actual time=1.426..7,178.919 rows=5,522,617 loops=1)

32. 2,256.069 2,256.069 ↓ 2.4 5,020,252 1 / 3

Parallel Seq Scan on recorder_al r_1 (cost=0.00..215,693.33 rows=2,089,333 width=32) (actual time=1.984..6,768.207 rows=5,020,252 loops=1)

33. 2,058.381 2,058.381 ↓ 2.4 4,408,996 1 / 3

Parallel Seq Scan on recorder_ia r_11 (cost=0.00..189,199.04 rows=1,841,404 width=36) (actual time=0.651..6,175.142 rows=4,408,996 loops=1)

34. 1,892.922 1,892.922 ↓ 2.4 4,000,653 1 / 3

Parallel Seq Scan on recorder_ky r_16 (cost=0.00..177,435.92 rows=1,674,192 width=36) (actual time=0.629..5,678.767 rows=4,000,653 loops=1)

35. 1,862.594 1,862.594 ↓ 2.3 3,916,471 1 / 3

Parallel Seq Scan on recorder_ar r_2 (cost=0.00..173,850.50 rows=1,676,450 width=32) (actual time=0.416..5,587.781 rows=3,916,471 loops=1)

36. 1,793.280 1,793.280 ↓ 2.4 3,754,333 1 / 3

Parallel Seq Scan on recorder_hi r_10 (cost=0.00..166,371.09 rows=1,565,309 width=35) (actual time=0.486..5,379.840 rows=3,754,333 loops=1)

37. 1,762.720 1,762.720 ↓ 2.4 3,634,413 1 / 3

Parallel Seq Scan on recorder_la r_17 (cost=0.00..164,251.48 rows=1,514,148 width=34) (actual time=1.654..5,288.161 rows=3,634,413 loops=1)

38. 1,528.383 1,528.383 ↓ 2.4 3,246,329 1 / 3

Parallel Seq Scan on recorder_nm r_31 (cost=0.00..142,185.13 rows=1,359,013 width=37) (actual time=0.622..4,585.149 rows=3,246,329 loops=1)

39. 1,406.319 1,406.319 ↓ 2.4 2,954,611 1 / 3

Parallel Seq Scan on recorder_id r_12 (cost=0.00..128,609.92 rows=1,233,892 width=38) (actual time=0.495..4,218.957 rows=2,954,611 loops=1)

40. 1,382.161 1,382.161 ↓ 2.4 3,371,512 1 / 3

Parallel Seq Scan on recorder_ms r_24 (cost=0.00..127,978.74 rows=1,405,374 width=31) (actual time=0.795..4,146.482 rows=3,371,512 loops=1)

41. 1,269.915 1,269.915 ↓ 2.4 2,828,695 1 / 3

Parallel Seq Scan on recorder_ne r_28 (cost=0.00..118,155.11 rows=1,177,011 width=36) (actual time=0.617..3,809.745 rows=2,828,695 loops=1)

42. 1,185.864 1,185.864 ↓ 2.4 2,580,893 1 / 3

Parallel Seq Scan on recorder_ks r_15 (cost=0.00..107,889.05 rows=1,077,305 width=36) (actual time=2.164..3,557.591 rows=2,580,893 loops=1)

43. 754.790 754.790 ↓ 2.4 1,687,262 1 / 3

Parallel Seq Scan on recorder_ri r_38 (cost=0.00..71,159.63 rows=715,063 width=37) (actual time=0.717..2,264.369 rows=1,687,262 loops=1)

44. 843.409 843.409 ↓ 2.4 1,729,471 1 / 3

Parallel Seq Scan on recorder_me r_20 (cost=0.00..66,177.68 rows=723,668 width=36) (actual time=0.658..2,530.226 rows=1,729,471 loops=1)

45. 690.197 690.197 ↓ 2.4 1,420,822 1 / 3

Parallel Seq Scan on recorder_mt r_25 (cost=0.00..63,117.48 rows=592,748 width=35) (actual time=1.003..2,070.590 rows=1,420,822 loops=1)

46. 665.940 665.940 ↓ 2.4 1,412,630 1 / 3

Parallel Seq Scan on recorder_nh r_29 (cost=0.00..61,679.42 rows=592,242 width=36) (actual time=0.643..1,997.820 rows=1,412,630 loops=1)

47. 599.666 599.666 ↓ 2.4 1,110,607 1 / 3

Parallel Seq Scan on recorder_de r_7 (cost=0.00..54,391.55 rows=466,055 width=38) (actual time=0.647..1,798.998 rows=1,110,607 loops=1)

48. 559.133 559.133 ↓ 2.4 1,375,636 1 / 3

Parallel Seq Scan on recorder_wv r_48 (cost=0.00..51,840.64 rows=574,164 width=35) (actual time=0.621..1,677.399 rows=1,375,636 loops=1)

49. 501.680 501.680 ↓ 2.4 1,074,851 1 / 3

Parallel Seq Scan on recorder_nd r_27 (cost=0.00..45,099.74 rows=448,174 width=35) (actual time=0.758..1,505.039 rows=1,074,851 loops=1)

50. 447.638 447.638 ↓ 2.4 852,995 1 / 3

Parallel Seq Scan on recorder_ak r (cost=0.00..40,295.60 rows=355,860 width=40) (actual time=0.592..1,342.913 rows=852,995 loops=1)

51. 328.220 328.220 ↓ 2.4 657,723 1 / 3

Parallel Seq Scan on recorder_default r_50 (cost=0.00..34,835.94 rows=274,494 width=38) (actual time=0.772..984.660 rows=657,723 loops=1)

52. 207.563 207.563 ↓ 2.4 705,662 1 / 3

Parallel Seq Scan on recorder_wy r_49 (cost=0.00..29,774.35 rows=294,135 width=35) (actual time=0.662..622.689 rows=705,662 loops=1)

53. 177.875 177.875 ↓ 2.4 686,420 1 / 3

Parallel Seq Scan on recorder_sd r_40 (cost=0.00..27,855.69 rows=286,169 width=38) (actual time=0.607..533.625 rows=686,420 loops=1)

54. 126.777 126.777 ↓ 2.4 405,028 1 / 3

Parallel Seq Scan on recorder_vt r_45 (cost=0.00..15,339.08 rows=169,308 width=33) (actual time=0.630..380.330 rows=405,028 loops=1)

55. 0.136 3.390 ↑ 1.4 238 3 / 3

Hash (cost=1,733.41..1,733.41 rows=342 width=59) (actual time=3.390..3.390 rows=238 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 30kB
56. 0.154 3.254 ↑ 1.4 238 3 / 3

Hash Join (cost=157.93..1,733.41 rows=342 width=59) (actual time=2.846..3.254 rows=238 loops=3)

  • Hash Cond: (b.seller = lm.lender)
57. 0.957 0.957 ↓ 1.0 347 3 / 3

Index Scan using fnmloan_cusip on fnmloan b (cost=0.56..1,570.49 rows=341 width=58) (actual time=0.657..0.957 rows=347 loops=3)

  • Index Cond: (cusip = '3140Q83J2'::text)
  • Filter: (tpoflag = ANY ('{B,R}'::text[]))
  • Rows Removed by Filter: 50
58. 1.409 2.143 ↑ 1.0 4,772 3 / 3

Hash (cost=97.72..97.72 rows=4,772 width=50) (actual time=2.142..2.143 rows=4,772 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 449kB
59. 0.734 0.734 ↑ 1.0 4,772 3 / 3

Seq Scan on lender_map2 lm (cost=0.00..97.72 rows=4,772 width=50) (actual time=0.010..0.734 rows=4,772 loops=3)

Planning time : 6.816 ms
Execution time : 281,389.654 ms