explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p97G

Settings
# exclusive inclusive rows x rows loops node
1. 476.940 29,971.755 ↓ 35.7 71,600 1

Sort (cost=70,507,478.51..70,507,483.53 rows=2,007 width=9,269) (actual time=29,960.898..29,971.755 rows=71,600 loops=1)

  • Sort Key: z.src_id, z.sort_chain_ids
  • Sort Method: quicksort Memory: 66152kB
2. 17,833.685 29,494.815 ↓ 35.7 71,600 1

Nested Loop Left Join (cost=26,233.73..70,507,368.42 rows=2,007 width=9,269) (actual time=9,689.859..29,494.815 rows=71,600 loops=1)

3. 190.091 11,661.130 ↓ 35.7 71,600 1

Hash Left Join (cost=26,211.70..28,108.17 rows=2,007 width=9,236) (actual time=9,689.732..11,661.130 rows=71,600 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. 105.623 11,471.039 ↓ 35.7 71,600 1

Hash Left Join (cost=26,023.83..27,503.39 rows=2,007 width=9,223) (actual time=9,687.537..11,471.039 rows=71,600 loops=1)

  • Hash Cond: (ghdrngs.date_rng_id = ghonetimedrng.date_rng_id)
5. 113.244 11,365.416 ↓ 35.7 71,600 1

Hash Left Join (cost=25,852.54..27,326.84 rows=2,007 width=9,215) (actual time=9,685.764..11,365.416 rows=71,600 loops=1)

  • Hash Cond: (ghdr.date_rule_id = ghdrngs.drngs_id)
6. 149.814 11,252.172 ↓ 35.7 71,600 1

Nested Loop Left Join (cost=25,704.54..27,168.17 rows=2,007 width=9,215) (actual time=9,684.675..11,252.172 rows=71,600 loops=1)

7. 120.905 11,102.358 ↓ 35.7 71,600 1

Hash Anti Join (cost=25,704.25..26,479.46 rows=2,007 width=8,016) (actual time=9,684.666..11,102.358 rows=71,600 loops=1)

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 116.051 10,981.453 ↓ 41.8 87,942 1

Hash Left Join (cost=20,230.04..20,959.91 rows=2,104 width=8,024) (actual time=9,680.074..10,981.453 rows=87,942 loops=1)

  • Hash Cond: (ghs.site_id = ghsh.site_id)
9. 110.270 10,865.402 ↓ 60.6 87,942 1

Hash Left Join (cost=20,180.18..20,832.78 rows=1,451 width=7,977) (actual time=9,680.044..10,865.402 rows=87,942 loops=1)

  • Hash Cond: (ghotz.tz_id = ghstz.tz_id)
10. 115.818 10,755.132 ↓ 60.6 87,942 1

Hash Left Join (cost=20,163.90..20,812.66 rows=1,451 width=7,969) (actual time=9,679.850..10,755.132 rows=87,942 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghotz.org_tz_id)
11. 107.492 10,639.314 ↓ 60.6 87,942 1

Hash Left Join (cost=20,156.47..20,801.34 rows=1,451 width=7,969) (actual time=9,679.748..10,639.314 rows=87,942 loops=1)

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
12. 117.399 10,531.822 ↓ 60.6 87,942 1

Hash Left Join (cost=20,140.18..20,781.21 rows=1,451 width=7,946) (actual time=9,679.536..10,531.822 rows=87,942 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghpsotz.org_tz_id)
13. 108.795 10,414.423 ↓ 60.6 87,942 1

Hash Left Join (cost=20,132.75..20,769.89 rows=1,451 width=7,938) (actual time=9,679.446..10,414.423 rows=87,942 loops=1)

  • Hash Cond: (g.site_id = ghs.site_id)
14. 187.916 10,305.628 ↓ 60.6 87,942 1

Nested Loop Left Join (cost=20,123.61..20,756.95 rows=1,451 width=7,922) (actual time=9,679.322..10,305.628 rows=87,942 loops=1)

15. 112.950 10,117.712 ↓ 60.6 87,942 1

Hash Left Join (cost=20,123.32..20,259.03 rows=1,451 width=6,731) (actual time=9,679.302..10,117.712 rows=87,942 loops=1)

  • Hash Cond: (otz.tz_id = stz.tz_id)
16. 116.007 10,004.762 ↓ 60.6 87,942 1

Hash Left Join (cost=20,107.04..20,238.90 rows=1,451 width=6,723) (actual time=9,679.085..10,004.762 rows=87,942 loops=1)

  • Hash Cond: (s.org_tz_id = otz.org_tz_id)
17. 210.444 9,888.755 ↓ 60.6 87,942 1

Hash Right Join (cost=20,099.61..20,227.59 rows=1,451 width=6,723) (actual time=9,678.971..9,888.755 rows=87,942 loops=1)

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

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

  • Hash Cond: (drngs.date_rng_id = drng.date_rng_id)
19. 0.433 0.433 ↑ 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.033..0.433 rows=3,299 loops=1)

  • Heap Fetches: 0
20. 0.913 1.754 ↓ 1.0 4,477 1

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

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

Seq Scan on date_rng drng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.019..0.841 rows=4,477 loops=1)

22. 143.342 9,675.324 ↓ 60.6 87,942 1

Hash (cost=19,909.91..19,909.91 rows=1,451 width=6,707) (actual time=9,675.324..9,675.324 rows=87,942 loops=1)

  • Buckets: 131072 (originally 2048) Batches: 1 (originally 1) Memory Usage: 46564kB
23. 119.576 9,531.982 ↓ 60.6 87,942 1

Merge Right Join (cost=19,888.02..19,909.91 rows=1,451 width=6,707) (actual time=9,403.769..9,531.982 rows=87,942 loops=1)

  • Merge Cond: (dr.date_rule_id = oh.date_rule_id)
24. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

25. 317.803 9,412.386 ↓ 60.6 87,942 1

Sort (cost=16,418.24..16,421.87 rows=1,451 width=6,679) (actual time=9,403.739..9,412.386 rows=87,942 loops=1)

  • Sort Key: oh.date_rule_id
  • Sort Method: quicksort Memory: 82520kB
26. 96.969 9,094.583 ↓ 60.6 87,942 1

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

  • Hash Cond: (s.site_id = sh.site_id)
27. 95.917 8,997.614 ↓ 87.9 87,942 1

Hash Left Join (cost=2,298.45..16,270.24 rows=1,001 width=6,652) (actual time=1,040.721..8,997.614 rows=87,942 loops=1)

  • Hash Cond: (psotz.tz_id = pstz.tz_id)
28. 91.770 8,901.697 ↓ 87.9 87,942 1

Hash Left Join (cost=2,282.17..16,251.31 rows=1,001 width=6,629) (actual time=1,040.495..8,901.697 rows=87,942 loops=1)

  • Hash Cond: (s.org_tz_id = psotz.org_tz_id)
29. 99.561 8,809.927 ↓ 87.9 87,942 1

Hash Left Join (cost=2,274.73..16,241.20 rows=1,001 width=6,621) (actual time=1,040.423..8,809.927 rows=87,942 loops=1)

  • Hash Cond: (psol.language_id = psl.language_id)
30. 96.971 8,710.366 ↓ 87.9 87,942 1

Hash Left Join (cost=2,272.79..16,236.36 rows=1,001 width=6,614) (actual time=1,040.370..8,710.366 rows=87,942 loops=1)

  • Hash Cond: (s.org_language_id = psol.org_language_id)
31. 101.092 8,613.395 ↓ 87.9 87,942 1

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

  • Hash Cond: (s.address_id = address.address_id)
32. 1,038.539 8,512.303 ↓ 87.9 87,942 1

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

33. 96.440 7,473.764 ↓ 87.7 87,712 1

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

  • Hash Cond: (p.site_id = s.site_id)
34. 356.173 7,377.324 ↓ 87.7 87,712 1

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

35. 101.016 7,021.151 ↓ 87.7 87,712 1

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

  • Hash Cond: (dtfotz.tz_id = dtftz.tz_id)
36. 105.653 6,920.135 ↓ 87.7 87,712 1

Hash Left Join (cost=2,233.13..14,612.08 rows=1,000 width=5,242) (actual time=1,039.993..6,920.135 rows=87,712 loops=1)

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
37. 394.777 6,814.482 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=2,225.70..14,601.97 rows=1,000 width=5,242) (actual time=1,039.928..6,814.482 rows=87,712 loops=1)

38. 98.897 6,419.705 ↓ 87.7 87,712 1

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

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
39. 82.347 6,320.808 ↓ 87.7 87,712 1

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

  • Hash Cond: (dowsotz.tz_id = dowstz.tz_id)
40. 80.967 6,238.461 ↓ 87.7 87,712 1

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

  • Hash Cond: (dows.org_tz_id = dowsotz.org_tz_id)
41. 82.226 6,157.494 ↓ 87.7 87,712 1

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

  • Hash Cond: (dowsol.language_id = dowsl.language_id)
42. 78.413 6,075.268 ↓ 87.7 87,712 1

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

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
43. 80.895 5,996.855 ↓ 87.7 87,712 1

Hash Left Join (cost=2,195.33..14,190.57 rows=1,000 width=5,064) (actual time=1,039.605..5,996.855 rows=87,712 loops=1)

  • Hash Cond: (dows.address_id = dowaddress.address_id)
44. 83.950 5,915.960 ↓ 87.7 87,712 1

Hash Left Join (cost=2,183.47..14,176.03 rows=1,000 width=5,064) (actual time=1,039.504..5,915.960 rows=87,712 loops=1)

  • Hash Cond: (dow.site_id = dows.site_id)
45. 77.429 5,832.010 ↓ 87.7 87,712 1

Hash Left Join (cost=2,174.33..14,164.21 rows=1,000 width=4,938) (actual time=1,039.412..5,832.010 rows=87,712 loops=1)

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
46. 77.213 5,754.581 ↓ 87.7 87,712 1

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

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
47. 80.053 5,677.368 ↓ 87.7 87,712 1

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

  • Hash Cond: (dowol.language_id = dowl.language_id)
48. 79.127 5,597.315 ↓ 87.7 87,712 1

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

  • Hash Cond: (dow.org_language_id = dowol.org_language_id)
49. 81.917 5,518.188 ↓ 87.7 87,712 1

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

  • Hash Cond: (potz.tz_id = ptz.tz_id)
50. 84.277 5,436.271 ↓ 87.7 87,712 1

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

  • Hash Cond: (p.org_tz_id = potz.org_tz_id)
51. 84.058 5,351.994 ↓ 87.7 87,712 1

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

  • Hash Cond: (pol.language_id = pl.language_id)
52. 78.721 5,267.936 ↓ 87.7 87,712 1

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

  • Hash Cond: (p.org_language_id = pol.org_language_id)
53. 80.377 5,189.215 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = gendvc.dvc_id)
54. 80.041 5,108.838 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = virtualdvc.dvc_id)
55. 80.578 5,028.797 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = imdvc.dvc_id)
56. 88.047 4,948.219 ↓ 87.7 87,712 1

Hash Left Join (cost=2,077.11..14,034.34 rows=1,000 width=4,364) (actual time=1,038.797..4,948.219 rows=87,712 loops=1)

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
57. 287.412 4,860.172 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=2,063.06..14,017.67 rows=1,000 width=4,198) (actual time=1,038.783..4,860.172 rows=87,712 loops=1)

58. 75.096 4,572.760 ↓ 87.7 87,712 1

Hash Left Join (cost=2,062.77..13,687.78 rows=1,000 width=4,177) (actual time=1,038.776..4,572.760 rows=87,712 loops=1)

  • Hash Cond: (d.dvc_id = numpagedvc.dvc_id)
59. 75.414 4,497.664 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
60. 267.496 4,422.250 ↓ 87.7 87,712 1

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

61. 71.666 4,154.754 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = txtpagedvc.dvc_id)
62. 77.519 4,083.088 ↓ 87.7 87,712 1

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

  • Hash Cond: (d.dvc_id = appledvc.dvc_id)
63. 76.322 4,005.569 ↓ 87.7 87,712 1

Hash Left Join (cost=2,009.02..13,309.27 rows=1,000 width=2,918) (actual time=1,038.575..4,005.569 rows=87,712 loops=1)

  • Hash Cond: (d.dvc_id = gcmdvc.dvc_id)
64. 74.572 3,929.247 ↓ 87.7 87,712 1

Hash Left Join (cost=1,997.86..13,295.48 rows=1,000 width=2,735) (actual time=1,038.448..3,929.247 rows=87,712 loops=1)

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
65. 290.652 3,854.675 ↓ 87.7 87,712 1

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

66. 72.657 3,564.023 ↓ 87.7 87,712 1

Hash Left Join (cost=1,983.52..12,959.14 rows=1,000 width=2,493) (actual time=1,038.424..3,564.023 rows=87,712 loops=1)

  • Hash Cond: (gdrngsrng.date_rng_id = gdaterng.date_rng_id)
67. 70.099 3,491.366 ↓ 87.7 87,712 1

Hash Left Join (cost=1,812.24..12,785.23 rows=1,000 width=2,477) (actual time=1,036.978..3,491.366 rows=87,712 loops=1)

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
68. 106.723 3,420.354 ↓ 87.7 87,712 1

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

69. 102.804 3,313.631 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,663.95..12,288.76 rows=1,000 width=1,270) (actual time=1,036.046..3,313.631 rows=87,712 loops=1)

70. 61.105 3,210.827 ↓ 87.7 87,712 1

Hash Left Join (cost=1,663.66..11,956.97 rows=1,000 width=1,266) (actual time=1,036.040..3,210.827 rows=87,712 loops=1)

  • Hash Cond: (gdrules.date_rule_id = ghdhc.date_holiday_cntner_id)
71. 103.006 3,149.714 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,474.84..11,764.37 rows=1,000 width=1,234) (actual time=1,036.023..3,149.714 rows=87,712 loops=1)

72. 60.640 3,046.708 ↓ 87.7 87,712 1

Hash Left Join (cost=1,474.42..9,232.37 rows=1,000 width=1,198) (actual time=1,036.016..3,046.708 rows=87,712 loops=1)

  • Hash Cond: (gtfotz.tz_id = gtftz.tz_id)
73. 56.054 2,985.898 ↓ 87.7 87,712 1

Hash Left Join (cost=1,458.14..9,213.44 rows=1,000 width=1,175) (actual time=1,035.837..2,985.898 rows=87,712 loops=1)

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
74. 100.124 2,929.776 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,450.71..9,203.36 rows=1,000 width=1,175) (actual time=1,035.759..2,929.776 rows=87,712 loops=1)

75. 67.069 2,829.652 ↓ 87.7 87,712 1

Hash Left Join (cost=1,450.42..8,290.47 rows=1,000 width=1,171) (actual time=1,035.750..2,829.652 rows=87,712 loops=1)

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
76. 93.431 2,760.870 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,242.31..8,079.74 rows=1,000 width=1,147) (actual time=1,034.016..2,760.870 rows=87,712 loops=1)

77. 92.734 2,667.439 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,242.02..7,743.67 rows=1,000 width=1,147) (actual time=1,034.009..2,667.439 rows=87,712 loops=1)

78. 172.084 2,574.705 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,241.61..6,983.17 rows=1,000 width=1,094) (actual time=1,034.002..2,574.705 rows=87,712 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: 72521
79. 136.088 2,227.197 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=1,241.32..6,643.15 rows=1,000 width=1,041) (actual time=1,033.984..2,227.197 rows=87,712 loops=1)

80. 67.465 2,091.109 ↓ 87.7 87,712 1

Hash Left Join (cost=1,241.03..6,307.08 rows=1,000 width=1,033) (actual time=1,033.977..2,091.109 rows=87,712 loops=1)

  • Hash Cond: (z.recipient_id = p.person_id)
81. 124.332 2,014.382 ↓ 87.7 87,712 1

Nested Loop Left Join (cost=257.76..5,321.19 rows=1,000 width=980) (actual time=1,024.686..2,014.382 rows=87,712 loops=1)

82. 55.032 1,626.914 ↓ 87.7 87,712 1

Hash Left Join (cost=257.34..2,783.19 rows=1,000 width=897) (actual time=1,024.667..1,626.914 rows=87,712 loops=1)

  • Hash Cond: (z.recipient_id = t.tm_id)
83. 54.612 1,569.514 ↓ 87.7 87,712 1

Hash Left Join (cost=42.15..2,565.37 rows=1,000 width=303) (actual time=1,022.278..1,569.514 rows=87,712 loops=1)

  • Hash Cond: (z.recipient_id = g.grp_id)
84. 114.835 1,514.530 ↓ 87.7 87,712 1

Nested Loop (cost=0.67..2,521.25 rows=1,000 width=282) (actual time=1,021.892..1,514.530 rows=87,712 loops=1)

85. 1,048.847 1,048.847 ↓ 87.7 87,712 1

Function Scan on resolve_recipients_with_source_ntfn z (cost=0.25..10.25 rows=1,000 width=208) (actual time=1,021.861..1,048.847 rows=87,712 loops=1)

86. 350.848 350.848 ↑ 1.0 1 87,712

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,712)

  • Index Cond: (recipient_id = z.recipient_id)
87. 0.135 0.372 ↑ 1.0 777 1

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

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

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

89. 0.846 2.368 ↓ 1.0 4,461 1

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

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

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

91. 263.136 263.136 ↑ 1.0 1 87,712

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,712)

  • Index Cond: (dvc_id = z.recipient_id)
92. 3.954 9.262 ↑ 1.0 18,045 1

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

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

Seq Scan on persons p (cost=0.00..757.01 rows=18,101 width=53) (actual time=0.013..5.308 rows=18,045 loops=1)

94. 0.000 0.000 ↓ 0.0 0 87,712

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

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

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,712)

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

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,712)

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

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,712)

  • Index Cond: (web_cred_id = dow.person_id)
98. 0.697 1.713 ↓ 1.0 4,232 1

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

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

Seq Scan on grp_tf gtf (cost=0.00..155.27 rows=4,227 width=32) (actual time=0.012..1.016 rows=4,232 loops=1)

100. 0.000 0.000 ↓ 0.0 0 87,712

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,712)

  • Index Cond: (gtf.drs_id = drs_id)
101. 0.025 0.068 ↑ 1.0 197 1

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

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

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

103. 0.085 0.170 ↑ 1.0 457 1

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

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

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

105. 0.000 0.000 ↓ 0.0 0 87,712

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,712)

  • Index Cond: (z.date_rule_id = date_rule_id)
106. 0.001 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.007 ↓ 0.0 0 1

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

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

Seq Scan on date_holiday_cntner ghdhc (cost=0.00..13.00 rows=300 width=24) (actual time=0.006..0.006 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,712

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,712)

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

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,712)

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

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

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
114. 0.474 0.474 ↑ 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.017..0.474 rows=3,299 loops=1)