explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Su03

Settings
# exclusive inclusive rows x rows loops node
1. 470.422 30,003.851 ↓ 35.7 71,600 1

Sort (cost=70,507,479.77..70,507,484.79 rows=2,007 width=9,269) (actual time=29,992.857..30,003.851 rows=71,600 loops=1)

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

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

3. 189.490 11,730.356 ↓ 35.7 71,600 1

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

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

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

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

  • Hash Cond: (ghdr.date_rule_id = ghdrngs.drngs_id)
6. 153.191 11,315.979 ↓ 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,728.861..11,315.979 rows=71,600 loops=1)

7. 117.149 11,162.788 ↓ 35.7 71,600 1

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

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 119.227 11,042.518 ↓ 41.8 87,942 1

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (g.site_id = ghs.site_id)
14. 191.453 10,357.760 ↓ 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,724.956..10,357.760 rows=87,942 loops=1)

15. 114.339 10,166.307 ↓ 60.6 87,942 1

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

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

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

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

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

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

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

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

  • Heap Fetches: 0
20. 0.901 1.734 ↓ 1.0 4,477 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 309kB
21. 0.833 0.833 ↓ 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.833 rows=4,477 loops=1)

22. 138.821 9,721.075 ↓ 60.6 87,942 1

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

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

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

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

25. 322.534 9,461.496 ↓ 60.6 87,942 1

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

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

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

  • Hash Cond: (s.site_id = sh.site_id)
27. 95.564 9,041.855 ↓ 87.9 87,942 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (s.address_id = address.address_id)
32. 151.852 8,555.009 ↓ 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,045.280..8,555.009 rows=87,942 loops=1)

33. 98.282 7,526.037 ↓ 87.7 87,712 1

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

  • Hash Cond: (p.site_id = s.site_id)
34. 176.791 7,427.687 ↓ 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,045.185..7,427.687 rows=87,712 loops=1)

35. 103.106 7,075.472 ↓ 87.7 87,712 1

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

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

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

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
37. 131.282 6,865.254 ↓ 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,044.937..6,865.254 rows=87,712 loops=1)

38. 100.515 6,470.836 ↓ 87.7 87,712 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
43. 80.473 6,043.709 ↓ 87.7 87,712 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
57. 108.364 4,898.096 ↓ 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,043.719..4,898.096 rows=87,712 loops=1)

58. 75.224 4,614.308 ↓ 87.7 87,712 1

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

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

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

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
60. 91.732 4,461.468 ↓ 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,043.679..4,461.468 rows=87,712 loops=1)

61. 71.616 4,194.312 ↓ 87.7 87,712 1

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

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

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

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

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

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

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

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
65. 119.619 3,893.544 ↓ 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,043.347..3,893.544 rows=87,712 loops=1)

66. 72.243 3,598.501 ↓ 87.7 87,712 1

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

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

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

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
68. 108.151 3,453.265 ↓ 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,040.940..3,453.265 rows=87,712 loops=1)

69. 101.130 3,345.114 ↓ 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,040.933..3,345.114 rows=87,712 loops=1)

70. 61.863 3,243.984 ↓ 87.7 87,712 1

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

  • Hash Cond: (gdrules.date_rule_id = ghdhc.date_holiday_cntner_id)
71. 104.905 3,182.113 ↓ 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,040.894..3,182.113 rows=87,712 loops=1)

72. 59.397 3,077.208 ↓ 87.7 87,712 1

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

  • Hash Cond: (gtfotz.tz_id = gtftz.tz_id)
73. 55.836 3,017.634 ↓ 87.7 87,712 1

Hash Left Join (cost=1,458.14..9,213.44 rows=1,000 width=1,175) (actual time=1,040.699..3,017.634 rows=87,712 loops=1)

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
74. 101.962 2,961.729 ↓ 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,040.620..2,961.729 rows=87,712 loops=1)

75. 68.197 2,859.767 ↓ 87.7 87,712 1

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

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
76. 92.836 2,789.751 ↓ 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,038.768..2,789.751 rows=87,712 loops=1)

77. 95.632 2,696.915 ↓ 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,038.760..2,696.915 rows=87,712 loops=1)

78. 175.802 2,601.283 ↓ 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,038.753..2,601.283 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. 49.410 2,250.057 ↓ 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,038.744..2,250.057 rows=87,712 loops=1)

80. 69.225 2,112.935 ↓ 87.7 87,712 1

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

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

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

82. 55.396 1,640.029 ↓ 87.7 87,712 1

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

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

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

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

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

85. 1,053.564 1,053.564 ↓ 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,026.393..1,053.564 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.140 0.390 ↑ 1.0 777 1

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

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

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

89. 0.827 2.395 ↓ 1.0 4,461 1

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

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

Seq Scan on tm t (cost=0.00..159.53 rows=4,453 width=594) (actual time=0.016..1.568 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.972 9.421 ↑ 1.0 18,045 1

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

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

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

94. 87.712 87.712 ↓ 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.001..0.001 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.723 1.819 ↓ 1.0 4,232 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 327kB
99. 1.096 1.096 ↓ 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.096 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.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
102. 0.044 0.044 ↑ 1.0 197 1

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

103. 0.084 0.177 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.177..0.177 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.008..0.093 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.386 0.853 ↑ 1.0 3,299 1

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

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

  • Heap Fetches: 0
115. 0.631 1.507 ↓ 1.0 4,477 1

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

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

Seq Scan on date_rng gdaterng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.014..0.876 rows=4,477 loops=1)

117. 175.424 175.424 ↓ 0.0 0 87,712

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

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

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

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

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

120. 0.041 0.114 ↑ 1.0 185 1

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

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

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

122. 0.054 0.147 ↑ 1.0 267 1

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

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

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

124. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=234) (actual time=0.006..0.006 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. 175.424 175.424 ↓ 0.0 0 87,712

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.002..0.002 rows=0 loops=87,712)

  • Index Cond: (dvc_id = d.dvc_id)
127. 0.000 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.005 0.005 ↓ 0.0 0 1

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

129. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=674) (actual time=0.005..0.005 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. 175.424 175.424 ↓ 0.0 0 87,712

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

  • 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.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
135. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on im_dvc_dtl imdvc (cost=0.00..11.70 rows=170 width=226) (actual time=0.004..0.004 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.000 0.004 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=226) (actual time=0.004..0.004 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.012 ↑ 1.0 4 1

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

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

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

142. 0.010 0.025 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=23) (actual time=0.025..0.025 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.059 ↑ 1.0 197 1

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

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

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

146. 0.076 0.152 ↑ 1.0 457 1

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

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

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

148. 0.003 0.010 ↑ 1.0 4 1

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

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

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

150. 0.010 0.022 ↑ 1.0 42 1

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

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

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

152. 0.025 0.057 ↑ 1.0 197 1

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

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

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

154. 0.077 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
155. 0.073 0.073 ↑ 1.0 457 1

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

156. 0.030 0.093 ↑ 1.0 95 1

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

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

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

158. 0.027 0.089 ↑ 1.0 216 1

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

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

Seq Scan on addresses dowaddress (cost=0.00..9.16 rows=216 width=16) (actual time=0.010..0.062 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.005..0.006 rows=4 loops=1)

162. 0.010 0.022 ↑ 1.0 42 1

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

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

Seq Scan on languages dowsl (cost=0.00..1.42 rows=42 width=23) (actual time=0.005..0.012 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.081 0.153 ↑ 1.0 457 1

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

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

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

168. 0.014 0.040 ↑ 1.0 59 1

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

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

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

170. 263.136 263.136 ↑ 1.0 1 87,712

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

  • Index Cond: (dvc_id = d.dvc_id)
171. 0.024 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
172. 0.031 0.031 ↑ 1.0 197 1

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

173. 0.079 0.159 ↑ 1.0 457 1

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

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

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

175. 175.424 175.424 ↑ 1.0 1 87,712

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

  • Index Cond: (dtf.drs_id = drs_id)
176. 0.028 0.068 ↑ 1.0 95 1

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

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

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

178. 44.883 877.120 ↑ 1.0 1 87,712

Nested Loop Left Join (cost=1.00..1.20 rows=1 width=1,235) (actual time=0.009..0.010 rows=1 loops=87,712)

179. 132.595 613.984 ↑ 1.0 1 87,712

Nested Loop Left Join (cost=0.71..0.86 rows=1 width=44) (actual time=0.006..0.007 rows=1 loops=87,712)

180. 263.136 263.136 ↑ 1.0 1 87,712

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

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

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

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

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.003..0.003 rows=1 loops=72,751)

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

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

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

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

185. 0.003 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.008..0.009 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.009 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
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.024 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
190. 0.031 0.031 ↑ 1.0 197 1

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

191. 0.113 0.182 ↑ 1.0 457 1

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

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

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

193. 0.001 0.009 ↓ 0.0 0 1

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

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

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

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

Seq Scan on site_holidays sh (cost=0.00..12.90 rows=290 width=16) (actual time=0.007..0.007 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.040 0.085 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
199. 0.045 0.045 ↑ 1.0 197 1

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

200. 0.108 0.200 ↑ 1.0 457 1

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

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

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

202. 0.000 0.000 ↓ 0.0 0 87,942

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

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

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

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

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

205. 0.034 0.064 ↑ 1.0 197 1

Hash (cost=4.97..4.97 rows=197 width=16) (actual time=0.064..0.064 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.006..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.034 0.064 ↑ 1.0 197 1

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

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

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

211. 0.098 0.164 ↑ 1.0 457 1

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

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

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

213. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=46.24..46.24 rows=290 width=63) (actual time=0.007..0.007 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.006..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.381 3.121 ↑ 1.8 1,978 1

Hash (cost=5,429.11..5,429.11 rows=3,608 width=8) (actual time=3.121..3.121 rows=1,978 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 110kB
221. 0.587 2.740 ↑ 1.8 1,978 1

Nested Loop (cost=0.43..5,429.11 rows=3,608 width=8) (actual time=0.200..2.740 rows=1,978 loops=1)

222. 0.010 0.173 ↑ 20.0 5 1

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

223. 0.162 0.163 ↑ 20.0 5 1

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

224. 0.001 0.001 ↑ 1.0 1 1

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

225. 1.980 1.980 ↓ 11.0 396 5

Index Scan using idx_live_ntfn4 on live_ntfn lntfn (cost=0.43..53.90 rows=36 width=16) (actual time=0.013..0.396 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,600

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

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

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

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

  • Heap Fetches: 0
229. 0.874 1.606 ↓ 1.0 4,477 1

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

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

Seq Scan on date_rng ghonetimedrng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.011..0.732 rows=4,477 loops=1)

231. 1.041 2.072 ↓ 1.0 4,102 1

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

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

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

233. 143.200 1,288.800 ↓ 0.0 0 71,600

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

234. 214.800 1,145.600 ↓ 0.0 0 71,600

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

  • Sort Key: dr_1.start_date
  • Sort Method: quicksort Memory: 25kB
235. 428.120 930.800 ↓ 0.0 0 71,600

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

236. 71.600 501.200 ↓ 0.0 0 71,600

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

  • 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=17462
237. 71.600 429.600 ↓ 0.0 0 71,600

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

238. 286.400 286.400 ↓ 0.0 0 71,600

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

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

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

  • Index Cond: (tmper_id = p.person_id)
240. 1.480 1.480 ↓ 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.004..0.004 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
241.          

SubPlan (forNested Loop Left Join)

242. 71.600 71.600 ↑ 1.0 1 71,600

Aggregate (cost=4.90..4.91 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=71,600)

243. 0.000 0.000 ↓ 0.0 0 71,600

Index Only Scan using idx_tm_mbrships1 on tm_mbrships tm (cost=0.28..4.88 rows=6 width=0) (actual time=0.000..0.000 rows=0 loops=71,600)

  • Index Cond: (tm_id = t.tm_id)
  • Heap Fetches: 0
244. 214.800 286.400 ↑ 1.0 1 71,600

Aggregate (cost=7.44..7.45 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=71,600)

245. 71.600 71.600 ↓ 0.0 0 71,600

Bitmap Heap Scan on tm_escalation te (cost=1.81..7.43 rows=4 width=8) (actual time=0.001..0.001 rows=0 loops=71,600)

  • Recheck Cond: (tm_id = t.tm_id)
246. 0.000 0.000 ↓ 0.0 0 71,600

Bitmap Index Scan on idx_tm_escalation1 (cost=0.00..1.81 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=71,600)

  • Index Cond: (tm_id = t.tm_id)
247. 71.600 214.800 ↑ 1.0 1 71,600

Aggregate (cost=7.84..7.85 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=71,600)

248. 143.200 143.200 ↑ 4.0 1 71,600

Index Scan using idx_dvc_person_id_not_deleted on dvc activedevice (cost=0.29..7.83 rows=4 width=0) (actual time=0.001..0.002 rows=1 loops=71,600)

  • Index Cond: (person_id = p.person_id)
  • Filter: ((status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 0
249. 100.400 15,479.421 ↑ 1.0 1 251

Aggregate (cost=35,074.45..35,074.46 rows=1 width=8) (actual time=61.671..61.671 rows=1 loops=251)

250. 2,438.465 15,379.021 ↑ 40.9 1,851 251

HashAggregate (cost=33,368.99..34,126.97 rows=75,798 width=8) (actual time=60.499..61.271 rows=1,851 loops=251)

  • Group Key: rntfn.recipient_id
251. 931.712 12,940.556 ↑ 1.5 52,129 251

Append (cost=7.87..33,179.50 rows=75,798 width=8) (actual time=0.056..51.556 rows=52,129 loops=251)

252. 2.008 2.761 ↓ 0.0 0 251

Nested Loop (cost=7.87..1,616.96 rows=2 width=8) (actual time=0.011..0.011 rows=0 loops=251)

253. 0.502 0.753 ↓ 0.0 0 251

Bitmap Heap Scan on recipient_ntfn rntfn (cost=7.47..771.34 rows=521 width=16) (actual time=0.003..0.003 rows=0 loops=251)

  • Recheck Cond: (recipient_id = dowr.recipient_id)
254. 0.251 0.251 ↓ 0.0 0 251

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..7.34 rows=521 width=0) (actual time=0.001..0.001 rows=0 loops=251)

  • Index Cond: (recipient_id = dowr.recipient_id)
255. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_ntfn_ntfn_id_not_delinked_pidx on person_ntfn pntfn (cost=0.41..1.62 rows=1 width=8) (never executed)

  • Index Cond: (ntfn_id = rntfn.ntfn_id)
  • Heap Fetches: 0
256. 1,853.384 12,006.083 ↑ 1.5 52,129 251

Nested Loop (cost=1.13..30,804.56 rows=75,796 width=8) (actual time=0.044..47.833 rows=52,129 loops=251)

257. 701.294 4,966.035 ↑ 1.2 6,888 251

Nested Loop (cost=0.83..26,163.42 rows=8,581 width=8) (actual time=0.030..19.785 rows=6,888 loops=251)

258. 806.965 806.965 ↑ 1.2 6,888 251

Index Only Scan Backward using person_ntfn_ntfn_id_not_delinked_pidx on person_ntfn pntfn_1 (cost=0.41..1,639.92 rows=8,581 width=8) (actual time=0.016..3.215 rows=6,888 loops=251)

  • Heap Fetches: 1589934
259. 3,457.776 3,457.776 ↑ 1.0 1 1,728,888

Index Scan using recipient_ntfn_pk on recipient_ntfn rntfn_1 (cost=0.43..2.86 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,728,888)

  • Index Cond: (ntfn_id = pntfn_1.ntfn_id)
260. 5,186.664 5,186.664 ↑ 1.1 8 1,728,888

Index Only Scan using sup20086_recipient_id_idx on sup20086 (cost=0.29..0.45 rows=9 width=8) (actual time=0.002..0.003 rows=8 loops=1,728,888)

  • Index Cond: (recipient_id = rntfn_1.recipient_id)
  • Heap Fetches: 13084379
Planning time : 61.732 ms
Execution time : 30,015.778 ms