# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 498.904 | 15,512.890 | ↓ 35.6 | 71,620 | 1 |
→
Sort (cost=6,025,363.10..6,025,368.13 rows=2,012 width=9,269) (actual time=15,500.937..15,512.890 rows=71,620 loops=1)
|
2. | 2,943.604 | 15,013.986 | ↓ 35.6 | 71,620 | 1 |
→
Nested Loop Left Join (cost=25,979.04..6,025,252.69 rows=2,012 width=9,269) (actual time=10,074.544..15,013.986 rows=71,620 loops=1) |
3. | 175.211 | 12,070.382 | ↓ 35.6 | 71,620 | 1 |
→
Hash Left Join (cost=25,957.01..27,854.72 rows=2,012 width=9,236) (actual time=10,074.417..12,070.382 rows=71,620 loops=1)
|
4. | 113.619 | 11,895.171 | ↓ 35.6 | 71,620 | 1 |
→
Hash Left Join (cost=25,769.13..27,248.91 rows=2,012 width=9,223) (actual time=10,072.247..11,895.171 rows=71,620 loops=1)
|
5. | 114.965 | 11,781.552 | ↓ 35.6 | 71,620 | 1 |
→
Hash Left Join (cost=25,597.85..27,072.34 rows=2,012 width=9,215) (actual time=10,070.466..11,781.552 rows=71,620 loops=1)
|
6. | 153.308 | 11,666.587 | ↓ 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,069.269..11,666.587 rows=71,620 loops=1) |
7. | 116.160 | 11,513.279 | ↓ 35.6 | 71,620 | 1 |
→
Hash Anti Join (cost=25,449.56..26,223.22 rows=2,012 width=8,016) (actual time=10,069.259..11,513.279 rows=71,620 loops=1)
|
8. | 117.500 | 11,397.119 | ↓ 41.8 | 87,982 | 1 |
→
Hash Left Join (cost=20,230.04..20,959.91 rows=2,104 width=8,024) (actual time=10,065.865..11,397.119 rows=87,982 loops=1)
|
9. | 124.003 | 11,279.619 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,180.18..20,832.78 rows=1,451 width=7,977) (actual time=10,065.834..11,279.619 rows=87,982 loops=1)
|
10. | 102.549 | 11,155.616 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,163.90..20,812.66 rows=1,451 width=7,969) (actual time=10,065.637..11,155.616 rows=87,982 loops=1)
|
11. | 118.611 | 11,053.067 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,156.47..20,801.34 rows=1,451 width=7,969) (actual time=10,065.540..11,053.067 rows=87,982 loops=1)
|
12. | 113.183 | 10,934.456 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,140.18..20,781.21 rows=1,451 width=7,946) (actual time=10,065.322..10,934.456 rows=87,982 loops=1)
|
13. | 111.330 | 10,821.273 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,132.75..20,769.89 rows=1,451 width=7,938) (actual time=10,065.227..10,821.273 rows=87,982 loops=1)
|
14. | 186.481 | 10,709.943 | ↓ 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,065.139..10,709.943 rows=87,982 loops=1) |
15. | 113.688 | 10,523.462 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,123.32..20,259.03 rows=1,451 width=6,731) (actual time=10,065.127..10,523.462 rows=87,982 loops=1)
|
16. | 120.684 | 10,409.774 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=20,107.04..20,238.90 rows=1,451 width=6,723) (actual time=10,064.926..10,409.774 rows=87,982 loops=1)
|
17. | 224.901 | 10,289.090 | ↓ 60.6 | 87,982 | 1 |
→
Hash Right Join (cost=20,099.61..20,227.59 rows=1,451 width=6,723) (actual time=10,064.823..10,289.090 rows=87,982 loops=1)
|
18. | 0.738 | 2.954 | ↑ 1.0 | 3,299 | 1 |
→
Hash Left Join (cost=171.56..286.72 rows=3,299 width=24) (actual time=1.906..2.954 rows=3,299 loops=1)
|
19. | 0.430 | 0.430 | ↑ 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.030..0.430 rows=3,299 loops=1)
|
20. | 0.909 | 1.786 | ↓ 1.0 | 4,472 | 1 |
→
Hash (cost=115.57..115.57 rows=4,457 width=24) (actual time=1.786..1.786 rows=4,472 loops=1)
|
21. | 0.877 | 0.877 | ↓ 1.0 | 4,472 | 1 |
→
Seq Scan on date_rng drng (cost=0.00..115.57 rows=4,457 width=24) (actual time=0.018..0.877 rows=4,472 loops=1) |
22. | 147.763 | 10,061.235 | ↓ 60.6 | 87,982 | 1 |
→
Hash (cost=19,909.91..19,909.91 rows=1,451 width=6,707) (actual time=10,061.235..10,061.235 rows=87,982 loops=1)
|
23. | 124.456 | 9,913.472 | ↓ 60.6 | 87,982 | 1 |
→
Merge Right Join (cost=19,888.02..19,909.91 rows=1,451 width=6,707) (actual time=9,778.976..9,913.472 rows=87,982 loops=1)
|
24. | 0.016 | 0.016 | ↑ 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.016..0.016 rows=1 loops=1) |
25. | 332.080 | 9,789.000 | ↓ 60.6 | 87,982 | 1 |
→
Sort (cost=16,418.24..16,421.87 rows=1,451 width=6,679) (actual time=9,778.949..9,789.000 rows=87,982 loops=1)
|
26. | 97.816 | 9,456.920 | ↓ 60.6 | 87,982 | 1 |
→
Hash Left Join (cost=2,316.95..16,342.04 rows=1,451 width=6,679) (actual time=1,052.346..9,456.920 rows=87,982 loops=1)
|
27. | 99.195 | 9,359.104 | ↓ 87.9 | 87,982 | 1 |
→
Hash Left Join (cost=2,298.45..16,270.24 rows=1,001 width=6,652) (actual time=1,052.326..9,359.104 rows=87,982 loops=1)
|
28. | 99.516 | 9,259.909 | ↓ 87.9 | 87,982 | 1 |
→
Hash Left Join (cost=2,282.17..16,251.31 rows=1,001 width=6,629) (actual time=1,052.168..9,259.909 rows=87,982 loops=1)
|
29. | 95.767 | 9,160.393 | ↓ 87.9 | 87,982 | 1 |
→
Hash Left Join (cost=2,274.73..16,241.20 rows=1,001 width=6,621) (actual time=1,052.098..9,160.393 rows=87,982 loops=1)
|
30. | 101.968 | 9,064.626 | ↓ 87.9 | 87,982 | 1 |
→
Hash Left Join (cost=2,272.79..16,236.36 rows=1,001 width=6,614) (actual time=1,052.067..9,064.626 rows=87,982 loops=1)
|
31. | 101.683 | 8,962.658 | ↓ 87.9 | 87,982 | 1 |
→
Hash Left Join (cost=2,271.70..16,229.86 rows=1,001 width=6,614) (actual time=1,052.043..8,962.658 rows=87,982 loops=1)
|
32. | 1,107.285 | 8,860.975 | ↓ 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,051.958..8,860.975 rows=87,982 loops=1) |
33. | 98.423 | 7,753.690 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,258.84..15,004.35 rows=1,000 width=5,395) (actual time=1,051.943..7,753.690 rows=87,752 loops=1)
|
34. | 361.808 | 7,655.267 | ↓ 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,051.862..7,655.267 rows=87,752 loops=1) |
35. | 107.418 | 7,293.459 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,249.41..14,631.01 rows=1,000 width=5,265) (actual time=1,051.852..7,293.459 rows=87,752 loops=1)
|
36. | 102.753 | 7,186.041 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,233.13..14,612.08 rows=1,000 width=5,242) (actual time=1,051.661..7,186.041 rows=87,752 loops=1)
|
37. | 416.860 | 7,083.288 | ↓ 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,051.591..7,083.288 rows=87,752 loops=1) |
38. | 106.048 | 6,666.428 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,225.41..14,237.04 rows=1,000 width=5,119) (actual time=1,051.582..6,666.428 rows=87,752 loops=1)
|
39. | 85.140 | 6,560.380 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,222.08..14,230.95 rows=1,000 width=5,094) (actual time=1,051.515..6,560.380 rows=87,752 loops=1)
|
40. | 79.861 | 6,475.240 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,205.80..14,212.02 rows=1,000 width=5,071) (actual time=1,051.322..6,475.240 rows=87,752 loops=1)
|
41. | 88.674 | 6,395.379 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,198.37..14,201.91 rows=1,000 width=5,071) (actual time=1,051.256..6,395.379 rows=87,752 loops=1)
|
42. | 84.204 | 6,306.705 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,196.42..14,197.07 rows=1,000 width=5,064) (actual time=1,051.222..6,306.705 rows=87,752 loops=1)
|
43. | 82.091 | 6,222.501 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,195.33..14,190.57 rows=1,000 width=5,064) (actual time=1,051.201..6,222.501 rows=87,752 loops=1)
|
44. | 89.884 | 6,140.410 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,183.47..14,176.03 rows=1,000 width=5,064) (actual time=1,051.102..6,140.410 rows=87,752 loops=1)
|
45. | 86.279 | 6,050.526 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,174.33..14,164.21 rows=1,000 width=4,938) (actual time=1,050.999..6,050.526 rows=87,752 loops=1)
|
46. | 83.720 | 5,964.247 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,158.05..14,145.28 rows=1,000 width=4,915) (actual time=1,050.840..5,964.247 rows=87,752 loops=1)
|
47. | 82.495 | 5,880.527 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,150.62..14,135.18 rows=1,000 width=4,915) (actual time=1,050.771..5,880.527 rows=87,752 loops=1)
|
48. | 84.417 | 5,798.032 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,148.67..14,130.35 rows=1,000 width=4,908) (actual time=1,050.716..5,798.032 rows=87,752 loops=1)
|
49. | 86.860 | 5,713.615 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,147.58..14,125.07 rows=1,000 width=4,908) (actual time=1,050.695..5,713.615 rows=87,752 loops=1)
|
50. | 91.127 | 5,626.755 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,131.30..14,106.15 rows=1,000 width=4,885) (actual time=1,050.527..5,626.755 rows=87,752 loops=1)
|
51. | 85.938 | 5,535.628 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,123.87..14,096.05 rows=1,000 width=4,885) (actual time=1,050.448..5,535.628 rows=87,752 loops=1)
|
52. | 87.688 | 5,449.690 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,121.92..14,091.22 rows=1,000 width=4,878) (actual time=1,050.412..5,449.690 rows=87,752 loops=1)
|
53. | 81.067 | 5,362.002 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,120.83..14,085.94 rows=1,000 width=4,878) (actual time=1,050.388..5,362.002 rows=87,752 loops=1)
|
54. | 83.280 | 5,280.935 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,107.01..14,069.49 rows=1,000 width=4,660) (actual time=1,050.372..5,280.935 rows=87,752 loops=1)
|
55. | 83.835 | 5,197.655 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,090.93..14,050.79 rows=1,000 width=4,582) (actual time=1,050.356..5,197.655 rows=87,752 loops=1)
|
56. | 85.262 | 5,113.820 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,077.11..14,034.34 rows=1,000 width=4,364) (actual time=1,050.339..5,113.820 rows=87,752 loops=1)
|
57. | 304.080 | 5,028.558 | ↓ 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,050.324..5,028.558 rows=87,752 loops=1) |
58. | 79.164 | 4,724.478 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,062.77..13,687.78 rows=1,000 width=4,177) (actual time=1,050.314..4,724.478 rows=87,752 loops=1)
|
59. | 80.271 | 4,645.314 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,050.97..13,673.36 rows=1,000 width=3,511) (actual time=1,050.298..4,645.314 rows=87,752 loops=1)
|
60. | 281.805 | 4,565.043 | ↓ 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,050.281..4,565.043 rows=87,752 loops=1) |
61. | 78.791 | 4,283.238 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,036.86..13,342.35 rows=1,000 width=3,268) (actual time=1,050.271..4,283.238 rows=87,752 loops=1)
|
62. | 75.924 | 4,204.447 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,023.03..13,325.90 rows=1,000 width=3,042) (actual time=1,050.253..4,204.447 rows=87,752 loops=1)
|
63. | 75.561 | 4,128.523 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=2,009.02..13,309.27 rows=1,000 width=2,918) (actual time=1,050.090..4,128.523 rows=87,752 loops=1)
|
64. | 75.460 | 4,052.962 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,997.86..13,295.48 rows=1,000 width=2,735) (actual time=1,049.967..4,052.962 rows=87,752 loops=1)
|
65. | 299.461 | 3,977.502 | ↓ 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,049.948..3,977.502 rows=87,752 loops=1) |
66. | 75.700 | 3,678.041 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,983.52..12,959.14 rows=1,000 width=2,493) (actual time=1,049.939..3,678.041 rows=87,752 loops=1)
|
67. | 65.145 | 3,602.341 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,812.24..12,785.23 rows=1,000 width=2,477) (actual time=1,048.361..3,602.341 rows=87,752 loops=1)
|
68. | 112.981 | 3,536.247 | ↓ 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,047.398..3,536.247 rows=87,752 loops=1) |
69. | 103.993 | 3,423.266 | ↓ 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,047.390..3,423.266 rows=87,752 loops=1) |
70. | 60.572 | 3,319.273 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,663.66..11,956.97 rows=1,000 width=1,266) (actual time=1,047.382..3,319.273 rows=87,752 loops=1)
|
71. | 109.845 | 3,258.693 | ↓ 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,047.361..3,258.693 rows=87,752 loops=1) |
72. | 62.710 | 3,148.848 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,474.42..9,232.37 rows=1,000 width=1,198) (actual time=1,047.352..3,148.848 rows=87,752 loops=1)
|
73. | 61.304 | 3,085.965 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,458.14..9,213.44 rows=1,000 width=1,175) (actual time=1,047.160..3,085.965 rows=87,752 loops=1)
|
74. | 105.081 | 3,024.571 | ↓ 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,047.043..3,024.571 rows=87,752 loops=1) |
75. | 66.138 | 2,919.490 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,450.42..8,290.47 rows=1,000 width=1,171) (actual time=1,047.032..2,919.490 rows=87,752 loops=1)
|
76. | 98.924 | 2,851.127 | ↓ 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,044.772..2,851.127 rows=87,752 loops=1) |
77. | 107.764 | 2,752.203 | ↓ 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,044.765..2,752.203 rows=87,752 loops=1) |
78. | 183.008 | 2,644.439 | ↓ 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,044.753..2,644.439 rows=87,752 loops=1)
|
79. | 58.893 | 2,285.927 | ↓ 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,044.743..2,285.927 rows=87,752 loops=1) |
80. | 65.240 | 2,139.282 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=1,241.03..6,307.08 rows=1,000 width=1,033) (actual time=1,044.708..2,139.282 rows=87,752 loops=1)
|
81. | 139.570 | 2,063.091 | ↓ 87.8 | 87,752 | 1 |
→
Nested Loop Left Join (cost=257.76..5,321.19 rows=1,000 width=980) (actual time=1,033.676..2,063.091 rows=87,752 loops=1) |
82. | 56.069 | 1,660.265 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=257.34..2,783.19 rows=1,000 width=897) (actual time=1,033.652..1,660.265 rows=87,752 loops=1)
|
83. | 54.243 | 1,601.673 | ↓ 87.8 | 87,752 | 1 |
→
Hash Left Join (cost=42.15..2,565.37 rows=1,000 width=303) (actual time=1,031.099..1,601.673 rows=87,752 loops=1)
|
84. | 132.149 | 1,546.989 | ↓ 87.8 | 87,752 | 1 |
→
Nested Loop (cost=0.67..2,521.25 rows=1,000 width=282) (actual time=1,030.635..1,546.989 rows=87,752 loops=1) |
85. | 1,063.832 | 1,063.832 | ↓ 87.8 | 87,752 | 1 |
→
Function Scan on resolve_recipients_with_source_ntfn z (cost=0.25..10.25 rows=1,000 width=208) (actual time=1,030.595..1,063.832 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)
|
87. | 0.141 | 0.441 | ↑ 1.0 | 777 | 1 |
→
Hash (cost=31.77..31.77 rows=777 width=29) (actual time=0.441..0.441 rows=777 loops=1)
|
88. | 0.300 | 0.300 | ↑ 1.0 | 777 | 1 |
→
Seq Scan on grp g (cost=0.00..31.77 rows=777 width=29) (actual time=0.016..0.300 rows=777 loops=1) |
89. | 0.833 | 2.523 | ↓ 1.0 | 4,461 | 1 |
→
Hash (cost=159.53..159.53 rows=4,453 width=594) (actual time=2.523..2.523 rows=4,461 loops=1)
|
90. | 1.690 | 1.690 | ↓ 1.0 | 4,461 | 1 |
→
Seq Scan on tm t (cost=0.00..159.53 rows=4,453 width=594) (actual time=0.019..1.690 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)
|
92. | 4.748 | 10.951 | ↑ 1.0 | 18,041 | 1 |
→
Hash (cost=757.01..757.01 rows=18,101 width=53) (actual time=10.951..10.951 rows=18,041 loops=1)
|
93. | 6.203 | 6.203 | ↑ 1.0 | 18,041 | 1 |
→
Seq Scan on persons p (cost=0.00..757.01 rows=18,101 width=53) (actual time=0.015..6.203 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)
|
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)
|
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)
|
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)
|
98. | 0.912 | 2.225 | ↓ 1.0 | 4,234 | 1 |
→
Hash (cost=155.27..155.27 rows=4,227 width=32) (actual time=2.225..2.225 rows=4,234 loops=1)
|
99. | 1.313 | 1.313 | ↓ 1.0 | 4,234 | 1 |
→
Seq Scan on grp_tf gtf (cost=0.00..155.27 rows=4,227 width=32) (actual time=0.015..1.313 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)
|
101. | 0.027 | 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)
|
102. | 0.063 | 0.063 | ↑ 1.0 | 197 | 1 |
→
Seq Scan on org_tz gtfotz (cost=0.00..4.97 rows=197 width=16) (actual time=0.017..0.063 rows=197 loops=1) |
103. | 0.080 | 0.173 | ↑ 1.0 | 457 | 1 |
→
Hash (cost=10.57..10.57 rows=457 width=39) (actual time=0.173..0.173 rows=457 loops=1)
|
104. | 0.093 | 0.093 | ↑ 1.0 | 457 | 1 |
→
Seq Scan on tz gtftz (cost=0.00..10.57 rows=457 width=39) (actual time=0.011..0.093 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)
|
106. | 0.000 | 0.008 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=185.07..185.07 rows=300 width=32) (actual time=0.008..0.008 rows=0 loops=1)
|
107. | 0.001 | 0.008 | ↓ 0.0 | 0 | 1 |
→
Hash Left Join (cost=171.28..185.07 rows=300 width=32) (actual time=0.008..0.008 rows=0 loops=1)
|
108. | 0.007 | 0.007 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on date_holiday_cntner ghdhc (cost=0.00..13.00 rows=300 width=24) (actual time=0.007..0.007 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)
|
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)
|
113. | 0.411 | 0.949 | ↑ 1.0 | 3,299 | 1 |
→
Hash (cost=106.77..106.77 rows=3,299 width=16) (actual time=0.949..0.949 rows=3,299 loops=1)
|
114. | 0.538 | 0.538 | ↑ 1.0 | 3,299 | 1 |
→
Index Only Scan using drngs_rng_pk on drngs_rng gdrngsrng (cost=0.28..106.77 rows=3,299 width=16) (actual time=0.019..0.538 rows=3,299 loops=1) |