explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AUli

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

Sort (cost=6,744,561.84..6,744,566.87 rows=2,012 width=9,269) (actual time=15,763.670..15,775.669 rows=71,620 loops=1)

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

Nested Loop Left Join (cost=25,979.04..6,744,451.44 rows=2,012 width=9,269) (actual time=10,218.983..15,295.355 rows=71,620 loops=1)

3. 180.978 12,224.085 ↓ 35.6 71,620 1

Hash Left Join (cost=25,957.01..27,854.72 rows=2,012 width=9,236) (actual time=10,218.738..12,224.085 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. 109.721 12,040.341 ↓ 35.6 71,620 1

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

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

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

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

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

7. 103.853 11,665.147 ↓ 35.6 71,620 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
12. 111.967 11,063.222 ↓ 60.6 87,982 1

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

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

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

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

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

15. 105.747 10,640.387 ↓ 60.6 87,982 1

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

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

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

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

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

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

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

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

  • Heap Fetches: 0
20. 0.817 1.648 ↓ 1.0 4,472 1

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

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

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

22. 140.396 10,202.346 ↓ 60.6 87,982 1

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

  • Buckets: 131072 (originally 2048) Batches: 1 (originally 1) Memory Usage: 46583kB
23. 118.416 10,061.950 ↓ 60.6 87,982 1

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

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

25. 344.236 9,943.516 ↓ 60.6 87,982 1

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (s.org_language_id = psol.org_language_id)
31. 99.411 9,092.725 ↓ 87.9 87,982 1

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

  • Hash Cond: (s.address_id = address.address_id)
32. 124.337 8,993.245 ↓ 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,187.275..8,993.245 rows=87,982 loops=1)

33. 100.853 7,903.636 ↓ 87.8 87,752 1

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

  • Hash Cond: (p.site_id = s.site_id)
34. 104.442 7,802.702 ↓ 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,187.167..7,802.702 rows=87,752 loops=1)

35. 111.887 7,435.004 ↓ 87.8 87,752 1

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

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

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

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
37. 171.527 7,216.766 ↓ 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,186.935..7,216.766 rows=87,752 loops=1)

38. 100.243 6,781.983 ↓ 87.8 87,752 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
46. 80.907 6,093.626 ↓ 87.8 87,752 1

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

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
47. 82.690 6,012.660 ↓ 87.8 87,752 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
57. 127.615 5,164.414 ↓ 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,185.632..5,164.414 rows=87,752 loops=1)

58. 80.104 4,861.295 ↓ 87.8 87,752 1

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

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

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

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
60. 109.633 4,702.772 ↓ 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,185.590..4,702.772 rows=87,752 loops=1)

61. 82.383 4,417.635 ↓ 87.8 87,752 1

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

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

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

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

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

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

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

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

66. 79.778 3,801.459 ↓ 87.8 87,752 1

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

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

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

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
68. 107.088 3,642.299 ↓ 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,181.744..3,642.299 rows=87,752 loops=1)

69. 101.362 3,535.211 ↓ 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,181.739..3,535.211 rows=87,752 loops=1)

70. 62.297 3,433.849 ↓ 87.8 87,752 1

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

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

72. 65.149 3,273.494 ↓ 87.8 87,752 1

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

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

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

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

75. 65.355 3,044.692 ↓ 87.8 87,752 1

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

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
76. 99.108 2,976.912 ↓ 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,178.900..2,976.912 rows=87,752 loops=1)

77. 99.575 2,877.804 ↓ 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,178.890..2,877.804 rows=87,752 loops=1)

78. 179.760 2,778.229 ↓ 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,178.884..2,778.229 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. 54.602 2,422.965 ↓ 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,178.877..2,422.965 rows=87,752 loops=1)

80. 63.984 2,280.611 ↓ 87.8 87,752 1

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

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

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

82. 57.303 1,802.276 ↓ 87.8 87,752 1

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

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

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

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

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

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

86. 351.008 351.008 ↑ 1.0 1 87,752

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

  • Index Cond: (recipient_id = z.recipient_id)
87. 0.164 0.672 ↑ 1.0 777 1

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

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

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

89. 0.906 3.430 ↓ 1.0 4,461 1

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

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

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

91. 263.256 263.256 ↑ 1.0 1 87,752

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

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

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

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

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

94. 87.752 87.752 ↓ 0.0 0 87,752

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

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

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

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

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

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

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

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

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

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

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

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

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

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

103. 0.100 0.243 ↑ 1.0 457 1

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

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

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

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

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

Seq Scan on date_holiday_cntner ghdhc (cost=0.00..13.00 rows=300 width=24) (actual time=0.005..0.005 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.429 1.289 ↑ 1.0 3,299 1

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

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

  • Heap Fetches: 0
115. 0.646 2.032 ↓ 1.0 4,472 1

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

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

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

117. 175.504 175.504 ↓ 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.002..0.002 rows=0 loops=87,752)

  • Index Cond: (dvc_id = d.dvc_id)
118. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=11.80..11.80 rows=180 width=226) (actual time=0.006..0.006 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.058 0.188 ↑ 1.0 185 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
121. 0.130 0.130 ↑ 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.130 rows=185 loops=1)

122. 0.066 0.222 ↑ 1.0 267 1

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

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

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

124. 0.000 0.012 ↓ 0.0 0 1

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

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

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

126. 175.504 175.504 ↓ 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.002..0.002 rows=0 loops=87,752)

  • 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.000 0.009 ↓ 0.0 0 1

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

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

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

131. 175.504 175.504 ↓ 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.002..0.002 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.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
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.000 0.004 ↓ 0.0 0 1

Hash (cost=12.70..12.70 rows=270 width=86) (actual time=0.004..0.004 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.004..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.007..0.009 rows=4 loops=1)

142. 0.009 0.037 ↑ 1.0 42 1

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

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

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

144. 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
145. 0.031 0.031 ↑ 1.0 197 1

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

146. 0.074 0.148 ↑ 1.0 457 1

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

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

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

148. 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
149. 0.006 0.006 ↑ 1.0 4 1

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

150. 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
151. 0.011 0.011 ↑ 1.0 42 1

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

152. 0.026 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
153. 0.033 0.033 ↑ 1.0 197 1

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

154. 0.085 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
155. 0.074 0.074 ↑ 1.0 457 1

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

156. 0.031 0.134 ↑ 1.0 95 1

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

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

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

158. 0.031 0.150 ↑ 1.0 216 1

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

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

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

160. 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
161. 0.010 0.010 ↑ 1.0 4 1

Seq Scan on org_languages dowsol (cost=0.00..1.04 rows=4 width=16) (actual time=0.009..0.010 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.026 0.058 ↑ 1.0 197 1

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

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

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

166. 0.073 0.145 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.144..0.145 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.009..0.072 rows=457 loops=1)

168. 0.013 0.043 ↑ 1.0 59 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
169. 0.030 0.030 ↑ 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.030 rows=59 loops=1)

170. 263.256 263.256 ↑ 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.003..0.003 rows=1 loops=87,752)

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

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

173. 0.073 0.147 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.147..0.147 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.012..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.081 ↑ 1.0 95 1

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

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

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

178. 132.695 965.272 ↑ 1.0 1 87,752

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

179. 132.695 614.264 ↑ 1.0 1 87,752

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

180. 263.256 263.256 ↑ 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.002..0.003 rows=1 loops=87,752)

  • Index Cond: (drs_id = drss.drs_id)
181. 218.313 218.313 ↑ 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.003..0.003 rows=1 loops=72,771)

  • Index Cond: (inc.date_rule_id = date_rule_id)
182. 218.313 218.313 ↑ 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.003..0.003 rows=1 loops=72,771)

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

Hash (cost=9.16..9.16 rows=216 width=16) (actual time=0.069..0.069 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.009 0.020 ↑ 1.0 42 1

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

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

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

189. 0.026 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
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.073 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.077 0.077 ↑ 1.0 457 1

Seq Scan on tz pstz (cost=0.00..10.57 rows=457 width=39) (actual time=0.005..0.077 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.000 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.006 0.006 ↓ 0.0 0 1

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

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

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

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

200. 0.095 0.178 ↑ 1.0 457 1

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

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

Seq Scan on tz stz (cost=0.00..10.57 rows=457 width=24) (actual time=0.008..0.083 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.024 0.072 ↑ 1.0 95 1

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

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

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

205. 0.039 0.072 ↑ 1.0 197 1

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

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

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

207. 0.110 0.179 ↑ 1.0 457 1

Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.179..0.179 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.038 0.068 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
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.005..0.030 rows=197 loops=1)

211. 0.088 0.158 ↑ 1.0 457 1

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

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

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

213. 0.001 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.000 0.005 ↓ 0.0 0 1

Hash Left Join (cost=32.12..46.24 rows=290 width=63) (actual time=0.005..0.005 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.511 6.826 ↑ 1.7 1,978 1

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

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

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

222. 0.010 0.166 ↑ 20.0 5 1

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

223. 0.156 0.156 ↑ 20.0 5 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.149..0.156 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. 5.375 5.375 ↓ 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.027..1.075 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.562 0.975 ↑ 1.0 3,299 1

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

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

  • Heap Fetches: 0
229. 0.822 1.457 ↓ 1.0 4,472 1

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

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

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

231. 1.024 2.766 ↓ 1.0 4,101 1

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

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

Seq Scan on tm_escalation tesc (cost=0.00..126.75 rows=4,075 width=29) (actual time=0.021..1.742 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. 143.240 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. 71.620 358.100 ↓ 0.0 0 71,620

BitmapOr (cost=3.66..3.66 rows=14 width=0) (actual time=0.005..0.005 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 13:26:35.487+00'::timestamp with time zone <= end_date))
  • Filter: ('2019-08-01 13:26:35.487+00'::timestamp with time zone >= start_date)
  • Rows Removed by Filter: 0
241.          

SubPlan (for Nested Loop Left Join)

242. 71.620 71.620 ↑ 1.0 1 71,620

Aggregate (cost=1.88..1.89 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=71,620)

243. 0.000 0.000 ↓ 0.0 0 71,620

Index Only Scan using idx_tm_mbrships1 on tm_mbrships tm (cost=0.28..1.87 rows=5 width=0) (actual time=0.000..0.000 rows=0 loops=71,620)

  • Index Cond: (tm_id = t.tm_id)
  • Heap Fetches: 0
244. 214.860 286.480 ↑ 1.0 1 71,620

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

245. 71.620 71.620 ↓ 0.0 0 71,620

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

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

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

  • Index Cond: (tm_id = t.tm_id)
247. 71.620 214.860 ↑ 1.0 1 71,620

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

248. 143.240 143.240 ↑ 4.0 1 71,620

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

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

Aggregate (cost=3,299.01..3,299.02 rows=1 width=8) (actual time=2.959..2.959 rows=1 loops=251)

250. 114.936 742.207 ↑ 1.0 3 251

Nested Loop (cost=18.31..3,299.00 rows=3 width=0) (actual time=2.040..2.957 rows=3 loops=251)

251. 409.883 436.740 ↑ 1.3 759 251

Bitmap Heap Scan on recipient_ntfn rntfn (cost=17.90..1,477.79 rows=1,004 width=8) (actual time=0.190..1.740 rows=759 loops=251)

  • Recheck Cond: ((recipient_id = dowr.recipient_id) OR (recipient_id = (z.chain_ids)[(array_length(z.chain_ids, 1) - 1)]))
  • Heap Blocks: exact=188170
252. 0.502 26.857 ↓ 0.0 0 251

BitmapOr (cost=17.90..17.90 rows=1,005 width=0) (actual time=0.107..0.107 rows=0 loops=251)

253. 0.000 0.000 ↓ 0.0 0 251

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..8.70 rows=502 width=0) (actual time=0.000..0.000 rows=0 loops=251)

  • Index Cond: (recipient_id = dowr.recipient_id)
254. 26.355 26.355 ↓ 1.6 787 251

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..8.70 rows=502 width=0) (actual time=0.105..0.105 rows=787 loops=251)

  • Index Cond: (recipient_id = (z.chain_ids)[(array_length(z.chain_ids, 1) - 1)])
255. 190.531 190.531 ↓ 0.0 0 190,531

Index Only Scan using person_ntfn_ntfn_id_not_delinked_pidx on person_ntfn pntfn (cost=0.41..1.81 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=190,531)

  • Index Cond: (ntfn_id = rntfn.ntfn_id)
  • Heap Fetches: 671
Planning time : 108.851 ms
Execution time : 15,790.388 ms