explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tNWk

Settings
# exclusive inclusive rows x rows loops node
1. 498.904 15,512.890 ↓ 35.6 71,620 1

Sort (cost=6,025,363.10..6,025,368.13 rows=2,012 width=9,269) (actual time=15,500.937..15,512.890 rows=71,620 loops=1)

  • Sort Key: z.src_id, z.sort_chain_ids
  • Sort Method: quicksort Memory: 66162kB
2. 2,943.604 15,013.986 ↓ 35.6 71,620 1

Nested Loop Left Join (cost=25,979.04..6,025,252.69 rows=2,012 width=9,269) (actual time=10,074.544..15,013.986 rows=71,620 loops=1)

3. 175.211 12,070.382 ↓ 35.6 71,620 1

Hash Left Join (cost=25,957.01..27,854.72 rows=2,012 width=9,236) (actual time=10,074.417..12,070.382 rows=71,620 loops=1)

  • Hash Cond: ((z.sort_chain_ids[(array_length(z.sort_chain_ids, 1) - 3)] = tesc.tm_id) AND (z.sort_chain_ids[(array_length(z.sort_chain_ids, 1) - 2)] = tesc.esc_seq_num))
4. 113.619 11,895.171 ↓ 35.6 71,620 1

Hash Left Join (cost=25,769.13..27,248.91 rows=2,012 width=9,223) (actual time=10,072.247..11,895.171 rows=71,620 loops=1)

  • Hash Cond: (ghdrngs.date_rng_id = ghonetimedrng.date_rng_id)
5. 114.965 11,781.552 ↓ 35.6 71,620 1

Hash Left Join (cost=25,597.85..27,072.34 rows=2,012 width=9,215) (actual time=10,070.466..11,781.552 rows=71,620 loops=1)

  • Hash Cond: (ghdr.date_rule_id = ghdrngs.drngs_id)
6. 153.308 11,666.587 ↓ 35.6 71,620 1

Nested Loop Left Join (cost=25,449.85..26,913.65 rows=2,012 width=9,215) (actual time=10,069.269..11,666.587 rows=71,620 loops=1)

7. 116.160 11,513.279 ↓ 35.6 71,620 1

Hash Anti Join (cost=25,449.56..26,223.22 rows=2,012 width=8,016) (actual time=10,069.259..11,513.279 rows=71,620 loops=1)

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 117.500 11,397.119 ↓ 41.8 87,982 1

Hash Left Join (cost=20,230.04..20,959.91 rows=2,104 width=8,024) (actual time=10,065.865..11,397.119 rows=87,982 loops=1)

  • Hash Cond: (ghs.site_id = ghsh.site_id)
9. 124.003 11,279.619 ↓ 60.6 87,982 1

Hash Left Join (cost=20,180.18..20,832.78 rows=1,451 width=7,977) (actual time=10,065.834..11,279.619 rows=87,982 loops=1)

  • Hash Cond: (ghotz.tz_id = ghstz.tz_id)
10. 102.549 11,155.616 ↓ 60.6 87,982 1

Hash Left Join (cost=20,163.90..20,812.66 rows=1,451 width=7,969) (actual time=10,065.637..11,155.616 rows=87,982 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghotz.org_tz_id)
11. 118.611 11,053.067 ↓ 60.6 87,982 1

Hash Left Join (cost=20,156.47..20,801.34 rows=1,451 width=7,969) (actual time=10,065.540..11,053.067 rows=87,982 loops=1)

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
12. 113.183 10,934.456 ↓ 60.6 87,982 1

Hash Left Join (cost=20,140.18..20,781.21 rows=1,451 width=7,946) (actual time=10,065.322..10,934.456 rows=87,982 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghpsotz.org_tz_id)
13. 111.330 10,821.273 ↓ 60.6 87,982 1

Hash Left Join (cost=20,132.75..20,769.89 rows=1,451 width=7,938) (actual time=10,065.227..10,821.273 rows=87,982 loops=1)

  • Hash Cond: (g.site_id = ghs.site_id)
14. 186.481 10,709.943 ↓ 60.6 87,982 1

Nested Loop Left Join (cost=20,123.61..20,756.95 rows=1,451 width=7,922) (actual time=10,065.139..10,709.943 rows=87,982 loops=1)

15. 113.688 10,523.462 ↓ 60.6 87,982 1

Hash Left Join (cost=20,123.32..20,259.03 rows=1,451 width=6,731) (actual time=10,065.127..10,523.462 rows=87,982 loops=1)

  • Hash Cond: (otz.tz_id = stz.tz_id)
16. 120.684 10,409.774 ↓ 60.6 87,982 1

Hash Left Join (cost=20,107.04..20,238.90 rows=1,451 width=6,723) (actual time=10,064.926..10,409.774 rows=87,982 loops=1)

  • Hash Cond: (s.org_tz_id = otz.org_tz_id)
17. 224.901 10,289.090 ↓ 60.6 87,982 1

Hash Right Join (cost=20,099.61..20,227.59 rows=1,451 width=6,723) (actual time=10,064.823..10,289.090 rows=87,982 loops=1)

  • Hash Cond: (drngs.drngs_id = dr.date_rule_id)
18. 0.738 2.954 ↑ 1.0 3,299 1

Hash Left Join (cost=171.56..286.72 rows=3,299 width=24) (actual time=1.906..2.954 rows=3,299 loops=1)

  • Hash Cond: (drngs.date_rng_id = drng.date_rng_id)
19. 0.430 0.430 ↑ 1.0 3,299 1

Index Only Scan using drngs_rng_pk on drngs_rng drngs (cost=0.28..106.77 rows=3,299 width=16) (actual time=0.030..0.430 rows=3,299 loops=1)

  • Heap Fetches: 0
20. 0.909 1.786 ↓ 1.0 4,472 1

Hash (cost=115.57..115.57 rows=4,457 width=24) (actual time=1.786..1.786 rows=4,472 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 309kB
21. 0.877 0.877 ↓ 1.0 4,472 1

Seq Scan on date_rng drng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.018..0.877 rows=4,472 loops=1)

22. 147.763 10,061.235 ↓ 60.6 87,982 1

Hash (cost=19,909.91..19,909.91 rows=1,451 width=6,707) (actual time=10,061.235..10,061.235 rows=87,982 loops=1)

  • Buckets: 131072 (originally 2048) Batches: 1 (originally 1) Memory Usage: 46583kB
23. 124.456 9,913.472 ↓ 60.6 87,982 1

Merge Right Join (cost=19,888.02..19,909.91 rows=1,451 width=6,707) (actual time=9,778.976..9,913.472 rows=87,982 loops=1)

  • Merge Cond: (dr.date_rule_id = oh.date_rule_id)
24. 0.016 0.016 ↑ 105,343.0 1 1

Index Scan using date_rules_pk on date_rules dr (cost=0.42..6,212.26 rows=105,343 width=36) (actual time=0.016..0.016 rows=1 loops=1)

25. 332.080 9,789.000 ↓ 60.6 87,982 1

Sort (cost=16,418.24..16,421.87 rows=1,451 width=6,679) (actual time=9,778.949..9,789.000 rows=87,982 loops=1)

  • Sort Key: oh.date_rule_id
  • Sort Method: quicksort Memory: 82551kB
26. 97.816 9,456.920 ↓ 60.6 87,982 1

Hash Left Join (cost=2,316.95..16,342.04 rows=1,451 width=6,679) (actual time=1,052.346..9,456.920 rows=87,982 loops=1)

  • Hash Cond: (s.site_id = sh.site_id)
27. 99.195 9,359.104 ↓ 87.9 87,982 1

Hash Left Join (cost=2,298.45..16,270.24 rows=1,001 width=6,652) (actual time=1,052.326..9,359.104 rows=87,982 loops=1)

  • Hash Cond: (psotz.tz_id = pstz.tz_id)
28. 99.516 9,259.909 ↓ 87.9 87,982 1

Hash Left Join (cost=2,282.17..16,251.31 rows=1,001 width=6,629) (actual time=1,052.168..9,259.909 rows=87,982 loops=1)

  • Hash Cond: (s.org_tz_id = psotz.org_tz_id)
29. 95.767 9,160.393 ↓ 87.9 87,982 1

Hash Left Join (cost=2,274.73..16,241.20 rows=1,001 width=6,621) (actual time=1,052.098..9,160.393 rows=87,982 loops=1)

  • Hash Cond: (psol.language_id = psl.language_id)
30. 101.968 9,064.626 ↓ 87.9 87,982 1

Hash Left Join (cost=2,272.79..16,236.36 rows=1,001 width=6,614) (actual time=1,052.067..9,064.626 rows=87,982 loops=1)

  • Hash Cond: (s.org_language_id = psol.org_language_id)
31. 101.683 8,962.658 ↓ 87.9 87,982 1

Hash Left Join (cost=2,271.70..16,229.86 rows=1,001 width=6,614) (actual time=1,052.043..8,962.658 rows=87,982 loops=1)

  • Hash Cond: (s.address_id = address.address_id)
32. 1,107.285 8,860.975 ↓ 87.9 87,982 1

Nested Loop Left Join (cost=2,259.84..16,215.31 rows=1,001 width=6,614) (actual time=1,051.958..8,860.975 rows=87,982 loops=1)

33. 98.423 7,753.690 ↓ 87.8 87,752 1

Hash Left Join (cost=2,258.84..15,004.35 rows=1,000 width=5,395) (actual time=1,051.943..7,753.690 rows=87,752 loops=1)

  • Hash Cond: (p.site_id = s.site_id)
34. 361.808 7,655.267 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=2,249.70..14,992.52 rows=1,000 width=5,269) (actual time=1,051.862..7,655.267 rows=87,752 loops=1)

35. 107.418 7,293.459 ↓ 87.8 87,752 1

Hash Left Join (cost=2,249.41..14,631.01 rows=1,000 width=5,265) (actual time=1,051.852..7,293.459 rows=87,752 loops=1)

  • Hash Cond: (dtfotz.tz_id = dtftz.tz_id)
36. 102.753 7,186.041 ↓ 87.8 87,752 1

Hash Left Join (cost=2,233.13..14,612.08 rows=1,000 width=5,242) (actual time=1,051.661..7,186.041 rows=87,752 loops=1)

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
37. 416.860 7,083.288 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=2,225.70..14,601.97 rows=1,000 width=5,242) (actual time=1,051.591..7,083.288 rows=87,752 loops=1)

38. 106.048 6,666.428 ↓ 87.8 87,752 1

Hash Left Join (cost=2,225.41..14,237.04 rows=1,000 width=5,119) (actual time=1,051.582..6,666.428 rows=87,752 loops=1)

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
39. 85.140 6,560.380 ↓ 87.8 87,752 1

Hash Left Join (cost=2,222.08..14,230.95 rows=1,000 width=5,094) (actual time=1,051.515..6,560.380 rows=87,752 loops=1)

  • Hash Cond: (dowsotz.tz_id = dowstz.tz_id)
40. 79.861 6,475.240 ↓ 87.8 87,752 1

Hash Left Join (cost=2,205.80..14,212.02 rows=1,000 width=5,071) (actual time=1,051.322..6,475.240 rows=87,752 loops=1)

  • Hash Cond: (dows.org_tz_id = dowsotz.org_tz_id)
41. 88.674 6,395.379 ↓ 87.8 87,752 1

Hash Left Join (cost=2,198.37..14,201.91 rows=1,000 width=5,071) (actual time=1,051.256..6,395.379 rows=87,752 loops=1)

  • Hash Cond: (dowsol.language_id = dowsl.language_id)
42. 84.204 6,306.705 ↓ 87.8 87,752 1

Hash Left Join (cost=2,196.42..14,197.07 rows=1,000 width=5,064) (actual time=1,051.222..6,306.705 rows=87,752 loops=1)

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
43. 82.091 6,222.501 ↓ 87.8 87,752 1

Hash Left Join (cost=2,195.33..14,190.57 rows=1,000 width=5,064) (actual time=1,051.201..6,222.501 rows=87,752 loops=1)

  • Hash Cond: (dows.address_id = dowaddress.address_id)
44. 89.884 6,140.410 ↓ 87.8 87,752 1

Hash Left Join (cost=2,183.47..14,176.03 rows=1,000 width=5,064) (actual time=1,051.102..6,140.410 rows=87,752 loops=1)

  • Hash Cond: (dow.site_id = dows.site_id)
45. 86.279 6,050.526 ↓ 87.8 87,752 1

Hash Left Join (cost=2,174.33..14,164.21 rows=1,000 width=4,938) (actual time=1,050.999..6,050.526 rows=87,752 loops=1)

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
46. 83.720 5,964.247 ↓ 87.8 87,752 1

Hash Left Join (cost=2,158.05..14,145.28 rows=1,000 width=4,915) (actual time=1,050.840..5,964.247 rows=87,752 loops=1)

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
47. 82.495 5,880.527 ↓ 87.8 87,752 1

Hash Left Join (cost=2,150.62..14,135.18 rows=1,000 width=4,915) (actual time=1,050.771..5,880.527 rows=87,752 loops=1)

  • Hash Cond: (dowol.language_id = dowl.language_id)
48. 84.417 5,798.032 ↓ 87.8 87,752 1

Hash Left Join (cost=2,148.67..14,130.35 rows=1,000 width=4,908) (actual time=1,050.716..5,798.032 rows=87,752 loops=1)

  • Hash Cond: (dow.org_language_id = dowol.org_language_id)
49. 86.860 5,713.615 ↓ 87.8 87,752 1

Hash Left Join (cost=2,147.58..14,125.07 rows=1,000 width=4,908) (actual time=1,050.695..5,713.615 rows=87,752 loops=1)

  • Hash Cond: (potz.tz_id = ptz.tz_id)
50. 91.127 5,626.755 ↓ 87.8 87,752 1

Hash Left Join (cost=2,131.30..14,106.15 rows=1,000 width=4,885) (actual time=1,050.527..5,626.755 rows=87,752 loops=1)

  • Hash Cond: (p.org_tz_id = potz.org_tz_id)
51. 85.938 5,535.628 ↓ 87.8 87,752 1

Hash Left Join (cost=2,123.87..14,096.05 rows=1,000 width=4,885) (actual time=1,050.448..5,535.628 rows=87,752 loops=1)

  • Hash Cond: (pol.language_id = pl.language_id)
52. 87.688 5,449.690 ↓ 87.8 87,752 1

Hash Left Join (cost=2,121.92..14,091.22 rows=1,000 width=4,878) (actual time=1,050.412..5,449.690 rows=87,752 loops=1)

  • Hash Cond: (p.org_language_id = pol.org_language_id)
53. 81.067 5,362.002 ↓ 87.8 87,752 1

Hash Left Join (cost=2,120.83..14,085.94 rows=1,000 width=4,878) (actual time=1,050.388..5,362.002 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = gendvc.dvc_id)
54. 83.280 5,280.935 ↓ 87.8 87,752 1

Hash Left Join (cost=2,107.01..14,069.49 rows=1,000 width=4,660) (actual time=1,050.372..5,280.935 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = virtualdvc.dvc_id)
55. 83.835 5,197.655 ↓ 87.8 87,752 1

Hash Left Join (cost=2,090.93..14,050.79 rows=1,000 width=4,582) (actual time=1,050.356..5,197.655 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = imdvc.dvc_id)
56. 85.262 5,113.820 ↓ 87.8 87,752 1

Hash Left Join (cost=2,077.11..14,034.34 rows=1,000 width=4,364) (actual time=1,050.339..5,113.820 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
57. 304.080 5,028.558 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=2,063.06..14,017.67 rows=1,000 width=4,198) (actual time=1,050.324..5,028.558 rows=87,752 loops=1)

58. 79.164 4,724.478 ↓ 87.8 87,752 1

Hash Left Join (cost=2,062.77..13,687.78 rows=1,000 width=4,177) (actual time=1,050.314..4,724.478 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = numpagedvc.dvc_id)
59. 80.271 4,645.314 ↓ 87.8 87,752 1

Hash Left Join (cost=2,050.97..13,673.36 rows=1,000 width=3,511) (actual time=1,050.298..4,645.314 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
60. 281.805 4,565.043 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=2,037.14..13,656.91 rows=1,000 width=3,281) (actual time=1,050.281..4,565.043 rows=87,752 loops=1)

61. 78.791 4,283.238 ↓ 87.8 87,752 1

Hash Left Join (cost=2,036.86..13,342.35 rows=1,000 width=3,268) (actual time=1,050.271..4,283.238 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = txtpagedvc.dvc_id)
62. 75.924 4,204.447 ↓ 87.8 87,752 1

Hash Left Join (cost=2,023.03..13,325.90 rows=1,000 width=3,042) (actual time=1,050.253..4,204.447 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = appledvc.dvc_id)
63. 75.561 4,128.523 ↓ 87.8 87,752 1

Hash Left Join (cost=2,009.02..13,309.27 rows=1,000 width=2,918) (actual time=1,050.090..4,128.523 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = gcmdvc.dvc_id)
64. 75.460 4,052.962 ↓ 87.8 87,752 1

Hash Left Join (cost=1,997.86..13,295.48 rows=1,000 width=2,735) (actual time=1,049.967..4,052.962 rows=87,752 loops=1)

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
65. 299.461 3,977.502 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,983.81..13,278.80 rows=1,000 width=2,517) (actual time=1,049.948..3,977.502 rows=87,752 loops=1)

66. 75.700 3,678.041 ↓ 87.8 87,752 1

Hash Left Join (cost=1,983.52..12,959.14 rows=1,000 width=2,493) (actual time=1,049.939..3,678.041 rows=87,752 loops=1)

  • Hash Cond: (gdrngsrng.date_rng_id = gdaterng.date_rng_id)
67. 65.145 3,602.341 ↓ 87.8 87,752 1

Hash Left Join (cost=1,812.24..12,785.23 rows=1,000 width=2,477) (actual time=1,048.361..3,602.341 rows=87,752 loops=1)

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
68. 112.981 3,536.247 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,664.24..12,631.92 rows=1,000 width=2,477) (actual time=1,047.398..3,536.247 rows=87,752 loops=1)

69. 103.993 3,423.266 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,663.95..12,288.76 rows=1,000 width=1,270) (actual time=1,047.390..3,423.266 rows=87,752 loops=1)

70. 60.572 3,319.273 ↓ 87.8 87,752 1

Hash Left Join (cost=1,663.66..11,956.97 rows=1,000 width=1,266) (actual time=1,047.382..3,319.273 rows=87,752 loops=1)

  • Hash Cond: (gdrules.date_rule_id = ghdhc.date_holiday_cntner_id)
71. 109.845 3,258.693 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,474.84..11,764.37 rows=1,000 width=1,234) (actual time=1,047.361..3,258.693 rows=87,752 loops=1)

72. 62.710 3,148.848 ↓ 87.8 87,752 1

Hash Left Join (cost=1,474.42..9,232.37 rows=1,000 width=1,198) (actual time=1,047.352..3,148.848 rows=87,752 loops=1)

  • Hash Cond: (gtfotz.tz_id = gtftz.tz_id)
73. 61.304 3,085.965 ↓ 87.8 87,752 1

Hash Left Join (cost=1,458.14..9,213.44 rows=1,000 width=1,175) (actual time=1,047.160..3,085.965 rows=87,752 loops=1)

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
74. 105.081 3,024.571 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,450.71..9,203.36 rows=1,000 width=1,175) (actual time=1,047.043..3,024.571 rows=87,752 loops=1)

75. 66.138 2,919.490 ↓ 87.8 87,752 1

Hash Left Join (cost=1,450.42..8,290.47 rows=1,000 width=1,171) (actual time=1,047.032..2,919.490 rows=87,752 loops=1)

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
76. 98.924 2,851.127 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,242.31..8,079.74 rows=1,000 width=1,147) (actual time=1,044.772..2,851.127 rows=87,752 loops=1)

77. 107.764 2,752.203 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,242.02..7,743.67 rows=1,000 width=1,147) (actual time=1,044.765..2,752.203 rows=87,752 loops=1)

78. 183.008 2,644.439 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,241.61..6,983.17 rows=1,000 width=1,094) (actual time=1,044.753..2,644.439 rows=87,752 loops=1)

  • Join Filter: ((z.chain_ids[(array_length(z.chain_ids, 1) - 1)] <> d.person_id) OR (array_length(z.chain_ids, 1) = 1))
  • Rows Removed by Join Filter: 72541
79. 58.893 2,285.927 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=1,241.32..6,643.15 rows=1,000 width=1,041) (actual time=1,044.743..2,285.927 rows=87,752 loops=1)

80. 65.240 2,139.282 ↓ 87.8 87,752 1

Hash Left Join (cost=1,241.03..6,307.08 rows=1,000 width=1,033) (actual time=1,044.708..2,139.282 rows=87,752 loops=1)

  • Hash Cond: (z.recipient_id = p.person_id)
81. 139.570 2,063.091 ↓ 87.8 87,752 1

Nested Loop Left Join (cost=257.76..5,321.19 rows=1,000 width=980) (actual time=1,033.676..2,063.091 rows=87,752 loops=1)

82. 56.069 1,660.265 ↓ 87.8 87,752 1

Hash Left Join (cost=257.34..2,783.19 rows=1,000 width=897) (actual time=1,033.652..1,660.265 rows=87,752 loops=1)

  • Hash Cond: (z.recipient_id = t.tm_id)
83. 54.243 1,601.673 ↓ 87.8 87,752 1

Hash Left Join (cost=42.15..2,565.37 rows=1,000 width=303) (actual time=1,031.099..1,601.673 rows=87,752 loops=1)

  • Hash Cond: (z.recipient_id = g.grp_id)
84. 132.149 1,546.989 ↓ 87.8 87,752 1

Nested Loop (cost=0.67..2,521.25 rows=1,000 width=282) (actual time=1,030.635..1,546.989 rows=87,752 loops=1)

85. 1,063.832 1,063.832 ↓ 87.8 87,752 1

Function Scan on resolve_recipients_with_source_ntfn z (cost=0.25..10.25 rows=1,000 width=208) (actual time=1,030.595..1,063.832 rows=87,752 loops=1)

86. 351.008 351.008 ↑ 1.0 1 87,752

Index Scan using recipients_pk on recipients r (cost=0.42..2.51 rows=1 width=82) (actual time=0.004..0.004 rows=1 loops=87,752)

  • Index Cond: (recipient_id = z.recipient_id)
87. 0.141 0.441 ↑ 1.0 777 1

Hash (cost=31.77..31.77 rows=777 width=29) (actual time=0.441..0.441 rows=777 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
88. 0.300 0.300 ↑ 1.0 777 1

Seq Scan on grp g (cost=0.00..31.77 rows=777 width=29) (actual time=0.016..0.300 rows=777 loops=1)

89. 0.833 2.523 ↓ 1.0 4,461 1

Hash (cost=159.53..159.53 rows=4,453 width=594) (actual time=2.523..2.523 rows=4,461 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 378kB
90. 1.690 1.690 ↓ 1.0 4,461 1

Seq Scan on tm t (cost=0.00..159.53 rows=4,453 width=594) (actual time=0.019..1.690 rows=4,461 loops=1)

91. 263.256 263.256 ↑ 1.0 1 87,752

Index Scan using dvc_pk on dvc d (cost=0.42..2.54 rows=1 width=83) (actual time=0.003..0.003 rows=1 loops=87,752)

  • Index Cond: (dvc_id = z.recipient_id)
92. 4.748 10.951 ↑ 1.0 18,041 1

Hash (cost=757.01..757.01 rows=18,101 width=53) (actual time=10.951..10.951 rows=18,041 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1645kB
93. 6.203 6.203 ↑ 1.0 18,041 1

Seq Scan on persons p (cost=0.00..757.01 rows=18,101 width=53) (actual time=0.015..6.203 rows=18,041 loops=1)

94. 87.752 87.752 ↓ 0.0 0 87,752

Index Scan using web_creds_pk on web_creds cred (cost=0.29..0.34 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=87,752)

  • Index Cond: (web_cred_id = p.person_id)
95. 175.504 175.504 ↑ 1.0 1 87,752

Index Scan using persons_pk on persons dow (cost=0.29..0.32 rows=1 width=53) (actual time=0.002..0.002 rows=1 loops=87,752)

  • Index Cond: (person_id = d.person_id)
96. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using recipients_pk on recipients dowr (cost=0.42..0.76 rows=1 width=53) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (recipient_id = dow.person_id)
97. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using web_creds_pk on web_creds dowcred (cost=0.29..0.34 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (web_cred_id = dow.person_id)
98. 0.912 2.225 ↓ 1.0 4,234 1

Hash (cost=155.27..155.27 rows=4,227 width=32) (actual time=2.225..2.225 rows=4,234 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 327kB
99. 1.313 1.313 ↓ 1.0 4,234 1

Seq Scan on grp_tf gtf (cost=0.00..155.27 rows=4,227 width=32) (actual time=0.015..1.313 rows=4,234 loops=1)

100. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using drss_pk on drss gdrsroot (cost=0.29..0.91 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (gtf.drs_id = drs_id)
101. 0.027 0.090 ↑ 1.0 197 1

Hash (cost=4.97..4.97 rows=197 width=16) (actual time=0.090..0.090 rows=197 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
102. 0.063 0.063 ↑ 1.0 197 1

Seq Scan on org_tz gtfotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.017..0.063 rows=197 loops=1)

103. 0.080 0.173 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.173..0.173 rows=457 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
104. 0.093 0.093 ↑ 1.0 457 1

Seq Scan on tz gtftz (cost=0.00..10.57 rows=457 width=39) (actual time=0.011..0.093 rows=457 loops=1)

105. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using date_rules_pk on date_rules gdrules (cost=0.42..2.53 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (z.date_rule_id = date_rule_id)
106. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=185.07..185.07 rows=300 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
107. 0.001 0.008 ↓ 0.0 0 1

Hash Left Join (cost=171.28..185.07 rows=300 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (ghdhc.date_rng_id = ghdrng.date_rng_id)
108. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on date_holiday_cntner ghdhc (cost=0.00..13.00 rows=300 width=24) (actual time=0.007..0.007 rows=0 loops=1)

109. 0.000 0.000 ↓ 0.0 0

Hash (cost=115.57..115.57 rows=4,457 width=24) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Seq Scan on date_rng ghdrng (cost=0.00..115.57 rows=4,457 width=24) (never executed)

111. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using drss_pk on drss gdrss (cost=0.29..0.33 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (drs_id = gdrules.date_rule_id)
112. 0.000 0.000 ↓ 0.0 0 87,752

Index Scan using date_rpt_patterns_pk on date_rpt_patterns gdrptp (cost=0.29..0.34 rows=1 width=1,207) (actual time=0.000..0.000 rows=0 loops=87,752)

  • Index Cond: (date_rpt_pattern_id = gdrules.date_rule_id)
113. 0.411 0.949 ↑ 1.0 3,299 1

Hash (cost=106.77..106.77 rows=3,299 width=16) (actual time=0.949..0.949 rows=3,299 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
114. 0.538 0.538 ↑ 1.0 3,299 1

Index Only Scan using drngs_rng_pk on drngs_rng gdrngsrng (cost=0.28..106.77 rows=3,299 width=16) (actual time=0.019..0.538 rows=3,299 loops=1)