explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3JgR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15.271 837,051.965 ↑ 54.0 1 1

Gather (cost=1,000.00..55,700,332.66 rows=54 width=8) (actual time=837,046.226..837,051.965 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.047 837,036.694 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..55,699,327.26 rows=54 width=8) (actual time=825,619.624..837,036.694 rows=0 loops=3)

3. 71,479.904 71,479.904 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ca_mco_prd (cost=0.00..4,823,898.31 rows=1 width=8) (actual time=214,439.712..214,439.712 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 79,045,398
4. 65,281.906 65,281.906 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_fl_mco_prd (cost=0.00..4,470,214.39 rows=1 width=8) (actual time=195,845.719..195,845.719 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 73,321,502
5. 63,122.916 63,122.916 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_tx_mco_prd (cost=0.00..3,771,341.67 rows=1 width=8) (actual time=189,368.747..189,368.747 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 61,915,235
6. 54,073.057 54,073.057 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ny_mco_prd (cost=0.00..3,613,190.08 rows=1 width=8) (actual time=162,219.172..162,219.172 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 59,372,761
7. 37,269.010 37,269.010 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_il_mco_prd (cost=0.00..2,457,973.71 rows=1 width=8) (actual time=111,807.031..111,807.031 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 40,266,443
8. 33,770.955 33,770.955 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_pa_mco_prd (cost=0.00..2,304,488.59 rows=1 width=9) (actual time=101,312.864..101,312.864 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 37,731,887
9. 37,085.757 37,085.757 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nj_mco_prd (cost=0.00..2,222,422.29 rows=1 width=8) (actual time=111,257.272..111,257.272 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 36,473,827
10. 26,464.480 26,464.480 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_oh_mco_prd (cost=0.00..1,912,887.94 rows=1 width=8) (actual time=79,393.439..79,393.439 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 31,453,223
11. 28,409.429 28,409.429 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nc_mco_prd (cost=0.00..1,897,129.81 rows=1 width=8) (actual time=85,228.288..85,228.288 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 31,185,751
12. 26,394.455 26,394.455 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_mi_mco_prd (cost=0.00..1,749,034.15 rows=1 width=8) (actual time=79,183.366..79,183.366 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 28,764,759
13. 24,959.942 24,959.942 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_va_mco_prd (cost=0.00..1,687,629.41 rows=1 width=8) (actual time=74,879.826..74,879.827 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 27,631,763
14. 23,516.410 23,516.410 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ga_mco_prd (cost=0.00..1,605,247.35 rows=1 width=8) (actual time=70,549.231..70,549.231 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 26,369,303
15. 23,728.076 23,728.076 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ma_mco_prd (cost=0.00..1,520,913.53 rows=1 width=8) (actual time=71,184.227..71,184.227 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 24,969,259
16. 20,292.345 20,292.345 ↑ 1.0 1 1 / 3

Parallel Seq Scan on pb_header_md_mco_prd (cost=0.00..1,346,395.33 rows=1 width=8) (actual time=55,265.210..60,877.036 rows=1 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 22,069,261
17. 18,490.851 18,490.851 ↓ 0.0 0 3 / 3

Parallel Seq Scan on pb_header_tn_mco_prd (cost=0.00..1,271,391.21 rows=1 width=8) (actual time=18,490.851..18,490.851 rows=0 loops=3)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 6,970,281
18. 17,936.640 17,936.640 ↓ 0.0 0 2 / 3

Parallel Seq Scan on pb_header_in_mco_prd (cost=0.00..1,213,609.81 rows=1 width=8) (actual time=26,904.960..26,904.960 rows=0 loops=2)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 9,955,885
19. 17,131.216 17,131.216 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_az_mco_prd (cost=0.00..1,209,647.61 rows=1 width=8) (actual time=51,393.648..51,393.648 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 19,859,325
20. 16,656.512 16,656.512 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_sc_mco_prd (cost=0.00..1,149,048.26 rows=1 width=8) (actual time=49,969.537..49,969.537 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 18,886,905
21. 15,877.402 15,877.402 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_mo_mco_prd (cost=0.00..1,052,903.79 rows=1 width=8) (actual time=47,632.207..47,632.207 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 17,303,833
22. 15,494.960 15,494.960 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_wa_mco_prd (cost=0.00..1,041,663.24 rows=1 width=8) (actual time=46,484.881..46,484.881 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 17,134,107
23. 16,253.762 16,253.762 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ky_mco_prd (cost=0.00..931,073.17 rows=1 width=8) (actual time=48,761.287..48,761.287 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 15,311,482
24. 13,101.942 13,101.942 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_al_mco_prd (cost=0.00..918,884.56 rows=1 width=8) (actual time=39,305.827..39,305.827 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 15,097,475
25. 12,525.626 12,525.626 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_wi_mco_prd (cost=0.00..871,013.32 rows=1 width=8) (actual time=37,576.877..37,576.877 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 14,297,635
26. 13,313.534 13,313.534 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_la_mco_prd (cost=0.00..795,274.51 rows=1 width=8) (actual time=39,940.603..39,940.603 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 13,070,129
27. 11,805.208 11,805.208 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ok_mco_prd (cost=0.00..793,253.97 rows=1 width=8) (actual time=35,415.623..35,415.623 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 12,945,513
28. 8,927.390 8,927.390 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ms_mco_prd (cost=0.00..686,087.30 rows=1 width=8) (actual time=26,782.170..26,782.170 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 11,266,687
29. 8,608.566 8,608.566 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ct_mco_prd (cost=0.00..681,967.56 rows=1 width=8) (actual time=25,825.698..25,825.698 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 11,214,130
30. 9,165.264 9,165.264 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_co_mco_prd (cost=0.00..679,910.83 rows=1 width=8) (actual time=27,495.790..27,495.791 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 11,174,258
31. 10,571.731 10,571.731 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ar_mco_prd (cost=0.00..673,296.58 rows=1 width=8) (actual time=31,715.192..31,715.192 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 11,004,026
32. 10,321.276 10,321.276 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ia_mco_prd (cost=0.00..609,508.16 rows=1 width=8) (actual time=30,963.829..30,963.829 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 10,002,735
33. 7,529.966 7,529.966 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ks_mco_prd (cost=0.00..584,641.05 rows=1 width=8) (actual time=22,589.897..22,589.897 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 9,578,642
34. 7,593.659 7,593.659 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_mn_mco_prd (cost=0.00..538,383.09 rows=1 width=8) (actual time=22,780.978..22,780.978 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 8,828,154
35. 7,514.641 7,514.641 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_or_mco_prd (cost=0.00..475,551.85 rows=1 width=8) (actual time=22,543.923..22,543.923 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 7,815,789
36. 6,601.802 6,601.802 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nv_mco_prd (cost=0.00..460,504.34 rows=1 width=8) (actual time=19,805.405..19,805.405 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 7,573,498
37. 5,338.430 5,338.430 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_wv_mco_prd (cost=0.00..391,828.64 rows=1 width=8) (actual time=16,015.290..16,015.290 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 6,412,274
38. 4,969.638 4,969.638 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ne_mco_prd (cost=0.00..358,648.21 rows=1 width=8) (actual time=14,908.913..14,908.913 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 5,878,952
39. 4,361.308 4,361.308 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nm_mco_prd (cost=0.00..290,829.11 rows=1 width=8) (actual time=13,083.925..13,083.925 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 4,776,410
40. 4,441.113 4,441.113 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_de_mco_prd (cost=0.00..288,939.22 rows=1 width=8) (actual time=13,323.338..13,323.338 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 4,696,544
41. 5,103.713 5,103.713 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nh_mco_prd (cost=0.00..287,745.68 rows=1 width=8) (actual time=15,311.140..15,311.140 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 4,726,826
42. 4,022.819 4,022.819 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ut_mco_prd (cost=0.00..274,363.78 rows=1 width=8) (actual time=12,068.457..12,068.457 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 4,513,484
43. 3,449.895 3,449.895 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_me_mco_prd (cost=0.00..240,503.65 rows=1 width=8) (actual time=10,349.684..10,349.684 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 3,947,928
44. 3,202.255 3,202.255 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_id_mco_prd (cost=0.00..224,530.43 rows=1 width=8) (actual time=9,606.764..9,606.764 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 3,691,883
45. 3,120.761 3,120.761 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_mt_mco_prd (cost=0.00..169,632.05 rows=1 width=8) (actual time=9,362.284..9,362.284 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,790,383
46. 2,402.746 2,402.746 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ri_mco_prd (cost=0.00..165,685.46 rows=1 width=8) (actual time=7,208.239..7,208.239 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,720,690
47. 2,609.097 2,609.097 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_sd_mco_prd (cost=0.00..153,061.97 rows=1 width=8) (actual time=7,827.292..7,827.292 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,497,410
48. 2,180.290 2,180.290 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_hi_mco_prd (cost=0.00..151,391.29 rows=1 width=8) (actual time=6,540.871..6,540.871 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,487,749
49. 2,538.666 2,538.666 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_nd_mco_prd (cost=0.00..127,097.83 rows=1 width=8) (actual time=7,615.999..7,615.999 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,085,198
50. 1,768.109 1,768.109 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_vt_mco_prd (cost=0.00..124,119.18 rows=1 width=8) (actual time=5,304.327..5,304.327 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 2,036,551
51. 1,638.234 1,638.234 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_wy_mco_prd (cost=0.00..114,179.98 rows=1 width=9) (actual time=4,914.703..4,914.703 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 1,876,390
52. 1,518.177 1,518.177 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_dc_mco_prd (cost=0.00..104,403.97 rows=1 width=8) (actual time=4,554.530..4,554.530 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 1,715,826
53. 1,420.095 1,420.095 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ak_mco_prd (cost=0.00..97,065.03 rows=1 width=8) (actual time=4,260.285..4,260.285 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 1,595,989
54. 1,072.050 1,072.050 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_pr_mco_prd (cost=0.00..74,635.28 rows=1 width=8) (actual time=3,216.149..3,216.149 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 1,226,620
55. 356.720 356.720 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_ao_mco_prd (cost=0.00..23,197.36 rows=1 width=8) (actual time=1,070.161..1,070.161 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 380,579
56. 251.938 251.938 ↓ 0.0 0 1 / 3

Parallel Seq Scan on pb_header_vi_mco_prd (cost=0.00..17,088.10 rows=1 width=8) (actual time=755.814..755.814 rows=0 loops=1)

  • Filter: (dsy_vw_rec_lnk_num = '212006431383'::numeric)
  • Rows Removed by Filter: 280,937
Planning time : 39.242 ms
Execution time : 837,052.394 ms