explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ItHF

Settings
# exclusive inclusive rows x rows loops node
1. 666.551 233,979.636 ↓ 43.7 88,068 1

Sort (cost=4,790,022.06..4,790,027.10 rows=2,016 width=9,268) (actual time=233,942.946..233,979.636 rows=88,068 loops=1)

  • Sort Key: z.src_id, z.sort_chain_ids
  • Sort Method: quicksort Memory: 82825kB
2. 564.539 233,313.085 ↓ 43.7 88,068 1

Nested Loop Left Join (cost=25,438.62..4,789,911.40 rows=2,016 width=9,268) (actual time=19,680.727..233,313.085 rows=88,068 loops=1)

3. 244.918 22,060.642 ↓ 43.7 88,068 1

Hash Left Join (cost=25,416.61..27,197.51 rows=2,016 width=9,235) (actual time=19,669.032..22,060.642 rows=88,068 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. 137.064 21,812.173 ↓ 43.7 88,068 1

Hash Left Join (cost=25,232.36..26,700.33 rows=2,016 width=9,222) (actual time=19,665.432..21,812.173 rows=88,068 loops=1)

  • Hash Cond: (ghdrngs.date_rng_id = ghonetimedrng.date_rng_id)
5. 150.743 21,673.142 ↓ 43.7 88,068 1

Hash Left Join (cost=25,054.06..26,516.74 rows=2,016 width=9,214) (actual time=19,663.393..21,673.142 rows=88,068 loops=1)

  • Hash Cond: (ghdr.date_rule_id = ghdrngs.drngs_id)
6. 197.969 21,520.658 ↓ 43.7 88,068 1

Nested Loop Left Join (cost=24,906.06..26,358.08 rows=2,016 width=9,214) (actual time=19,661.607..21,520.658 rows=88,068 loops=1)

7. 146.486 21,322.689 ↓ 43.7 88,068 1

Hash Anti Join (cost=24,905.77..25,672.19 rows=2,016 width=8,015) (actual time=19,661.596..21,322.689 rows=88,068 loops=1)

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 132.282 21,175.848 ↓ 41.9 88,068 1

Hash Left Join (cost=19,967.08..20,692.25 rows=2,102 width=8,023) (actual time=19,661.201..21,175.848 rows=88,068 loops=1)

  • Hash Cond: (ghs.site_id = ghsh.site_id)
9. 122.847 21,043.545 ↓ 60.7 88,068 1

Hash Left Join (cost=19,917.22..20,565.18 rows=1,450 width=7,976) (actual time=19,661.153..21,043.545 rows=88,068 loops=1)

  • Hash Cond: (ghotz.tz_id = ghstz.tz_id)
10. 134.847 20,920.453 ↓ 60.7 88,068 1

Hash Left Join (cost=19,900.94..20,545.06 rows=1,450 width=7,968) (actual time=19,660.883..20,920.453 rows=88,068 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghotz.org_tz_id)
11. 136.346 20,785.532 ↓ 60.7 88,068 1

Hash Left Join (cost=19,893.51..20,533.74 rows=1,450 width=7,968) (actual time=19,660.788..20,785.532 rows=88,068 loops=1)

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
12. 133.150 20,648.909 ↓ 60.7 88,068 1

Hash Left Join (cost=19,877.22..20,513.62 rows=1,450 width=7,945) (actual time=19,660.473..20,648.909 rows=88,068 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghpsotz.org_tz_id)
13. 133.990 20,515.652 ↓ 60.7 88,068 1

Hash Left Join (cost=19,869.79..20,502.30 rows=1,450 width=7,937) (actual time=19,660.333..20,515.652 rows=88,068 loops=1)

  • Hash Cond: (g.site_id = ghs.site_id)
14. 220.809 20,381.540 ↓ 60.7 88,068 1

Nested Loop Left Join (cost=19,860.65..20,489.36 rows=1,450 width=7,921) (actual time=19,660.189..20,381.540 rows=88,068 loops=1)

15. 132.724 20,160.731 ↓ 60.7 88,068 1

Hash Left Join (cost=19,860.36..19,996.04 rows=1,450 width=6,730) (actual time=19,660.179..20,160.731 rows=88,068 loops=1)

  • Hash Cond: (otz.tz_id = stz.tz_id)
16. 126.081 20,027.791 ↓ 60.7 88,068 1

Hash Left Join (cost=19,844.08..19,975.91 rows=1,450 width=6,722) (actual time=19,659.941..20,027.791 rows=88,068 loops=1)

  • Hash Cond: (s.org_tz_id = otz.org_tz_id)
17. 242.527 19,901.621 ↓ 60.7 88,068 1

Hash Right Join (cost=19,836.65..19,964.60 rows=1,450 width=6,722) (actual time=19,659.837..19,901.621 rows=88,068 loops=1)

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

Hash Left Join (cost=178.58..293.74 rows=3,299 width=24) (actual time=3.074..4.514 rows=3,299 loops=1)

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

  • Heap Fetches: 0
20. 1.503 2.943 ↑ 1.1 4,441 1

Hash (cost=118.69..118.69 rows=4,769 width=24) (actual time=2.936..2.943 rows=4,441 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 307kB
21. 1.440 1.440 ↑ 1.1 4,441 1

Seq Scan on date_rng drng (cost=0.00..118.69 rows=4,769 width=24) (actual time=0.019..1.440 rows=4,441 loops=1)

22. 141.678 19,654.580 ↓ 60.7 88,068 1

Hash (cost=19,639.94..19,639.94 rows=1,450 width=6,706) (actual time=19,654.577..19,654.580 rows=88,068 loops=1)

  • Buckets: 131072 (originally 2048) Batches: 1 (originally 1) Memory Usage: 46629kB
23. 120.200 19,512.902 ↓ 60.7 88,068 1

Merge Right Join (cost=19,618.08..19,639.94 rows=1,450 width=6,706) (actual time=19,383.577..19,512.902 rows=88,068 loops=1)

  • Merge Cond: (dr.date_rule_id = oh.date_rule_id)
24. 0.022 0.022 ↑ 114,781.0 1 1

Index Scan using date_rules_pk on date_rules dr (cost=0.42..6,355.27 rows=114,781 width=36) (actual time=0.018..0.022 rows=1 loops=1)

25. 352.530 19,392.680 ↓ 60.7 88,068 1

Sort (cost=16,397.12..16,400.75 rows=1,450 width=6,678) (actual time=19,383.549..19,392.680 rows=88,068 loops=1)

  • Sort Key: oh.date_rule_id
  • Sort Method: quicksort Memory: 82638kB
26. 103.287 19,040.150 ↓ 60.7 88,068 1

Hash Left Join (cost=2,327.28..16,320.98 rows=1,450 width=6,678) (actual time=1,687.995..19,040.150 rows=88,068 loops=1)

  • Hash Cond: (s.site_id = sh.site_id)
27. 108.944 18,936.807 ↓ 88.1 88,068 1

Hash Left Join (cost=2,308.78..16,249.23 rows=1,000 width=6,651) (actual time=1,687.977..18,936.807 rows=88,068 loops=1)

  • Hash Cond: (psotz.tz_id = pstz.tz_id)
28. 101.668 18,827.699 ↓ 88.1 88,068 1

Hash Left Join (cost=2,292.50..16,230.30 rows=1,000 width=6,628) (actual time=1,687.805..18,827.699 rows=88,068 loops=1)

  • Hash Cond: (s.org_tz_id = psotz.org_tz_id)
29. 100.385 18,725.973 ↓ 88.1 88,068 1

Hash Left Join (cost=2,285.06..16,220.19 rows=1,000 width=6,620) (actual time=1,687.735..18,725.973 rows=88,068 loops=1)

  • Hash Cond: (psol.language_id = psl.language_id)
30. 99.750 18,625.564 ↓ 88.1 88,068 1

Hash Left Join (cost=2,283.12..16,215.35 rows=1,000 width=6,613) (actual time=1,687.703..18,625.564 rows=88,068 loops=1)

  • Hash Cond: (s.org_language_id = psol.org_language_id)
31. 111.072 18,525.803 ↓ 88.1 88,068 1

Hash Left Join (cost=2,282.03..16,208.86 rows=1,000 width=6,613) (actual time=1,687.685..18,525.803 rows=88,068 loops=1)

  • Hash Cond: (s.address_id = address.address_id)
32. 107.550 18,414.662 ↓ 88.1 88,068 1

Hash Left Join (cost=2,270.17..16,194.32 rows=1,000 width=6,613) (actual time=1,687.607..18,414.662 rows=88,068 loops=1)

  • Hash Cond: (p.site_id = s.site_id)
33. 187.951 18,307.037 ↓ 88.1 88,068 1

Nested Loop Left Join (cost=2,261.03..16,182.48 rows=1,000 width=6,487) (actual time=1,687.524..18,307.037 rows=88,068 loops=1)

34. 179.822 15,917.386 ↓ 88.1 88,068 1

Nested Loop Left Join (cost=2,260.74..15,842.25 rows=1,000 width=5,296) (actual time=1,687.518..15,917.386 rows=88,068 loops=1)

35. 178.450 14,064.272 ↓ 88.1 88,068 1

Nested Loop Left Join (cost=2,260.32..15,316.13 rows=1,000 width=5,268) (actual time=1,687.511..14,064.272 rows=88,068 loops=1)

36. 142.352 13,095.280 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=2,260.03..14,974.57 rows=1,000 width=5,268) (actual time=1,687.504..13,095.280 rows=87,838 loops=1)

37. 110.623 11,723.196 ↓ 87.8 87,838 1

Hash Left Join (cost=2,259.74..14,618.48 rows=1,000 width=5,264) (actual time=1,687.498..11,723.196 rows=87,838 loops=1)

  • Hash Cond: (dtfotz.tz_id = dtftz.tz_id)
38. 110.894 11,612.422 ↓ 87.8 87,838 1

Hash Left Join (cost=2,243.46..14,599.55 rows=1,000 width=5,241) (actual time=1,687.340..11,612.422 rows=87,838 loops=1)

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
39. 118.227 11,501.469 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=2,236.03..14,589.44 rows=1,000 width=5,241) (actual time=1,687.263..11,501.469 rows=87,838 loops=1)

40. 115.011 9,538.644 ↓ 87.8 87,838 1

Hash Left Join (cost=2,235.74..14,224.57 rows=1,000 width=5,118) (actual time=1,687.248..9,538.644 rows=87,838 loops=1)

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
41. 101.829 9,423.578 ↓ 87.8 87,838 1

Hash Left Join (cost=2,232.41..14,218.48 rows=1,000 width=5,093) (actual time=1,687.169..9,423.578 rows=87,838 loops=1)

  • Hash Cond: (dowsotz.tz_id = dowstz.tz_id)
42. 85.459 9,321.557 ↓ 87.8 87,838 1

Hash Left Join (cost=2,216.13..14,199.55 rows=1,000 width=5,070) (actual time=1,686.958..9,321.557 rows=87,838 loops=1)

  • Hash Cond: (dows.org_tz_id = dowsotz.org_tz_id)
43. 90.017 9,236.007 ↓ 87.8 87,838 1

Hash Left Join (cost=2,208.70..14,189.44 rows=1,000 width=5,070) (actual time=1,686.862..9,236.007 rows=87,838 loops=1)

  • Hash Cond: (dowsol.language_id = dowsl.language_id)
44. 88.889 9,145.961 ↓ 87.8 87,838 1

Hash Left Join (cost=2,206.75..14,184.60 rows=1,000 width=5,063) (actual time=1,686.811..9,145.961 rows=87,838 loops=1)

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
45. 84.299 9,057.058 ↓ 87.8 87,838 1

Hash Left Join (cost=2,205.66..14,178.10 rows=1,000 width=5,063) (actual time=1,686.778..9,057.058 rows=87,838 loops=1)

  • Hash Cond: (dows.address_id = dowaddress.address_id)
46. 90.649 8,972.609 ↓ 87.8 87,838 1

Hash Left Join (cost=2,193.80..14,163.56 rows=1,000 width=5,063) (actual time=1,686.609..8,972.609 rows=87,838 loops=1)

  • Hash Cond: (dow.site_id = dows.site_id)
47. 91.552 8,881.815 ↓ 87.8 87,838 1

Hash Left Join (cost=2,184.66..14,151.72 rows=1,000 width=4,937) (actual time=1,686.451..8,881.815 rows=87,838 loops=1)

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
48. 82.973 8,790.106 ↓ 87.8 87,838 1

Hash Left Join (cost=2,168.38..14,132.79 rows=1,000 width=4,914) (actual time=1,686.288..8,790.106 rows=87,838 loops=1)

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
49. 82.566 8,707.074 ↓ 87.8 87,838 1

Hash Left Join (cost=2,160.95..14,122.70 rows=1,000 width=4,914) (actual time=1,686.221..8,707.074 rows=87,838 loops=1)

  • Hash Cond: (dowol.language_id = dowl.language_id)
50. 87.982 8,624.478 ↓ 87.8 87,838 1

Hash Left Join (cost=2,159.00..14,117.86 rows=1,000 width=4,907) (actual time=1,686.180..8,624.478 rows=87,838 loops=1)

  • Hash Cond: (dow.org_language_id = dowol.org_language_id)
51. 90.861 8,536.483 ↓ 87.8 87,838 1

Hash Left Join (cost=2,157.91..14,112.33 rows=1,000 width=4,907) (actual time=1,686.160..8,536.483 rows=87,838 loops=1)

  • Hash Cond: (potz.tz_id = ptz.tz_id)
52. 89.450 8,445.433 ↓ 87.8 87,838 1

Hash Left Join (cost=2,141.63..14,093.40 rows=1,000 width=4,884) (actual time=1,685.974..8,445.433 rows=87,838 loops=1)

  • Hash Cond: (p.org_tz_id = potz.org_tz_id)
53. 92.728 8,355.923 ↓ 87.8 87,838 1

Hash Left Join (cost=2,134.20..14,083.30 rows=1,000 width=4,884) (actual time=1,685.908..8,355.923 rows=87,838 loops=1)

  • Hash Cond: (pol.language_id = pl.language_id)
54. 90.925 8,263.165 ↓ 87.8 87,838 1

Hash Left Join (cost=2,132.25..14,078.47 rows=1,000 width=4,877) (actual time=1,685.870..8,263.165 rows=87,838 loops=1)

  • Hash Cond: (p.org_language_id = pol.org_language_id)
55. 81.755 8,172.226 ↓ 87.8 87,838 1

Hash Left Join (cost=2,131.16..14,072.93 rows=1,000 width=4,877) (actual time=1,685.850..8,172.226 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = gendvc.dvc_id)
56. 86.415 8,090.464 ↓ 87.8 87,838 1

Hash Left Join (cost=2,117.34..14,056.48 rows=1,000 width=4,659) (actual time=1,685.836..8,090.464 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = virtualdvc.dvc_id)
57. 85.952 8,004.038 ↓ 87.8 87,838 1

Hash Left Join (cost=2,101.26..14,037.78 rows=1,000 width=4,581) (actual time=1,685.819..8,004.038 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = imdvc.dvc_id)
58. 93.822 7,918.079 ↓ 87.8 87,838 1

Hash Left Join (cost=2,087.44..14,021.33 rows=1,000 width=4,363) (actual time=1,685.805..7,918.079 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
59. 152.607 7,824.249 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=2,073.39..14,004.65 rows=1,000 width=4,197) (actual time=1,685.791..7,824.249 rows=87,838 loops=1)

60. 81.739 6,968.938 ↓ 87.8 87,838 1

Hash Left Join (cost=2,073.10..13,674.79 rows=1,000 width=4,176) (actual time=1,685.778..6,968.938 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = numpagedvc.dvc_id)
61. 86.455 6,887.192 ↓ 87.8 87,838 1

Hash Left Join (cost=2,061.30..13,660.37 rows=1,000 width=3,510) (actual time=1,685.764..6,887.192 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
62. 101.777 6,800.729 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=2,047.47..13,643.92 rows=1,000 width=3,280) (actual time=1,685.749..6,800.729 rows=87,838 loops=1)

63. 80.603 6,084.086 ↓ 87.8 87,838 1

Hash Left Join (cost=2,047.19..13,329.37 rows=1,000 width=3,267) (actual time=1,685.741..6,084.086 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = txtpagedvc.dvc_id)
64. 81.045 6,003.475 ↓ 87.8 87,838 1

Hash Left Join (cost=2,033.36..13,312.92 rows=1,000 width=3,041) (actual time=1,685.725..6,003.475 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = appledvc.dvc_id)
65. 75.918 5,922.208 ↓ 87.8 87,838 1

Hash Left Join (cost=2,019.33..13,296.27 rows=1,000 width=2,917) (actual time=1,685.495..5,922.208 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = gcmdvc.dvc_id)
66. 82.168 5,846.102 ↓ 87.8 87,838 1

Hash Left Join (cost=2,008.17..13,282.48 rows=1,000 width=2,734) (actual time=1,685.299..5,846.102 rows=87,838 loops=1)

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
67. 143.272 5,763.924 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,994.12..13,265.81 rows=1,000 width=2,516) (actual time=1,685.277..5,763.924 rows=87,838 loops=1)

68. 78.127 5,093.624 ↓ 87.8 87,838 1

Hash Left Join (cost=1,993.83..12,946.16 rows=1,000 width=2,492) (actual time=1,685.257..5,093.624 rows=87,838 loops=1)

  • Hash Cond: (gdrngsrng.date_rng_id = gdaterng.date_rng_id)
69. 71.381 5,012.710 ↓ 87.8 87,838 1

Hash Left Join (cost=1,815.53..12,765.23 rows=1,000 width=2,476) (actual time=1,682.449..5,012.710 rows=87,838 loops=1)

  • Hash Cond: (gdrules.date_rule_id = gdrngsrng.drngs_id)
70. 119.731 4,940.101 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,667.53..12,611.94 rows=1,000 width=2,476) (actual time=1,681.210..4,940.101 rows=87,838 loops=1)

71. 105.803 4,820.370 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,667.24..12,271.72 rows=1,000 width=1,269) (actual time=1,681.202..4,820.370 rows=87,838 loops=1)

72. 66.202 4,714.567 ↓ 87.8 87,838 1

Hash Left Join (cost=1,666.95..11,941.94 rows=1,000 width=1,265) (actual time=1,681.184..4,714.567 rows=87,838 loops=1)

  • Hash Cond: (gdrules.date_rule_id = ghdhc.date_holiday_cntner_id)
73. 107.964 4,648.355 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,471.11..11,742.32 rows=1,000 width=1,233) (actual time=1,681.165..4,648.355 rows=87,838 loops=1)

74. 63.330 4,540.391 ↓ 87.8 87,838 1

Hash Left Join (cost=1,470.69..9,210.32 rows=1,000 width=1,197) (actual time=1,681.157..4,540.391 rows=87,838 loops=1)

  • Hash Cond: (gtfotz.tz_id = gtftz.tz_id)
75. 67.401 4,476.739 ↓ 87.8 87,838 1

Hash Left Join (cost=1,454.41..9,191.39 rows=1,000 width=1,174) (actual time=1,680.828..4,476.739 rows=87,838 loops=1)

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
76. 106.069 4,409.249 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,446.97..9,181.31 rows=1,000 width=1,174) (actual time=1,680.730..4,409.249 rows=87,838 loops=1)

77. 68.956 4,303.180 ↓ 87.8 87,838 1

Hash Left Join (cost=1,446.68..8,270.20 rows=1,000 width=1,170) (actual time=1,680.722..4,303.180 rows=87,838 loops=1)

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
78. 98.731 4,231.506 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,238.35..8,059.24 rows=1,000 width=1,146) (actual time=1,677.996..4,231.506 rows=87,838 loops=1)

79. 107.708 4,132.775 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,238.07..7,723.01 rows=1,000 width=1,146) (actual time=1,677.989..4,132.775 rows=87,838 loops=1)

80. 201.732 4,025.067 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,237.65..6,962.68 rows=1,000 width=1,093) (actual time=1,677.981..4,025.067 rows=87,838 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: 72607
81. 123.511 3,647.659 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=1,237.36..6,622.85 rows=1,000 width=1,040) (actual time=1,677.974..3,647.659 rows=87,838 loops=1)

82. 68.336 3,084.958 ↓ 87.8 87,838 1

Hash Left Join (cost=1,237.08..6,286.63 rows=1,000 width=1,032) (actual time=1,677.962..3,084.958 rows=87,838 loops=1)

  • Hash Cond: (z.recipient_id = p.person_id)
83. 143.810 3,000.857 ↓ 87.8 87,838 1

Nested Loop Left Join (cost=257.76..5,304.69 rows=1,000 width=979) (actual time=1,662.148..3,000.857 rows=87,838 loops=1)

84. 58.039 2,330.019 ↓ 87.8 87,838 1

Hash Left Join (cost=257.34..2,766.69 rows=1,000 width=896) (actual time=1,662.104..2,330.019 rows=87,838 loops=1)

  • Hash Cond: (z.recipient_id = t.tm_id)
85. 58.133 2,268.601 ↓ 87.8 87,838 1

Hash Left Join (cost=42.15..2,548.87 rows=1,000 width=302) (actual time=1,658.712..2,268.601 rows=87,838 loops=1)

  • Hash Cond: (z.recipient_id = g.grp_id)
86. 169.292 2,209.848 ↓ 87.8 87,838 1

Nested Loop (cost=0.67..2,504.75 rows=1,000 width=281) (actual time=1,658.078..2,209.848 rows=87,838 loops=1)

87. 1,689.204 1,689.204 ↓ 87.8 87,838 1

Function Scan on resolve_recipients_with_source_ntfn z (cost=0.25..10.25 rows=1,000 width=208) (actual time=1,658.019..1,689.204 rows=87,838 loops=1)

88. 351.352 351.352 ↑ 1.0 1 87,838

Index Scan using recipients_pk on recipients r (cost=0.42..2.49 rows=1 width=81) (actual time=0.004..0.004 rows=1 loops=87,838)

  • Index Cond: (recipient_id = z.recipient_id)
89. 0.152 0.620 ↑ 1.0 777 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
90. 0.468 0.468 ↑ 1.0 777 1

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

91. 0.956 3.379 ↑ 1.0 4,453 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 377kB
92. 2.423 2.423 ↑ 1.0 4,453 1

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

93. 527.028 527.028 ↑ 1.0 1 87,838

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

  • Index Cond: (dvc_id = z.recipient_id)
94. 5.296 15.765 ↑ 1.0 17,994 1

Hash (cost=754.14..754.14 rows=18,014 width=53) (actual time=15.754..15.765 rows=17,994 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1684kB
95. 10.469 10.469 ↑ 1.0 17,994 1

Seq Scan on persons p (cost=0.00..754.14 rows=18,014 width=53) (actual time=0.023..10.469 rows=17,994 loops=1)

96. 439.190 439.190 ↓ 0.0 0 87,838

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

  • Index Cond: (web_cred_id = p.person_id)
97. 175.676 175.676 ↑ 1.0 1 87,838

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

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

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

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

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

  • Index Cond: (web_cred_id = dow.person_id)
100. 1.012 2.718 ↑ 1.0 4,229 1

Hash (cost=155.37..155.37 rows=4,237 width=32) (actual time=2.699..2.718 rows=4,229 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 327kB
101. 1.706 1.706 ↑ 1.0 4,229 1

Seq Scan on grp_tf gtf (cost=0.00..155.37 rows=4,237 width=32) (actual time=0.032..1.706 rows=4,229 loops=1)

102. 0.000 0.000 ↓ 0.0 0 87,838

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

  • Index Cond: (gtf.drs_id = drs_id)
103. 0.027 0.089 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
104. 0.062 0.062 ↑ 1.0 197 1

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

105. 0.121 0.322 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
106. 0.201 0.201 ↑ 1.0 457 1

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

107. 0.000 0.000 ↓ 0.0 0 87,838

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

  • Index Cond: (z.date_rule_id = date_rule_id)
108. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=192.09..192.09 rows=300 width=32) (actual time=0.007..0.010 rows=0 loops=1)

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

Hash Left Join (cost=178.30..192.09 rows=300 width=32) (actual time=0.007..0.012 rows=0 loops=1)

  • Hash Cond: (ghdhc.date_rng_id = ghdrng.date_rng_id)
110. 0.009 0.009 ↓ 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.009 rows=0 loops=1)

111. 0.000 0.000 ↓ 0.0 0

Hash (cost=118.69..118.69 rows=4,769 width=24) (never executed)

112. 0.000 0.000 ↓ 0.0 0

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

113. 0.000 0.000 ↓ 0.0 0 87,838

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

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

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

  • Index Cond: (date_rpt_pattern_id = gdrules.date_rule_id)
115. 0.422 1.228 ↑ 1.0 3,299 1

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

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

  • Heap Fetches: 0
117. 1.011 2.787 ↑ 1.1 4,441 1

Hash (cost=118.69..118.69 rows=4,769 width=24) (actual time=2.784..2.787 rows=4,441 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 307kB
118. 1.776 1.776 ↑ 1.1 4,441 1

Seq Scan on date_rng gdaterng (cost=0.00..118.69 rows=4,769 width=24) (actual time=0.014..1.776 rows=4,441 loops=1)

119. 527.028 527.028 ↓ 0.0 0 87,838

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

  • Index Cond: (dvc_id = d.dvc_id)
120. 0.001 0.010 ↓ 0.0 0 1

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

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

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

122. 0.048 0.188 ↑ 1.0 185 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
123. 0.140 0.140 ↑ 1.0 185 1

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

124. 0.066 0.222 ↑ 1.0 267 1

Hash (cost=10.68..10.68 rows=268 width=132) (actual time=0.220..0.222 rows=267 loops=1)

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

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

126. 0.000 0.008 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
127. 0.008 0.008 ↓ 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.008 rows=0 loops=1)

128. 614.866 614.866 ↓ 0.0 0 87,838

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.007..0.007 rows=0 loops=87,838)

  • Index Cond: (dvc_id = d.dvc_id)
129. 0.000 0.008 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
130. 0.008 0.008 ↓ 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.008 rows=0 loops=1)

131. 0.000 0.007 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
132. 0.007 0.007 ↓ 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.007 rows=0 loops=1)

133. 702.704 702.704 ↓ 0.0 0 87,838

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

  • Index Cond: (dvc_id = d.dvc_id)
134. 0.001 0.008 ↓ 0.0 0 1

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

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

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

136. 0.000 0.007 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
137. 0.007 0.007 ↓ 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.007 rows=0 loops=1)

138. 0.001 0.011 ↓ 0.0 0 1

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

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

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

140. 0.000 0.007 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
141. 0.016 0.016 ↓ 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.016 rows=0 loops=1)

142. 0.003 0.014 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
143. 0.011 0.011 ↑ 1.0 4 1

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

144. 0.001 0.030 ↑ 1.0 42 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
145. 0.029 0.029 ↑ 1.0 42 1

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

146. 0.025 0.060 ↑ 1.0 197 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
147. 0.035 0.035 ↑ 1.0 197 1

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

148. 0.090 0.189 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
149. 0.099 0.099 ↑ 1.0 457 1

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

150. 0.000 0.013 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
151. 0.017 0.017 ↑ 1.0 4 1

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

152. 0.009 0.030 ↑ 1.0 42 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
153. 0.021 0.021 ↑ 1.0 42 1

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

154. 0.025 0.059 ↑ 1.0 197 1

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

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

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

156. 0.087 0.157 ↑ 1.0 457 1

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

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

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

158. 0.063 0.145 ↑ 1.0 95 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
159. 0.082 0.082 ↑ 1.0 95 1

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

160. 0.045 0.150 ↑ 1.0 216 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
161. 0.105 0.105 ↑ 1.0 216 1

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

162. 0.005 0.014 ↑ 1.0 4 1

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

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

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

164. 0.016 0.029 ↑ 1.0 42 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
165. 0.013 0.013 ↑ 1.0 42 1

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

166. 0.058 0.091 ↑ 1.0 197 1

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

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

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

168. 0.105 0.192 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
169. 0.087 0.087 ↑ 1.0 457 1

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

170. 0.021 0.055 ↑ 1.0 59 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
171. 0.034 0.034 ↑ 1.0 59 1

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

172. 1,844.598 1,844.598 ↑ 1.0 1 87,838

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

  • Index Cond: (dvc_id = d.dvc_id)
173. 0.026 0.059 ↑ 1.0 197 1

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

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

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

175. 0.072 0.151 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
176. 0.079 0.079 ↑ 1.0 457 1

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

177. 1,229.732 1,229.732 ↑ 1.0 1 87,838

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

  • Index Cond: (dtf.drs_id = drs_id)
178. 790.542 790.542 ↑ 1.0 1 87,838

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

  • Index Cond: (drs_id = drss.drs_id)
179. 1,673.292 1,673.292 ↑ 1.0 1 88,068

Index Scan using date_rules_pk on date_rules inc_rule (cost=0.42..0.53 rows=1 width=36) (actual time=0.019..0.019 rows=1 loops=88,068)

  • Index Cond: (inc.date_rule_id = date_rule_id)
180. 2,201.700 2,201.700 ↑ 1.0 1 88,068

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.025..0.025 rows=1 loops=88,068)

  • Index Cond: (inc_rule.date_rule_id = date_rpt_pattern_id)
181. 0.022 0.075 ↑ 1.0 95 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
182. 0.053 0.053 ↑ 1.0 95 1

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

183. 0.017 0.069 ↑ 1.0 216 1

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

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

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

185. 0.003 0.011 ↑ 1.0 4 1

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

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

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

187. 0.009 0.024 ↑ 1.0 42 1

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

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

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

189. 0.025 0.058 ↑ 1.0 197 1

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

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

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

191. 0.074 0.164 ↑ 1.0 457 1

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

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

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

193. 0.032 0.056 ↓ 0.0 0 1

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

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

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

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

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

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

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

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

200. 0.122 0.216 ↑ 1.0 457 1

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

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

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

202. 0.000 0.000 ↓ 0.0 0 88,068

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=88,068)

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

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

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

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

205. 0.053 0.107 ↑ 1.0 197 1

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

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

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

207. 0.156 0.277 ↑ 1.0 457 1

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

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

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

209. 0.031 0.074 ↑ 1.0 197 1

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

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

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

211. 0.127 0.245 ↑ 1.0 457 1

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

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

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

213. 0.008 0.021 ↓ 0.0 0 1

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

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

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

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

Seq Scan on site_holidays ghsh (cost=0.00..12.90 rows=290 width=16) (actual time=0.006..0.009 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.000 0.355 ↓ 0.0 0 1

Hash (cost=4,898.36..4,898.36 rows=3,226 width=8) (actual time=0.352..0.355 rows=0 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 32kB
221. 0.000 0.361 ↓ 0.0 0 1

Nested Loop (cost=0.43..4,898.36 rows=3,226 width=8) (actual time=0.351..0.361 rows=0 loops=1)

222. 0.014 0.235 ↑ 20.0 5 1

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

223. 0.216 0.221 ↑ 20.0 5 1

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

224. 0.005 0.005 ↑ 1.0 1 1

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

225. 0.130 0.130 ↓ 0.0 0 5

Index Scan using idx_live_ntfn4 on live_ntfn lntfn (cost=0.43..48.63 rows=32 width=16) (actual time=0.024..0.026 rows=0 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 88,068

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=88,068)

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

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

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

  • Heap Fetches: 0
229. 1.025 1.967 ↑ 1.1 4,441 1

Hash (cost=118.69..118.69 rows=4,769 width=24) (actual time=1.964..1.967 rows=4,441 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 307kB
230. 0.942 0.942 ↑ 1.1 4,441 1

Seq Scan on date_rng ghonetimedrng (cost=0.00..118.69 rows=4,769 width=24) (actual time=0.014..0.942 rows=4,441 loops=1)

231. 1.359 3.551 ↑ 1.0 4,050 1

Hash (cost=123.50..123.50 rows=4,050 width=29) (actual time=3.547..3.551 rows=4,050 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 287kB
232. 2.192 2.192 ↑ 1.0 4,050 1

Seq Scan on tm_escalation tesc (cost=0.00..123.50 rows=4,050 width=29) (actual time=0.030..2.192 rows=4,050 loops=1)

233. 88.068 1,497.156 ↓ 0.0 0 88,068

Limit (cost=22.01..22.02 rows=1 width=17) (actual time=0.017..0.017 rows=0 loops=88,068)

234. 352.272 1,409.088 ↓ 0.0 0 88,068

Sort (cost=22.01..22.02 rows=1 width=17) (actual time=0.016..0.016 rows=0 loops=88,068)

  • Sort Key: dr_1.start_date
  • Sort Method: quicksort Memory: 25kB
235. 439.350 1,056.816 ↓ 0.0 0 88,068

Nested Loop (cost=3.94..22.00 rows=1 width=17) (actual time=0.012..0.012 rows=0 loops=88,068)

236. 176.136 616.476 ↓ 0.0 0 88,068

Bitmap Heap Scan on tmp_rpmt tr (cost=3.66..18.56 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=88,068)

  • 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=21100
237. 0.000 440.340 ↓ 0.0 0 88,068

BitmapOr (cost=3.66..3.66 rows=14 width=0) (actual time=0.005..0.005 rows=0 loops=88,068)

238. 352.272 352.272 ↓ 0.0 0 88,068

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=88,068)

  • Index Cond: (tmper_id = d.person_id)
239. 88.068 88.068 ↓ 0.0 0 88,068

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=88,068)

  • Index Cond: (tmper_id = p.person_id)
240. 0.990 0.990 ↓ 0.0 0 330

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=330)

  • 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)
241.          

SubPlan (for Nested Loop Left Join)

242. 88.068 88.068 ↑ 1.0 1 88,068

Aggregate (cost=9.42..9.43 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=88,068)

243. 0.000 0.000 ↓ 0.0 0 88,068

Index Only Scan using idx_tm_mbrships1 on tm_mbrships tm (cost=0.28..9.40 rows=7 width=0) (actual time=0.000..0.000 rows=0 loops=88,068)

  • Index Cond: (tm_id = t.tm_id)
  • Heap Fetches: 0
244. 352.272 440.340 ↑ 1.0 1 88,068

Aggregate (cost=7.43..7.44 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=88,068)

245. 88.068 88.068 ↓ 0.0 0 88,068

Bitmap Heap Scan on tm_escalation te (cost=1.81..7.42 rows=4 width=8) (actual time=0.001..0.001 rows=0 loops=88,068)

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

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=88,068)

  • Index Cond: (tm_id = t.tm_id)
247. 88.068 440.340 ↑ 1.0 1 88,068

Aggregate (cost=7.84..7.85 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=88,068)

248. 352.272 352.272 ↑ 4.0 1 88,068

Index Scan using idx_dvc_person_id_not_deleted on dvc activedevice (cost=0.29..7.83 rows=4 width=0) (actual time=0.004..0.004 rows=1 loops=88,068)

  • Index Cond: (person_id = p.person_id)
  • Filter: ((status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 0
249. 5.000 208,222.000 ↑ 1.0 1 1,000

Aggregate (cost=2,315.68..2,315.69 rows=1 width=8) (actual time=208.222..208.222 rows=1 loops=1,000)

250. 395.660 208,217.000 ↓ 2.0 2 1,000

Hash Join (cost=1,437.00..2,315.68 rows=1 width=0) (actual time=207.300..208.217 rows=2 loops=1,000)

  • Hash Cond: (pntfn.ntfn_id = rntfn.ntfn_id)
251. 758.340 758.340 ↓ 1.3 4,622 990

Index Only Scan Backward using person_ntfn_ntfn_id_not_delinked_pidx on person_ntfn pntfn (cost=0.41..869.75 rows=3,556 width=8) (actual time=0.010..0.766 rows=4,622 loops=990)

  • Heap Fetches: 730196
252. 171.000 207,063.000 ↑ 1.8 539 1,000

Hash (cost=1,424.49..1,424.49 rows=968 width=8) (actual time=207.063..207.063 rows=539 loops=1,000)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
253. 202,788.000 206,892.000 ↑ 1.8 539 1,000

Bitmap Heap Scan on recipient_ntfn rntfn (cost=17.61..1,424.49 rows=968 width=8) (actual time=4.543..206.892 rows=539 loops=1,000)

  • Recheck Cond: ((recipient_id = dowr.recipient_id) OR (recipient_id = (z.chain_ids)[(array_length(z.chain_ids, 1) - 1)]))
  • Heap Blocks: exact=548242
254. 2.000 4,104.000 ↓ 0.0 0 1,000

BitmapOr (cost=17.61..17.61 rows=968 width=0) (actual time=4.104..4.104 rows=0 loops=1,000)

255. 0.000 0.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..8.56 rows=484 width=0) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Index Cond: (recipient_id = dowr.recipient_id)
256. 4,102.000 4,102.000 ↓ 1.2 567 1,000

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..8.56 rows=484 width=0) (actual time=4.102..4.102 rows=567 loops=1,000)

  • Index Cond: (recipient_id = (z.chain_ids)[(array_length(z.chain_ids, 1) - 1)])