explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dDtE

Settings
# exclusive inclusive rows x rows loops node
1. 27,675.377 281,948.395 ↑ 2.0 34,927 1

Gather (cost=2,743.17..59,901,678.82 rows=68,878 width=50) (actual time=274,036.397..281,948.395 rows=34,927 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 22,150.488 254,273.018 ↑ 2.5 11,642 3 / 3

Hash Join (cost=1,743.17..59,893,791.02 rows=28,699 width=50) (actual time=245,913.357..254,273.018 rows=11,642 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,713.026 232,104.168 ↑ 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.195..232,104.168 rows=164,212,363 loops=3)

4. 43,040.076 43,040.076 ↓ 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.006..129,120.228 rows=89,487,730 loops=1)

5. 21,120.461 21,120.461 ↓ 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.023..63,361.383 rows=42,552,765 loops=1)

6. 14,313.250 14,313.250 ↓ 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=1.732..42,939.751 rows=28,986,110 loops=1)

7. 10,494.639 10,494.639 ↓ 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=6.284..31,483.917 rows=20,590,216 loops=1)

8. 9,148.012 9,148.012 ↓ 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=2.177..27,444.037 rows=18,113,647 loops=1)

9. 9,017.063 9,017.063 ↓ 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=1.257..27,051.189 rows=18,794,187 loops=1)

10. 10,152.787 10,152.787 ↑ 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=1.031..10,152.787 rows=4,984,948 loops=3)

11. 5,066.235 5,066.235 ↓ 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=1.842..15,198.706 rows=14,575,438 loops=1)

12. 4,648.071 4,648.071 ↓ 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=1.225..13,944.212 rows=14,412,773 loops=1)

13. 4,459.335 4,459.335 ↓ 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=2.410..13,378.004 rows=14,601,987 loops=1)

14. 4,467.370 4,467.370 ↓ 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=1.092..13,402.109 rows=13,693,802 loops=1)

15. 4,137.852 4,137.852 ↓ 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=1.150..12,413.557 rows=12,624,694 loops=1)

16. 4,420.979 4,420.979 ↓ 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=1.465..6,631.468 rows=5,791,855 loops=2)

17. 3,577.912 3,577.912 ↓ 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=1.048..10,733.735 rows=12,945,407 loops=1)

18. 3,690.140 3,690.140 ↓ 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=1.005..11,070.421 rows=10,900,284 loops=1)

19. 3,630.477 3,630.477 ↓ 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=1.018..10,891.432 rows=12,046,555 loops=1)

20. 3,484.060 3,484.060 ↓ 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=1.108..10,452.181 rows=10,120,171 loops=1)

21. 2,793.074 2,793.074 ↓ 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=1.092..8,379.221 rows=8,680,996 loops=1)

22. 2,996.272 2,996.272 ↓ 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=1.238..8,988.815 rows=8,230,054 loops=1)

23. 4,142.864 4,142.864 ↓ 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=1.202..12,428.591 rows=8,307,495 loops=1)

24. 3,885.248 3,885.248 ↓ 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=2.342..11,655.745 rows=7,971,813 loops=1)

25. 3,769.232 3,769.232 ↓ 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=3.465..11,307.696 rows=7,726,526 loops=1)

26. 3,763.138 3,763.138 ↓ 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=1.049..11,289.413 rows=7,527,685 loops=1)

27. 3,366.368 3,366.368 ↓ 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=1.428..10,099.104 rows=6,614,762 loops=1)

28. 3,147.286 3,147.286 ↓ 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=3.071..9,441.859 rows=6,427,840 loops=1)

29. 3,047.868 3,047.868 ↓ 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=1.988..9,143.603 rows=5,957,215 loops=1)

30. 2,817.461 2,817.461 ↓ 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=1.215..8,452.383 rows=5,849,503 loops=1)

31. 2,417.192 2,417.192 ↓ 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=3.298..7,251.575 rows=5,522,617 loops=1)

32. 2,385.812 2,385.812 ↓ 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.837..7,157.436 rows=5,020,252 loops=1)

33. 2,091.646 2,091.646 ↓ 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=2.554..6,274.939 rows=4,408,996 loops=1)

34. 1,868.999 1,868.999 ↓ 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.937..5,606.998 rows=4,000,653 loops=1)

35. 1,823.537 1,823.537 ↓ 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.614..5,470.612 rows=3,916,471 loops=1)

36. 1,809.123 1,809.123 ↓ 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.772..5,427.370 rows=3,754,333 loops=1)

37. 1,798.444 1,798.444 ↓ 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.591..5,395.333 rows=3,634,413 loops=1)

38. 1,543.243 1,543.243 ↓ 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.638..4,629.730 rows=3,246,329 loops=1)

39. 1,406.583 1,406.583 ↓ 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.648..4,219.750 rows=2,954,611 loops=1)

40. 1,377.691 1,377.691 ↓ 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.667..4,133.072 rows=3,371,512 loops=1)

41. 1,293.763 1,293.763 ↓ 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.559..3,881.289 rows=2,828,695 loops=1)

42. 1,165.180 1,165.180 ↓ 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=1.012..3,495.540 rows=2,580,893 loops=1)

43. 769.385 769.385 ↓ 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.619..2,308.155 rows=1,687,262 loops=1)

44. 712.976 712.976 ↓ 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=2.888..2,138.927 rows=1,729,471 loops=1)

45. 697.808 697.808 ↓ 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=0.643..2,093.424 rows=1,420,822 loops=1)

46. 671.618 671.618 ↓ 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.447..2,014.853 rows=1,412,630 loops=1)

47. 596.620 596.620 ↓ 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.627..1,789.860 rows=1,110,607 loops=1)

48. 569.586 569.586 ↓ 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.578..1,708.757 rows=1,375,636 loops=1)

49. 492.743 492.743 ↓ 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.734..1,478.229 rows=1,074,851 loops=1)

50. 446.236 446.236 ↓ 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=2.018..1,338.708 rows=852,995 loops=1)

51. 284.884 284.884 ↓ 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.613..854.653 rows=657,723 loops=1)

52. 245.879 245.879 ↓ 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.572..737.638 rows=705,662 loops=1)

53. 214.569 214.569 ↓ 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.651..643.706 rows=686,420 loops=1)

54. 110.095 110.095 ↓ 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.554..330.284 rows=405,028 loops=1)

55. 0.136 18.362 ↑ 1.1 312 3 / 3

Hash (cost=1,737.13..1,737.13 rows=345 width=59) (actual time=18.362..18.362 rows=312 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
56. 0.155 18.226 ↑ 1.1 312 3 / 3

Hash Join (cost=161.19..1,737.13 rows=345 width=59) (actual time=5.664..18.226 rows=312 loops=3)

  • Hash Cond: (b.seller = lm.lender)
57. 15.468 15.468 ↓ 1.2 395 3 / 3

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

  • Index Cond: (cusip = '3140QBCM8'::text)
  • Filter: (tpoflag = ANY ('{B,R}'::text[]))
  • Rows Removed by Filter: 84
58. 1.063 2.603 ↑ 1.0 4,819 3 / 3

Hash (cost=99.17..99.17 rows=4,917 width=50) (actual time=2.603..2.603 rows=4,819 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 453kB
59. 1.540 1.540 ↑ 1.0 4,819 3 / 3

Seq Scan on lender_map2 lm (cost=0.00..99.17 rows=4,917 width=50) (actual time=0.240..1.540 rows=4,819 loops=3)

Planning time : 8.979 ms
Execution time : 281,951.467 ms