explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d0uT

Settings
# exclusive inclusive rows x rows loops node
1. 496.251 17,696.415 ↓ 35.6 71,620 1

Sort (cost=6,470,688.95..6,470,693.98 rows=2,012 width=9,269) (actual time=17,685.255..17,696.415 rows=71,620 loops=1)

  • Sort Key: z.src_id, z.sort_chain_ids
  • Sort Method: quicksort Memory: 66162kB
2. 1,601.710 17,200.164 ↓ 35.6 71,620 1

Nested Loop Left Join (cost=25,979.04..6,470,578.54 rows=2,012 width=9,269) (actual time=12,396.123..17,200.164 rows=71,620 loops=1)

3. 181.647 14,380.914 ↓ 35.6 71,620 1

Hash Left Join (cost=25,957.01..27,854.72 rows=2,012 width=9,236) (actual time=12,395.986..14,380.914 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. 116.367 14,197.123 ↓ 35.6 71,620 1

Hash Left Join (cost=25,769.13..27,248.91 rows=2,012 width=9,223) (actual time=12,393.795..14,197.123 rows=71,620 loops=1)

  • Hash Cond: (ghdrngs.date_rng_id = ghonetimedrng.date_rng_id)
5. 101.915 14,079.200 ↓ 35.6 71,620 1

Hash Left Join (cost=25,597.85..27,072.34 rows=2,012 width=9,215) (actual time=12,392.166..14,079.200 rows=71,620 loops=1)

  • Hash Cond: (ghdr.date_rule_id = ghdrngs.drngs_id)
6. 159.616 13,976.306 ↓ 35.6 71,620 1

Nested Loop Left Join (cost=25,449.85..26,913.65 rows=2,012 width=9,215) (actual time=12,391.151..13,976.306 rows=71,620 loops=1)

7. 112.207 13,816.690 ↓ 35.6 71,620 1

Hash Anti Join (cost=25,449.56..26,223.22 rows=2,012 width=8,016) (actual time=12,391.143..13,816.690 rows=71,620 loops=1)

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 114.118 13,701.210 ↓ 41.8 87,982 1

Hash Left Join (cost=20,230.04..20,959.91 rows=2,104 width=8,024) (actual time=12,387.835..13,701.210 rows=87,982 loops=1)

  • Hash Cond: (ghs.site_id = ghsh.site_id)
9. 115.521 13,587.086 ↓ 60.6 87,982 1

Hash Left Join (cost=20,180.18..20,832.78 rows=1,451 width=7,977) (actual time=12,387.795..13,587.086 rows=87,982 loops=1)

  • Hash Cond: (ghotz.tz_id = ghstz.tz_id)
10. 114.087 13,471.405 ↓ 60.6 87,982 1

Hash Left Join (cost=20,163.90..20,812.66 rows=1,451 width=7,969) (actual time=12,387.611..13,471.405 rows=87,982 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghotz.org_tz_id)
11. 118.104 13,357.252 ↓ 60.6 87,982 1

Hash Left Join (cost=20,156.47..20,801.34 rows=1,451 width=7,969) (actual time=12,387.521..13,357.252 rows=87,982 loops=1)

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
12. 112.058 13,238.951 ↓ 60.6 87,982 1

Hash Left Join (cost=20,140.18..20,781.21 rows=1,451 width=7,946) (actual time=12,387.292..13,238.951 rows=87,982 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghpsotz.org_tz_id)
13. 109.353 13,126.824 ↓ 60.6 87,982 1

Hash Left Join (cost=20,132.75..20,769.89 rows=1,451 width=7,938) (actual time=12,387.195..13,126.824 rows=87,982 loops=1)

  • Hash Cond: (g.site_id = ghs.site_id)
14. 193.791 13,017.403 ↓ 60.6 87,982 1

Nested Loop Left Join (cost=20,123.61..20,756.95 rows=1,451 width=7,922) (actual time=12,387.104..13,017.403 rows=87,982 loops=1)

15. 118.519 12,823.612 ↓ 60.6 87,982 1

Hash Left Join (cost=20,123.32..20,259.03 rows=1,451 width=6,731) (actual time=12,387.087..12,823.612 rows=87,982 loops=1)

  • Hash Cond: (otz.tz_id = stz.tz_id)
16. 116.382 12,704.904 ↓ 60.6 87,982 1

Hash Left Join (cost=20,107.04..20,238.90 rows=1,451 width=6,723) (actual time=12,386.886..12,704.904 rows=87,982 loops=1)

  • Hash Cond: (s.org_tz_id = otz.org_tz_id)
17. 202.068 12,588.432 ↓ 60.6 87,982 1

Hash Right Join (cost=20,099.61..20,227.59 rows=1,451 width=6,723) (actual time=12,386.770..12,588.432 rows=87,982 loops=1)

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

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

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

  • Heap Fetches: 0
20. 0.899 1.669 ↓ 1.0 4,472 1

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

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

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

22. 136.636 12,383.573 ↓ 60.6 87,982 1

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

  • Buckets: 131072 (originally 2048) Batches: 1 (originally 1) Memory Usage: 46583kB
23. 116.718 12,246.937 ↓ 60.6 87,982 1

Merge Right Join (cost=19,888.02..19,909.91 rows=1,451 width=6,707) (actual time=12,121.344..12,246.937 rows=87,982 loops=1)

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

25. 395.824 12,130.200 ↓ 60.6 87,982 1

Sort (cost=16,418.24..16,421.87 rows=1,451 width=6,679) (actual time=12,121.315..12,130.200 rows=87,982 loops=1)

  • Sort Key: oh.date_rule_id
  • Sort Method: quicksort Memory: 82551kB
26. 115.238 11,734.376 ↓ 60.6 87,982 1

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

  • Hash Cond: (s.site_id = sh.site_id)
27. 116.481 11,619.131 ↓ 87.9 87,982 1

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

  • Hash Cond: (psotz.tz_id = pstz.tz_id)
28. 116.794 11,502.500 ↓ 87.9 87,982 1

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

  • Hash Cond: (s.org_tz_id = psotz.org_tz_id)
29. 116.806 11,385.650 ↓ 87.9 87,982 1

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

  • Hash Cond: (psol.language_id = psl.language_id)
30. 115.565 11,268.817 ↓ 87.9 87,982 1

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

  • Hash Cond: (s.org_language_id = psol.org_language_id)
31. 119.438 11,153.244 ↓ 87.9 87,982 1

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

  • Hash Cond: (s.address_id = address.address_id)
32. 144.791 11,033.739 ↓ 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,049.821..11,033.739 rows=87,982 loops=1)

33. 121.333 9,572.668 ↓ 87.8 87,752 1

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

  • Hash Cond: (p.site_id = s.site_id)
34. 214.687 9,451.268 ↓ 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,049.730..9,451.268 rows=87,752 loops=1)

35. 132.444 8,973.325 ↓ 87.8 87,752 1

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

  • Hash Cond: (dtfotz.tz_id = dtftz.tz_id)
36. 119.949 8,840.727 ↓ 87.8 87,752 1

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

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
37. 179.173 8,720.720 ↓ 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,049.478..8,720.720 rows=87,752 loops=1)

38. 125.985 8,102.787 ↓ 87.8 87,752 1

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

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
39. 112.113 7,976.766 ↓ 87.8 87,752 1

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

  • Hash Cond: (dowsotz.tz_id = dowstz.tz_id)
40. 94.699 7,864.494 ↓ 87.8 87,752 1

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

  • Hash Cond: (dows.org_tz_id = dowsotz.org_tz_id)
41. 103.101 7,769.739 ↓ 87.8 87,752 1

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

  • Hash Cond: (dowsol.language_id = dowsl.language_id)
42. 108.877 7,666.617 ↓ 87.8 87,752 1

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

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
43. 106.546 7,557.731 ↓ 87.8 87,752 1

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

  • Hash Cond: (dows.address_id = dowaddress.address_id)
44. 101.419 7,451.098 ↓ 87.8 87,752 1

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

  • Hash Cond: (dow.site_id = dows.site_id)
45. 108.474 7,349.593 ↓ 87.8 87,752 1

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

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
46. 103.622 7,240.974 ↓ 87.8 87,752 1

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

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
47. 97.370 7,137.298 ↓ 87.8 87,752 1

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

  • Hash Cond: (dowol.language_id = dowl.language_id)
48. 94.039 7,039.909 ↓ 87.8 87,752 1

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

  • Hash Cond: (dow.org_language_id = dowol.org_language_id)
49. 106.842 6,945.859 ↓ 87.8 87,752 1

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

  • Hash Cond: (potz.tz_id = ptz.tz_id)
50. 98.248 6,838.857 ↓ 87.8 87,752 1

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

  • Hash Cond: (p.org_tz_id = potz.org_tz_id)
51. 102.494 6,740.554 ↓ 87.8 87,752 1

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

  • Hash Cond: (pol.language_id = pl.language_id)
52. 105.405 6,638.034 ↓ 87.8 87,752 1

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

  • Hash Cond: (p.org_language_id = pol.org_language_id)
53. 97.744 6,532.618 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = gendvc.dvc_id)
54. 111.245 6,434.869 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = virtualdvc.dvc_id)
55. 101.587 6,323.619 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = imdvc.dvc_id)
56. 102.015 6,222.027 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
57. 150.057 6,120.007 ↓ 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,048.252..6,120.007 rows=87,752 loops=1)

58. 105.004 5,706.694 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = numpagedvc.dvc_id)
59. 103.039 5,601.686 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
60. 106.652 5,498.642 ↓ 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,048.186..5,498.642 rows=87,752 loops=1)

61. 90.905 5,128.734 ↓ 87.8 87,752 1

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

  • Hash Cond: (d.dvc_id = txtpagedvc.dvc_id)
62. 97.479 5,037.824 ↓ 87.8 87,752 1

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

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

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

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

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

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
65. 152.204 4,754.579 ↓ 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,047.735..4,754.579 rows=87,752 loops=1)

66. 91.151 4,339.119 ↓ 87.8 87,752 1

Hash Left Join (cost=1,983.52..12,959.14 rows=1,000 width=2,493) (actual time=1,047.722..4,339.119 rows=87,752 loops=1)

  • Hash Cond: (gdrngsrng.date_rng_id = gdaterng.date_rng_id)
67. 80.819 4,246.405 ↓ 87.8 87,752 1

Hash Left Join (cost=1,812.24..12,785.23 rows=1,000 width=2,477) (actual time=1,046.138..4,246.405 rows=87,752 loops=1)

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
68. 133.270 4,164.729 ↓ 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,045.252..4,164.729 rows=87,752 loops=1)

69. 125.484 4,031.459 ↓ 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,045.245..4,031.459 rows=87,752 loops=1)

70. 71.258 3,905.975 ↓ 87.8 87,752 1

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

  • Hash Cond: (gdrules.date_rule_id = ghdhc.date_holiday_cntner_id)
71. 141.265 3,834.710 ↓ 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,045.220..3,834.710 rows=87,752 loops=1)

72. 78.313 3,693.445 ↓ 87.8 87,752 1

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

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

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

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
74. 141.647 3,542.775 ↓ 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,044.943..3,542.775 rows=87,752 loops=1)

75. 80.033 3,401.128 ↓ 87.8 87,752 1

Hash Left Join (cost=1,450.42..8,290.47 rows=1,000 width=1,171) (actual time=1,044.934..3,401.128 rows=87,752 loops=1)

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
76. 113.263 3,319.351 ↓ 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,043.167..3,319.351 rows=87,752 loops=1)

77. 126.092 3,206.088 ↓ 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,043.161..3,206.088 rows=87,752 loops=1)

78. 207.347 3,079.996 ↓ 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,043.154..3,079.996 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. 69.044 2,609.393 ↓ 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,043.141..2,609.393 rows=87,752 loops=1)

80. 86.454 2,452.597 ↓ 87.8 87,752 1

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

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

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

82. 68.446 1,843.298 ↓ 87.8 87,752 1

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

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

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

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

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

85. 1,074.261 1,074.261 ↓ 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.841..1,074.261 rows=87,752 loops=1)

86. 438.760 438.760 ↑ 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.005..0.005 rows=1 loops=87,752)

  • Index Cond: (recipient_id = z.recipient_id)
87. 0.133 0.402 ↑ 1.0 777 1

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

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

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

89. 0.792 2.264 ↓ 1.0 4,461 1

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

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

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

91. 351.008 351.008 ↑ 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.004..0.004 rows=1 loops=87,752)

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

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

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

Seq Scan on persons p (cost=0.00..757.01 rows=18,101 width=53) (actual time=0.013..5.393 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. 263.256 263.256 ↑ 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.003..0.003 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.681 1.744 ↓ 1.0 4,234 1

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

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

Seq Scan on grp_tf gtf (cost=0.00..155.27 rows=4,227 width=32) (actual time=0.011..1.063 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.025 0.065 ↑ 1.0 197 1

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

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

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

103. 0.093 0.183 ↑ 1.0 457 1

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

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

Seq Scan on tz gtftz (cost=0.00..10.57 rows=457 width=39) (actual time=0.008..0.090 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.007 ↓ 0.0 0 1

Hash (cost=185.07..185.07 rows=300 width=32) (actual time=0.007..0.007 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,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.403 0.857 ↑ 1.0 3,299 1

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

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

  • Heap Fetches: 0
115. 0.746 1.563 ↓ 1.0 4,472 1

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

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

Seq Scan on date_rng gdaterng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.022..0.817 rows=4,472 loops=1)

117. 263.256 263.256 ↓ 0.0 0 87,752

Index Scan using email_dvc_dtl_pk on email_dvc_dtl emaildvc (cost=0.29..0.32 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=87,752)

  • Index Cond: (dvc_id = d.dvc_id)
118. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=11.80..11.80 rows=180 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
119. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on bes_dvc_dtl besdvc (cost=0.00..11.80 rows=180 width=226) (actual time=0.005..0.005 rows=0 loops=1)

120. 0.079 0.148 ↑ 1.0 185 1

Hash (cost=8.85..8.85 rows=185 width=191) (actual time=0.148..0.148 rows=185 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
121. 0.069 0.069 ↑ 1.0 185 1

Seq Scan on gcm_push_dvc_dtl gcmdvc (cost=0.00..8.85 rows=185 width=191) (actual time=0.008..0.069 rows=185 loops=1)

122. 0.101 0.195 ↑ 1.0 267 1

Hash (cost=10.67..10.67 rows=267 width=132) (actual time=0.195..0.195 rows=267 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
123. 0.094 0.094 ↑ 1.0 267 1

Seq Scan on apple_push_dvc_dtl appledvc (cost=0.00..10.67 rows=267 width=132) (actual time=0.008..0.094 rows=267 loops=1)

124. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=234) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
125. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on txt_page_dvc_dtl txtpagedvc (cost=0.00..11.70 rows=170 width=234) (actual time=0.005..0.005 rows=0 loops=1)

126. 263.256 263.256 ↓ 0.0 0 87,752

Index Scan using txt_phone_dvc_dtl_pk on txt_phone_dvc_dtl txtphonedvc (cost=0.29..0.31 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=87,752)

  • Index Cond: (dvc_id = d.dvc_id)
127. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=238) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
128. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on fax_dvc_dtl faxdvc (cost=0.00..11.70 rows=170 width=238) (actual time=0.004..0.004 rows=0 loops=1)

129. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=674) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
130. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on num_page_dvc_dtl numpagedvc (cost=0.00..10.80 rows=80 width=674) (actual time=0.004..0.004 rows=0 loops=1)

131. 263.256 263.256 ↓ 0.0 0 87,752

Index Scan using voc_dvc_dtl_pk on voc_dvc_dtl voicedvc (cost=0.29..0.33 rows=1 width=29) (actual time=0.003..0.003 rows=0 loops=87,752)

  • Index Cond: (dvc_id = d.dvc_id)
132. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=11.80..11.80 rows=180 width=174) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
133. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on voice_ivr_dvc_dtl voiceivrdvc (cost=0.00..11.80 rows=180 width=174) (actual time=0.005..0.005 rows=0 loops=1)

134. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
135. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on im_dvc_dtl imdvc (cost=0.00..11.70 rows=170 width=226) (actual time=0.005..0.005 rows=0 loops=1)

136. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=12.70..12.70 rows=270 width=86) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
137. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on virtual_dvc_dtl virtualdvc (cost=0.00..12.70 rows=270 width=86) (actual time=0.004..0.004 rows=0 loops=1)

138. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
139. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gen_dvc_dtl gendvc (cost=0.00..11.70 rows=170 width=226) (actual time=0.004..0.004 rows=0 loops=1)

140. 0.002 0.011 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
141. 0.009 0.009 ↑ 1.0 4 1

Seq Scan on org_languages pol (cost=0.00..1.04 rows=4 width=16) (actual time=0.008..0.009 rows=4 loops=1)

142. 0.011 0.026 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=23) (actual time=0.026..0.026 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
143. 0.015 0.015 ↑ 1.0 42 1

Seq Scan on languages pl (cost=0.00..1.42 rows=42 width=23) (actual time=0.009..0.015 rows=42 loops=1)

144. 0.025 0.055 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
145. 0.030 0.030 ↑ 1.0 197 1

Seq Scan on org_tz potz (cost=0.00..4.97 rows=197 width=16) (actual time=0.005..0.030 rows=197 loops=1)

146. 0.083 0.160 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
147. 0.077 0.077 ↑ 1.0 457 1

Seq Scan on tz ptz (cost=0.00..10.57 rows=457 width=39) (actual time=0.006..0.077 rows=457 loops=1)

148. 0.003 0.011 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
149. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on org_languages dowol (cost=0.00..1.04 rows=4 width=16) (actual time=0.007..0.008 rows=4 loops=1)

150. 0.009 0.019 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=23) (actual time=0.019..0.019 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
151. 0.010 0.010 ↑ 1.0 42 1

Seq Scan on languages dowl (cost=0.00..1.42 rows=42 width=23) (actual time=0.005..0.010 rows=42 loops=1)

152. 0.025 0.054 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
153. 0.029 0.029 ↑ 1.0 197 1

Seq Scan on org_tz dowotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.005..0.029 rows=197 loops=1)

154. 0.075 0.145 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
155. 0.070 0.070 ↑ 1.0 457 1

Seq Scan on tz dowtz (cost=0.00..10.57 rows=457 width=39) (actual time=0.005..0.070 rows=457 loops=1)

156. 0.029 0.086 ↑ 1.0 95 1

Hash (cost=7.95..7.95 rows=95 width=134) (actual time=0.086..0.086 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
157. 0.057 0.057 ↑ 1.0 95 1

Seq Scan on sites dows (cost=0.00..7.95 rows=95 width=134) (actual time=0.009..0.057 rows=95 loops=1)

158. 0.028 0.087 ↑ 1.0 216 1

Hash (cost=9.16..9.16 rows=216 width=16) (actual time=0.087..0.087 rows=216 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
159. 0.059 0.059 ↑ 1.0 216 1

Seq Scan on addresses dowaddress (cost=0.00..9.16 rows=216 width=16) (actual time=0.009..0.059 rows=216 loops=1)

160. 0.003 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.009..0.009 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
161. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on org_languages dowsol (cost=0.00..1.04 rows=4 width=16) (actual time=0.006..0.006 rows=4 loops=1)

162. 0.010 0.021 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=23) (actual time=0.021..0.021 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
163. 0.011 0.011 ↑ 1.0 42 1

Seq Scan on languages dowsl (cost=0.00..1.42 rows=42 width=23) (actual time=0.005..0.011 rows=42 loops=1)

164. 0.025 0.056 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
165. 0.031 0.031 ↑ 1.0 197 1

Seq Scan on org_tz dowsotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.005..0.031 rows=197 loops=1)

166. 0.089 0.159 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
167. 0.070 0.070 ↑ 1.0 457 1

Seq Scan on tz dowstz (cost=0.00..10.57 rows=457 width=39) (actual time=0.005..0.070 rows=457 loops=1)

168. 0.013 0.036 ↑ 1.0 59 1

Hash (cost=2.59..2.59 rows=59 width=41) (actual time=0.036..0.036 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
169. 0.023 0.023 ↑ 1.0 59 1

Seq Scan on org_dvc_names odn (cost=0.00..2.59 rows=59 width=41) (actual time=0.009..0.023 rows=59 loops=1)

170. 438.760 438.760 ↑ 1.0 1 87,752

Index Scan using idx_dvc_tf1 on dvc_tf dtf (cost=0.29..0.35 rows=1 width=131) (actual time=0.004..0.005 rows=1 loops=87,752)

  • Index Cond: (dvc_id = d.dvc_id)
171. 0.025 0.058 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
172. 0.033 0.033 ↑ 1.0 197 1

Seq Scan on org_tz dtfotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.006..0.033 rows=197 loops=1)

173. 0.080 0.154 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
174. 0.074 0.074 ↑ 1.0 457 1

Seq Scan on tz dtftz (cost=0.00..10.57 rows=457 width=39) (actual time=0.007..0.074 rows=457 loops=1)

175. 263.256 263.256 ↑ 1.0 1 87,752

Index Scan using drss_pk on drss (cost=0.29..0.36 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=87,752)

  • Index Cond: (dtf.drs_id = drs_id)
176. 0.029 0.067 ↑ 1.0 95 1

Hash (cost=7.95..7.95 rows=95 width=134) (actual time=0.067..0.067 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
177. 0.038 0.038 ↑ 1.0 95 1

Seq Scan on sites s (cost=0.00..7.95 rows=95 width=134) (actual time=0.007..0.038 rows=95 loops=1)

178. 147.676 1,316.280 ↑ 1.0 1 87,752

Nested Loop Left Join (cost=1.00..1.20 rows=1 width=1,235) (actual time=0.014..0.015 rows=1 loops=87,752)

179. 162.657 877.520 ↑ 1.0 1 87,752

Nested Loop Left Join (cost=0.71..0.86 rows=1 width=44) (actual time=0.009..0.010 rows=1 loops=87,752)

180. 351.008 351.008 ↑ 1.0 1 87,752

Index Scan using idx_drs_includes2 on drs_includes inc (cost=0.29..0.33 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=87,752)

  • Index Cond: (drs_id = drss.drs_id)
181. 363.855 363.855 ↑ 1.0 1 72,771

Index Scan using date_rules_pk on date_rules inc_rule (cost=0.42..0.53 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=72,771)

  • Index Cond: (inc.date_rule_id = date_rule_id)
182. 291.084 291.084 ↑ 1.0 1 72,771

Index Scan using date_rpt_patterns_pk on date_rpt_patterns inc_drule (cost=0.29..0.34 rows=1 width=1,207) (actual time=0.004..0.004 rows=1 loops=72,771)

  • Index Cond: (inc_rule.date_rule_id = date_rpt_pattern_id)
183. 0.027 0.067 ↑ 1.0 216 1

Hash (cost=9.16..9.16 rows=216 width=16) (actual time=0.067..0.067 rows=216 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
184. 0.040 0.040 ↑ 1.0 216 1

Seq Scan on addresses address (cost=0.00..9.16 rows=216 width=16) (actual time=0.007..0.040 rows=216 loops=1)

185. 0.002 0.008 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.008..0.008 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
186. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on org_languages psol (cost=0.00..1.04 rows=4 width=16) (actual time=0.005..0.006 rows=4 loops=1)

187. 0.010 0.027 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=23) (actual time=0.027..0.027 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
188. 0.017 0.017 ↑ 1.0 42 1

Seq Scan on languages psl (cost=0.00..1.42 rows=42 width=23) (actual time=0.011..0.017 rows=42 loops=1)

189. 0.026 0.056 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
190. 0.030 0.030 ↑ 1.0 197 1

Seq Scan on org_tz psotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.005..0.030 rows=197 loops=1)

191. 0.080 0.150 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
192. 0.070 0.070 ↑ 1.0 457 1

Seq Scan on tz pstz (cost=0.00..10.57 rows=457 width=39) (actual time=0.006..0.070 rows=457 loops=1)

193. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=14.87..14.87 rows=290 width=35) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
194. 0.001 0.006 ↓ 0.0 0 1

Hash Left Join (cost=1.20..14.87 rows=290 width=35) (actual time=0.006..0.006 rows=0 loops=1)

  • Hash Cond: (sh.org_holiday_id = oh.org_holiday_id)
195. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on site_holidays sh (cost=0.00..12.90 rows=290 width=16) (actual time=0.005..0.005 rows=0 loops=1)

196. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.09..1.09 rows=9 width=35) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Seq Scan on org_holidays oh (cost=0.00..1.09 rows=9 width=35) (never executed)

198. 0.047 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
199. 0.043 0.043 ↑ 1.0 197 1

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

200. 0.098 0.189 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=24) (actual time=0.189..0.189 rows=457 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
201. 0.091 0.091 ↑ 1.0 457 1

Seq Scan on tz stz (cost=0.00..10.57 rows=457 width=24) (actual time=0.008..0.091 rows=457 loops=1)

202. 0.000 0.000 ↓ 0.0 0 87,982

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

  • Index Cond: (dr.date_rule_id = date_rpt_pattern_id)
203. 0.023 0.068 ↑ 1.0 95 1

Hash (cost=7.95..7.95 rows=95 width=16) (actual time=0.068..0.068 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
204. 0.045 0.045 ↑ 1.0 95 1

Seq Scan on sites ghs (cost=0.00..7.95 rows=95 width=16) (actual time=0.009..0.045 rows=95 loops=1)

205. 0.039 0.069 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
206. 0.030 0.030 ↑ 1.0 197 1

Seq Scan on org_tz ghpsotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.005..0.030 rows=197 loops=1)

207. 0.128 0.197 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
208. 0.069 0.069 ↑ 1.0 457 1

Seq Scan on tz ghpstz (cost=0.00..10.57 rows=457 width=39) (actual time=0.005..0.069 rows=457 loops=1)

209. 0.035 0.066 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
210. 0.031 0.031 ↑ 1.0 197 1

Seq Scan on org_tz ghotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.006..0.031 rows=197 loops=1)

211. 0.092 0.160 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=24) (actual time=0.160..0.160 rows=457 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
212. 0.068 0.068 ↑ 1.0 457 1

Seq Scan on tz ghstz (cost=0.00..10.57 rows=457 width=24) (actual time=0.006..0.068 rows=457 loops=1)

213. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=46.24..46.24 rows=290 width=63) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
214. 0.001 0.006 ↓ 0.0 0 1

Hash Left Join (cost=32.12..46.24 rows=290 width=63) (actual time=0.005..0.006 rows=0 loops=1)

  • Hash Cond: (ghsh.org_holiday_id = ghoh.org_holiday_id)
215. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on site_holidays ghsh (cost=0.00..12.90 rows=290 width=16) (actual time=0.005..0.005 rows=0 loops=1)

216. 0.000 0.000 ↓ 0.0 0

Hash (cost=32.01..32.01 rows=9 width=63) (never executed)

217. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.42..32.01 rows=9 width=63) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Seq Scan on org_holidays ghoh (cost=0.00..1.09 rows=9 width=35) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Index Scan using date_rules_pk on date_rules ghdr (cost=0.42..3.44 rows=1 width=36) (never executed)

  • Index Cond: (ghoh.date_rule_id = date_rule_id)
220. 0.380 3.273 ↑ 1.7 1,978 1

Hash (cost=5,176.43..5,176.43 rows=3,447 width=8) (actual time=3.273..3.273 rows=1,978 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 110kB
221. 0.597 2.893 ↑ 1.7 1,978 1

Nested Loop (cost=0.43..5,176.43 rows=3,447 width=8) (actual time=0.181..2.893 rows=1,978 loops=1)

222. 0.010 0.156 ↑ 20.0 5 1

Result (cost=0.00..2.27 rows=100 width=8) (actual time=0.146..0.156 rows=5 loops=1)

223. 0.146 0.146 ↑ 20.0 5 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.139..0.146 rows=5 loops=1)

224. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

225. 2.140 2.140 ↓ 11.6 396 5

Index Scan using idx_live_ntfn4 on live_ntfn lntfn (cost=0.43..51.39 rows=34 width=16) (actual time=0.015..0.428 rows=396 loops=5)

  • Index Cond: (root_ntfn_id = (((json_object_keys('{"1288350402":[200251],"1291081000":[200143,200153,200168,200170,200200,200204,200206,200212,200216,200240,200242,200250,200252,200562,200563,200569,200571,200587,200592,200593,200594,200595,200601,200602,200607,200616,200618,200624,200643,200644,200675,200680,200691,200701,200704,200711,200726,200738,200764,200765,200766,200773,200775,200780,200781,200801,200810,200818,200819,200831,200834,200837,200843,200871,200875,200876,200880,200883,200886,200904,200906,200910,200913,200920,200927,200937,200940,200941,200944,200950,200961,200976,200988,200990,200997,201000,201001,201003,201008,201010,201011,201015,201021,201024,201026,201049,201052,201057,201058,201060,201067,201076,201079,201088,201097,201110,201114,201117,201121,201123,201126,201132,201139,201143,201152,201157,201159,201162,201165,201172,201173,201185,201189,201197,201200,201201,201202,201204,201205,201207,201220,201223,201226,201238,201243,201244,201264,201269,201270,201279,201297,201298,201302,201314,201330,201336,201338,201365,201367,201372,201382,201394,201399,201409,201412,201422,201432,201433,201435,201439,201446,201447,201460,201463,201544,201552,201556,201572,201581,201633,201658,201808,201831,201863,201879,201885,201891,201949,201951,201956,201958,202000,202003,202025,202038,202041,202045,202082,202083,202084,202085,202096,202101,202103,202104,202111,202119,202125,202137,202179,202185,202197,202233,202235,202236,202277,202328,202333,202351,202357,202359,202360,202363,202378,202430,202440,202451,202491,202504,202515,202516,202518,202524,202525,202531,202551,202579,202592,202603,202619,202638,202644,202666,202675,202679,202680,202682,202719,202734,202766,202771,202773,202781,202782,202785,202806,202810,202812,202819,202825,202830,202835,202848,202916,202934,202941,202970,202989,203046,203077,203083,203156,203164,203193,203242,203253,203256,203294,203329,203330,203340,203343,203349,203353,203359,203396,203445,203449,203455,203487,203513,203539,203546,203621,203625,203652,203660,203677,203679,203689,203690,203729,203733,203737,203738,203741,203743,203754,203768,203770,203771,203788,203810,203822,203828,203830,203841,203866,203927,203934,203940,203951,203987,203991,204001,204043,204070,204138,204163,204167,204178,204193,204205,204214,204266,204267,204277,204285,204299,204300,204304,204318,204319,204335,204352,204360,204407,204436,204460,204472,204486,204493,204499,204508,204517,204546,204549,204554,204558,204566,204601,204608,204633,204643,204669,204692,204697,204706,204713,204722,204723,204734,204736,204766,204795,204796,204840,204854,204866,204869,204901,204936,204938,204939,204941,204955,204982,204983,204989,205000,205002,205015,205021,205051,205052,205101,205114,205135,205141,205179,205198,205199,205211,205215,205217,205267,205276,205295,205306,205307,205317,205318,205319,205348,205355,205362,205365,205373,205461,205474,205486,205503,205521,205532,205539,205554,205623,205636,205645,205664,205665,205667,205675,205684,205687,205690,205691,205693,205702,205725,205726,205731,205737,205740,205748,205758,205761,205768,205784,205786,205795,205808,205809,205813,205831,205865,205868,205872,205873,205885,205892,205907,205910,205923,205924,205943,205967,205971,205974,205988,206000,206043,206046,206057,206060,206068,206096,206097,206112,206132,206140,206141,206154,206164,206180,206185,206186,206190,206193,206197,206201,206215,206223,206230,206232,206248,206270,206278,206298,206309,206330,206342,206347,206353,206359,206361,206401,206410,206439,206444,206456,206457,206467,206480,206490,206500,206501,206515,206522,206525,206530,206532,206533,206548,206576,206582,206597,206655,206661,206665,206685,206691,206710,206736,206746,206748,206749,206777,206788,206798,206799,206812,206813,206814,206835,206859,206861,206863,206864,206893,206902,206906,206907,206923,206931,206934,206944,206968,206984,207009,207015,207048,207081,207082,207090,207094,207105,207107,207108,207110,207115,207119,207120,207122,207141,207155,207158,207161,207181,207190,207199,207207,207243,207248,207249,207291,207310,207324,207335,207350,207361,207371,207388,207399,207402,207413,207423,207443,207459,207475,207476,207479,207484,207487,207498,207502,207505,207520,207541,207561,207566,207567,207584,207602,207617,207649,207652,207673,207689,207725,207740,207744,207749,207752,207759,207761,207764,207791,207797,207807,207812,207845,207855,207864,207893,207910,207911,207925,207938,207949,207954,207963,207964,207970,207972,207979,207984,208000,208004,208013,208020,208022,208024,208077,208091,208097,208111,208138,208141,208145,208151,208155,208164,208167,208185,208189,208206,208207,208210,208222,208231,208272,208289,208291,208294,208297,208307,208310,208321,208340,208348,208349,208389,208392,208395,208396,208426,208455,208476,208486,208508,208510,208540,208585,208589,208594,208603,208623,208631,208636,208637,208641,208654,208696,208713,208715,208729,208735,208741,208744,208758,208761,208763,208771,208772,208777,208786,208812,208814,208815,208819,208825,208828,208835,208841,208846,208848,208849,208852,208883,208896,208897,208902,208908,208914,208918,208928,208930,208946,208956,208964,208970,208974,208975,208977,208993,209007,209030,209031,209044,209045,209047,209067,209082,209103,209130,209156,209163,209174,209198,209199,209208,209227,209246,209253,209254,209259,209274,209278,209282,209283,209284,209286,209323,209335,209347,209364,209390,209413,209418,209437,209440,209462,209487,209510,209515,209558,209566,209572,209594,209603,209604,209654,209664,209673,209674,209677,209707,209725,209732,209750,209765,209780,209783,209835,209839,209873,209878,209882,209887,209890,209923,209966,209972,209977,209983,209990,210000,210004,210009,210026,210040,210050,210054,210062,210084,210088,210108,210111,210123,210136,210142,210144,210147,210169,210221,210226,210251,210257,210266,210272,210276,210279,210281,210285,210307,210313,210327,210335,210339,210340,210344,210347,210351,210352,210354,210356,210358,210360,210368,210369,210373,210384,210392,210396,210412,210424,210425,210428,210431,210436,210441,210447,210448,210450,210453,210460,210462,210464,210473,210476,210477,210480,210485,210491,210495,210507,210509,210513,210518,210519,210526,210536,210541,210545,210546,210547,210556,210576,210591,210594,210597,210603,210604,210611,210617,210618,210630,210633,210652,210657,210658,210661,210663,210667,210671,210672,210688,210689,210691,210693,210695,210704,210713,210716,210717,210720,210722,210732,210747,210748,210752,210757,210763,210767,210779,210782,210786,210788,210797,210813,210822,210826,210827,210832,210837,210841,210856,210864,210870,210877,210884,210896,210907,210910,210913,210916,210926,210927,210942,210950,210955,210972,210983,210984,210987,210988,210996,210998,211016,211017,211022,211024,211026,211032,211036,211050,211051,211063,211065,211066,211071,211078,211079,211084,211092,211093,211110,211112,211113,211114,211121,211126,211127,211132,211137,211141,211157,211158,211164,211170,211172,211180,211182,211183,211185,211189,211190,211193,211194,211197,211198,211199,211200,211207,211214,211215,211219,211222,211223,211226,211227,211230,211233,211235,211236,211240,211241,211243,211250,211251,211254,211255,211257,211260,211261,211266,211271,211273,346538,346555,346706,346778,346879,346885,346886,346890,346891,346916,346925,346934,346950,346956,346958,346959,346971,353473,353474,353501,353535,360031,360032,360033,360034,361088,361092,361100,361101,361127,361147,361185,361212,361216,361226,361232,361240,361327,361363,361404,361412,361428,361431,361443,361474,361500,361521,361556,361557,361558,361559,361560,361562,361577,361639,361696,361760,361793,361829,361867,361919,361999,362018,362057,362084,362191,362201,362222,362237,362295,362309,362330,362339,362344,362383,362392,362400,362415,362418,362494,362517,362553,362559,362566,362579,362584,362609,362610,362631,362646,362683,362723,362746,362955,362972,362980,362991,363008,363070,363077,363097,363115,363116,371584,371589,371607,371613,371900,371902,371911,372004,372008,372148,372166,372323,372327,372358,372669,372674,373958,373992,373998,374024,374029,374030,374031,374171,374179,374182,374232,374235,374239,374247,374249,374251,374310,374348,374350,374354,374382,374496,374497,374500,374505,374528,374602,374604,374671,374672,374675,375870,375896,375898,375912,375916,375922,375924,375938,375942,375948,375954,375961,375972,376009,376050,376077,376098,376126,376139,376179,376192,376203,376260,376282,376283,376328,376330,376340,376344,376347,376370,376382,376393,376411,376423,376426,376448,376469,376470,376473,376479,376486,376490,376507,376546,376562,376568,376574,376577,376581,376582,376593,376601,376640,376651,376675,376698,376748,376754,376760,376782,376787,376811,376830,376835,376837,376847,376852,382098,382283,382284,382293,382299,382390,382392,382613,383000,383030,383032,383547,383548,383549,383585,383587,383771,383892,384119,384121,384181,384200,384254,384322,384332,384403,384430,384444,384622,384629,384684,384685,384752,384754,384761,384941,384944,384954,384957,384959,385234,385235,385264,385280,385353,385361,385614,385615,385720,385734,385735,385794,385795,386426,386471,386570,386571,386646,386647,386689,386722,386902,386918,386927,386930,386931,387059,387065,387230,387253,387271,387417,387419,387420,387421,387598,387793,387794,387795,388006,388010,388029,388033,388164,388165,388205,388208,388277,388298,388394,388417,388443,388447,388448,388613,388623,388629,388649,388650,388771,388846,388847,388848,388858,388865,389009,389010,389013,389014,389015,389139,389164,389165,389213,389529,389676,389682,389683,389688,389689,389767,390014,393353,393604,394023,394045,394929,396291,396362,396447,400481,401095,401156,401306,401414,401696,401895,401905,402235,402236,402238,403570,403810,403961,403964,403968,404080,404638,405799,406035,406036,408392,409419,409908,409942,409946,409966,410192,410220,410385,410952,411288,411301,411515,412150,412270,412414,412449,412631,412681,412708,413414,413891,413893,414217,414454,414469,414472,414725,414726,414751,417236,417241,417315,417319,417408,417421,417681,417716,417759,417886,437601,437794,438060,438073,438075,438078,438090,464762,465296,465992,469616,475745,476668,477823,478766,479198,479337,482171,482384,482386,482387,482388,482389,491157,491158],"1291081001":[200143,201204,202097,202520,203322,203541,203774,204285,205319,206068,206141,207911,209358,209681,374239,375924,375977,376287,376312,376338,376368,376447,376519,376547,376602,376639,376649,376663,376741,376766,376778,376793,376794,376832,376839,414751,417242,438080,451137,478765],"1291081002":[200143,201204,201412,201779,201801,201824,201850,201852,201894,201910,201945,201967,201989,202002,202006,202019,202023,202028,202086,202148,202155,202161,202186,202223,202231,202234,202248,202263,202264,202280,202307,202309,202340,202371,202375,202427,202441,202448,202457,202508,202520,202533,202545,202582,202624,202671,202713,202763,202774,202816,202873,203077,203081,203140,203148,203154,203245,203248,203272,203292,203321,203322,203394,203437,203482,203524,203529,203541,203547,203563,203583,203751,203766,203774,203798,203813,203824,203879,203967,204007,204151,204218,204259,204269,204285,204666,204701,204829,204845,204958,204974,205023,205085,205134,205283,205319,205327,205330,205431,205452,205465,205493,205507,205511,205542,205618,205630,205633,205651,205672,205789,205835,205928,205942,205948,206064,206068,206128,206130,206187,206268,206269,206312,206358,206392,206405,206406,206509,206595,206641,206648,206649,206692,206753,206783,206856,206952,207001,207017,207099,207200,207281,207513,207523,207572,207589,207618,207780,207888,207896,207975,208014,208063,208121,208181,208366,208369,208371,208404,208408,208441,208461,208522,208572,208581,208869,208873,208936,208954,208961,209026,209087,209182,209200,209257,209548,209593,209645,209660,209665,209700,209791,209894,210186,210196,210246,210283,210296,361361,361372,361373,361374,361390,361393,361396,361411,361416,361421,361429,361434,361435,361458,361460,361464,361469,361473,361494,361520,361522,361563,361565,361581,361604,361611,361619,361620,361629,361637,361645,361657,361659,361663,361684,361695,361710,361719,361742,361775,361995,362189,362386,362462,362539,362702,362840,362902,362919,363021,363046,371596,374771,375842,375852,375864,375865,375867,375868,375878,375886,375890,375895,375897,375899,375903,375908,375909,375919,375922,375923,375924,375926,375940,375943,375953,375959,375960,375963,375964,375973,375987,376024,376070,376075,376090,376091,376136,376147,376215,376220,376235,376271,376278,376316,376321,376380,376401,376429,376511,376514,376517,376519,376528,376603,376618,376632,376645,376670,376737,376738,376755,376764,376783,376842,376845,383980,386555,402183,414751,417759,451137],"1291081003":[200143,201204,201779,201801,201824,201850,201852,201894,201910,201945,201967,201989,202002,202006,202019,202023,202028,202042,202086,202148,202155,202161,202186,202223,202231,202234,202248,202263,202264,202280,202307,202309,202340,202371,202375,202427,202441,202448,202457,202508,202520,202533,202545,202582,202624,202671,202713,202774,202816,202873,203077,203081,203140,203148,203154,203248,203272,203279,203292,203321,203322,203355,203394,203437,203482,203524,203529,203541,203547,203563,203583,203751,203752,203766,203774,203798,203824,203879,203967,204007,204151,204218,204259,204269,204285,204666,204701,204829,204845,204958,204974,205023,205085,205134,205283,205319,205327,205330,205431,205452,205465,205493,205507,205511,205542,205618,205630,205633,205651,205672,205928,205942,205948,206064,206068,206128,206130,206187,206268,206269,206312,206358,206392,206405,206406,206426,206509,206595,206641,206648,206649,206692,206753,206856,206952,207001,207017,207099,207200,207281,207400,207513,207523,207572,207589,207618,207780,207851,207888,207896,207975,208014,208063,208121,208335,208366,208369,208371,208404,208408,208441,208459,208461,208522,208544,208572,208581,208869,208873,208936,208942,208954,208961,209026,209087,209088,209182,209200,209257,209548,209593,209645,209660,209665,209700,209770,209791,209894,210186,210196,210246,210283,210296,361361,361372,361373,361374,361390,361393,361396,361411,361416,361420,361421,361429,361434,361435,361458,361460,361464,361469,361473,361477,361494,361520,361522,361563,361565,361581,361604,361611,361619,361620,361625,361629,361637,361645,361646,361657,361659,361663,361684,361695,361710,361719,361742,361775,361995,362189,362327,362386,362462,362539,362702,362840,362902,362919,362933,363021,363046,371596,374771,375843,375853,375856,375859,375863,375866,375872,375875,375878,375879,375883,375909,375915,375917,375920,375923,375924,375952,375957,375960,375967,375968,375975,375976,375986,375987,375994,376001,376005,376024,376034,376093,376112,376115,376136,376145,376168,376180,376184,376218,376286,376299,376314,376333,376360,376362,376375,376430,376442,376502,376519,376528,376534,376541,376552,376586,376589,376606,376608,376609,376618,376619,376632,376643,376645,376665,376703,376705,376724,376733,376734,376737,376750,376764,376808,376815,376821,376841,383980,386555,402183,414751,417759,451137]}'::json)))::bigint))
226. 0.000 0.000 ↓ 0.0 0 71,620

Index Scan using date_rpt_patterns_pk on date_rpt_patterns ghdrp (cost=0.29..0.34 rows=1 width=1,207) (actual time=0.000..0.000 rows=0 loops=71,620)

  • Index Cond: (ghdr.date_rule_id = date_rpt_pattern_id)
227. 0.573 0.979 ↑ 1.0 3,299 1

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

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

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

  • Heap Fetches: 0
229. 0.907 1.556 ↓ 1.0 4,472 1

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

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

Seq Scan on date_rng ghonetimedrng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.009..0.649 rows=4,472 loops=1)

231. 1.078 2.144 ↓ 1.0 4,101 1

Hash (cost=126.75..126.75 rows=4,075 width=29) (actual time=2.144..2.144 rows=4,101 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 323kB
232. 1.066 1.066 ↓ 1.0 4,101 1

Seq Scan on tm_escalation tesc (cost=0.00..126.75 rows=4,075 width=29) (actual time=0.011..1.066 rows=4,101 loops=1)

233. 71.620 1,217.540 ↓ 0.0 0 71,620

Limit (cost=22.03..22.04 rows=1 width=17) (actual time=0.017..0.017 rows=0 loops=71,620)

234. 214.860 1,145.920 ↓ 0.0 0 71,620

Sort (cost=22.03..22.04 rows=1 width=17) (actual time=0.016..0.016 rows=0 loops=71,620)

  • Sort Key: dr_1.start_date
  • Sort Method: quicksort Memory: 25kB
235. 428.610 931.060 ↓ 0.0 0 71,620

Nested Loop (cost=3.94..22.02 rows=1 width=17) (actual time=0.013..0.013 rows=0 loops=71,620)

236. 71.620 501.340 ↓ 0.0 0 71,620

Bitmap Heap Scan on tmp_rpmt tr (cost=3.66..18.62 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=71,620)

  • Recheck Cond: ((tmper_id = d.person_id) OR (tmper_id = p.person_id))
  • Filter: (((rpmt_type)::text = 'VACANCY'::text) AND ((grp_id IS NULL) OR ((grp_id IS NOT NULL) AND (array_length(z.chain_ids, 1) > 2) AND (((z.chain_ids)[(array_length(z.chain_ids, 1) - 2)] = grp_id) OR ((z.chain_ids)[(array_length(z.chain_ids, 1) - 3)] = grp_id)))))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=17252
237. 143.240 429.720 ↓ 0.0 0 71,620

BitmapOr (cost=3.66..3.66 rows=14 width=0) (actual time=0.006..0.006 rows=0 loops=71,620)

238. 214.860 214.860 ↓ 0.0 0 71,620

Bitmap Index Scan on idx_tmp_rpmt3 (cost=0.00..1.83 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=71,620)

  • Index Cond: (tmper_id = d.person_id)
239. 71.620 71.620 ↓ 0.0 0 71,620

Bitmap Index Scan on idx_tmp_rpmt3 (cost=0.00..1.83 rows=7 width=0) (actual time=0.001..0.001 rows=0 loops=71,620)

  • Index Cond: (tmper_id = p.person_id)
240. 1.110 1.110 ↓ 0.0 0 370

Index Scan using idx_date_rng_date_rng_id_desc_end_date_desc on date_rng dr_1 (cost=0.28..3.30 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=370)

  • Index Cond: ((date_rng_id = tr.date_rng_id) AND ('2019-08-01 06:26:35.487-07'::timestamp with time zone <= end_date))
  • Filter: ('2019-08-01 06:26:35.487-07'::timestamp with time zone >= start_date)
  • Rows Removed by Filter: 0