explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AH2V

Settings
# exclusive inclusive rows x rows loops node
1. 2.015 462.574 ↑ 1.9 443 1

Sort (cost=13,019,833.21..13,019,835.28 rows=829 width=15,553) (actual time=462.552..462.574 rows=443 loops=1)

  • Sort Key: z.src_id, z.sort_chain_ids
  • Sort Method: quicksort Memory: 410kB
2. 1.328 460.559 ↑ 1.9 443 1

Nested Loop Left Join (cost=19,701.56..13,019,793.02 rows=829 width=15,553) (actual time=216.901..460.559 rows=443 loops=1)

3. 0.993 264.332 ↑ 1.9 443 1

Nested Loop Left Join (cost=19,678.19..23,894.19 rows=829 width=15,520) (actual time=216.773..264.332 rows=443 loops=1)

4. 0.626 262.896 ↑ 1.9 443 1

Nested Loop Left Join (cost=19,677.90..23,447.77 rows=829 width=15,506) (actual time=216.727..262.896 rows=443 loops=1)

5. 0.630 262.270 ↑ 1.9 443 1

Nested Loop Left Join (cost=19,677.62..23,170.76 rows=829 width=15,498) (actual time=216.720..262.270 rows=443 loops=1)

6. 0.636 261.640 ↑ 1.9 443 1

Nested Loop Left Join (cost=19,677.33..22,910.70 rows=829 width=15,498) (actual time=216.712..261.640 rows=443 loops=1)

7. 0.652 261.004 ↑ 1.9 443 1

Hash Anti Join (cost=19,677.04..22,643.63 rows=829 width=14,298) (actual time=216.701..261.004 rows=443 loops=1)

  • Hash Cond: (d.dvc_id = lntfn.dvc_id)
8. 0.576 256.754 ↑ 1.6 638 1

Hash Left Join (cost=10,628.06..13,576.66 rows=1,001 width=14,306) (actual time=213.080..256.754 rows=638 loops=1)

  • Hash Cond: (ghotz.tz_id = ghstz.tz_id)
9. 0.560 256.061 ↑ 1.6 638 1

Hash Left Join (cost=10,611.78..13,557.73 rows=1,001 width=14,298) (actual time=212.955..256.061 rows=638 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghotz.org_tz_id)
10. 0.610 255.453 ↑ 1.6 638 1

Hash Left Join (cost=10,604.33..13,547.59 rows=1,001 width=14,298) (actual time=212.900..255.453 rows=638 loops=1)

  • Hash Cond: (ghpsotz.tz_id = ghpstz.tz_id)
11. 0.633 254.698 ↑ 1.6 638 1

Hash Left Join (cost=10,588.04..13,528.66 rows=1,001 width=14,275) (actual time=212.744..254.698 rows=638 loops=1)

  • Hash Cond: (ghs.org_tz_id = ghpsotz.org_tz_id)
12. 0.589 254.018 ↑ 1.6 638 1

Hash Left Join (cost=10,580.59..13,518.52 rows=1,001 width=14,267) (actual time=212.688..254.018 rows=638 loops=1)

  • Hash Cond: (ghs.site_id = ghsh.site_id)
13. 0.601 253.323 ↑ 1.6 638 1

Hash Left Join (cost=10,531.04..13,458.55 rows=1,001 width=13,754) (actual time=212.570..253.323 rows=638 loops=1)

  • Hash Cond: (g.site_id = ghs.site_id)
14. 0.761 252.699 ↑ 1.6 638 1

Nested Loop Left Join (cost=10,528.16..13,452.97 rows=1,001 width=13,738) (actual time=212.538..252.699 rows=638 loops=1)

15. 0.773 251.938 ↑ 1.6 638 1

Nested Loop Left Join (cost=10,527.88..13,118.50 rows=1,001 width=13,730) (actual time=212.531..251.938 rows=638 loops=1)

16. 0.789 251.165 ↑ 1.6 638 1

Nested Loop Left Join (cost=10,527.59..12,804.48 rows=1,001 width=13,730) (actual time=212.523..251.165 rows=638 loops=1)

17. 0.554 250.376 ↑ 1.6 638 1

Hash Left Join (cost=10,527.31..12,481.99 rows=1,001 width=12,530) (actual time=212.513..250.376 rows=638 loops=1)

  • Hash Cond: (otz.tz_id = stz.tz_id)
18. 0.552 249.653 ↑ 1.6 638 1

Hash Left Join (cost=10,511.02..12,463.06 rows=1,001 width=12,522) (actual time=212.335..249.653 rows=638 loops=1)

  • Hash Cond: (s.org_tz_id = otz.org_tz_id)
19. 0.614 249.018 ↑ 1.6 638 1

Hash Left Join (cost=10,503.57..12,452.92 rows=1,001 width=12,522) (actual time=212.231..249.018 rows=638 loops=1)

  • Hash Cond: (oh.date_rule_id = dr.date_rule_id)
20. 0.584 226.622 ↑ 1.6 638 1

Hash Left Join (cost=8,708.74..10,655.47 rows=1,001 width=12,505) (actual time=190.364..226.622 rows=638 loops=1)

  • Hash Cond: (psotz.tz_id = pstz.tz_id)
21. 0.572 225.890 ↑ 1.6 638 1

Hash Left Join (cost=8,692.46..10,636.54 rows=1,001 width=12,482) (actual time=190.203..225.890 rows=638 loops=1)

  • Hash Cond: (s.org_tz_id = psotz.org_tz_id)
22. 0.556 225.253 ↑ 1.6 638 1

Hash Left Join (cost=8,685.01..10,626.40 rows=1,001 width=12,474) (actual time=190.129..225.253 rows=638 loops=1)

  • Hash Cond: (s.address_id = address.address_id)
23. 0.588 224.684 ↑ 1.6 638 1

Hash Left Join (cost=8,683.13..10,621.60 rows=1,001 width=12,474) (actual time=190.108..224.684 rows=638 loops=1)

  • Hash Cond: (s.org_language_id = psol.org_language_id)
24. 0.548 224.067 ↑ 1.6 638 1

Hash Left Join (cost=8,680.37..10,614.06 rows=1,001 width=11,698) (actual time=190.068..224.067 rows=638 loops=1)

  • Hash Cond: (s.site_id = sh.site_id)
25. 0.548 223.466 ↑ 1.6 638 1

Nested Loop Left Join (cost=8,677.39..10,600.66 rows=1,001 width=11,194) (actual time=189.998..223.466 rows=638 loops=1)

26. 0.527 209.604 ↑ 1.6 634 1

Hash Left Join (cost=8,676.53..9,581.10 rows=1,000 width=9,985) (actual time=189.875..209.604 rows=634 loops=1)

  • Hash Cond: (p.site_id = s.site_id)
27. 0.585 209.041 ↑ 1.6 634 1

Nested Loop Left Join (cost=8,673.65..9,575.41 rows=1,000 width=9,123) (actual time=189.829..209.041 rows=634 loops=1)

28. 0.606 204.652 ↑ 1.6 634 1

Hash Left Join (cost=8,673.36..9,238.27 rows=1,000 width=9,119) (actual time=189.748..204.652 rows=634 loops=1)

  • Hash Cond: (dtfotz.tz_id = dtftz.tz_id)
29. 0.611 203.910 ↑ 1.6 634 1

Hash Left Join (cost=8,657.08..9,219.34 rows=1,000 width=9,096) (actual time=189.603..203.910 rows=634 loops=1)

  • Hash Cond: (dtf.org_tz_id = dtfotz.org_tz_id)
30. 0.965 203.253 ↑ 1.6 634 1

Nested Loop Left Join (cost=8,649.63..9,209.21 rows=1,000 width=9,096) (actual time=189.547..203.253 rows=634 loops=1)

31. 0.572 198.484 ↑ 1.6 634 1

Hash Left Join (cost=8,649.34..8,872.87 rows=1,000 width=8,983) (actual time=189.504..198.484 rows=634 loops=1)

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
32. 0.462 197.876 ↑ 1.6 634 1

Hash Left Join (cost=8,647.51..8,868.24 rows=1,000 width=8,179) (actual time=189.458..197.876 rows=634 loops=1)

  • Hash Cond: (dowsotz.tz_id = dowstz.tz_id)
33. 0.469 197.270 ↑ 1.6 634 1

Hash Left Join (cost=8,631.23..8,849.31 rows=1,000 width=8,156) (actual time=189.305..197.270 rows=634 loops=1)

  • Hash Cond: (dows.org_tz_id = dowsotz.org_tz_id)
34. 0.435 196.753 ↑ 1.6 634 1

Hash Left Join (cost=8,623.77..8,839.17 rows=1,000 width=8,156) (actual time=189.249..196.753 rows=634 loops=1)

  • Hash Cond: (dows.address_id = dowaddress.address_id)
35. 0.463 196.291 ↑ 1.6 634 1

Hash Left Join (cost=8,621.89..8,834.38 rows=1,000 width=8,156) (actual time=189.211..196.291 rows=634 loops=1)

  • Hash Cond: (dows.org_language_id = dowsol.org_language_id)
36. 0.528 195.806 ↑ 1.6 634 1

Hash Left Join (cost=8,619.14..8,826.84 rows=1,000 width=7,380) (actual time=189.181..195.806 rows=634 loops=1)

  • Hash Cond: (dow.site_id = dows.site_id)
37. 0.457 195.219 ↑ 1.6 634 1

Hash Left Join (cost=8,616.26..8,821.15 rows=1,000 width=6,518) (actual time=189.110..195.219 rows=634 loops=1)

  • Hash Cond: (dowotz.tz_id = dowtz.tz_id)
38. 0.422 194.624 ↑ 1.6 634 1

Hash Left Join (cost=8,599.98..8,802.22 rows=1,000 width=6,495) (actual time=188.965..194.624 rows=634 loops=1)

  • Hash Cond: (dow.org_tz_id = dowotz.org_tz_id)
39. 0.435 194.151 ↑ 1.6 634 1

Hash Left Join (cost=8,592.52..8,792.11 rows=1,000 width=6,495) (actual time=188.907..194.151 rows=634 loops=1)

  • Hash Cond: (dowol.language_id = dowl.language_id)
40. 0.478 193.696 ↑ 1.6 634 1

Hash Left Join (cost=8,590.58..8,787.27 rows=1,000 width=5,719) (actual time=188.875..193.696 rows=634 loops=1)

  • Hash Cond: (dow.org_language_id = dowol.org_language_id)
41. 0.440 193.210 ↑ 1.6 634 1

Hash Left Join (cost=8,589.49..8,781.71 rows=1,000 width=5,719) (actual time=188.859..193.210 rows=634 loops=1)

  • Hash Cond: (potz.tz_id = ptz.tz_id)
42. 0.509 192.585 ↑ 1.6 634 1

Hash Left Join (cost=8,573.20..8,762.78 rows=1,000 width=5,696) (actual time=188.665..192.585 rows=634 loops=1)

  • Hash Cond: (p.org_tz_id = potz.org_tz_id)
43. 2.313 192.009 ↑ 1.6 634 1

Hash Right Join (cost=8,565.75..8,752.67 rows=1,000 width=5,696) (actual time=188.586..192.009 rows=634 loops=1)

  • Hash Cond: (voicedvc.dvc_id = d.dvc_id)
44. 1.147 1.147 ↓ 1.0 7,004 1

Seq Scan on voc_dvc_dtl voicedvc (cost=0.00..156.97 rows=6,997 width=59) (actual time=0.015..1.147 rows=7,004 loops=1)

45. 0.577 188.549 ↑ 1.6 634 1

Hash (cost=8,553.25..8,553.25 rows=1,000 width=5,645) (actual time=188.549..188.549 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 220kB
46. 0.392 187.972 ↑ 1.6 634 1

Hash Left Join (cost=7,163.38..8,553.25 rows=1,000 width=5,645) (actual time=181.844..187.972 rows=634 loops=1)

  • Hash Cond: (pol.language_id = pl.language_id)
47. 0.370 187.544 ↑ 1.6 634 1

Hash Left Join (cost=7,161.43..8,548.41 rows=1,000 width=4,869) (actual time=181.798..187.544 rows=634 loops=1)

  • Hash Cond: (p.org_language_id = pol.org_language_id)
48. 0.331 187.154 ↑ 1.6 634 1

Hash Left Join (cost=7,160.34..8,542.85 rows=1,000 width=4,869) (actual time=181.766..187.154 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = gendvc.dvc_id)
49. 0.335 186.820 ↑ 1.6 634 1

Hash Left Join (cost=7,146.29..8,526.17 rows=1,000 width=4,651) (actual time=181.755..186.820 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = virtualdvc.dvc_id)
50. 0.335 186.482 ↑ 1.6 634 1

Hash Left Join (cost=7,130.22..8,507.47 rows=1,000 width=4,573) (actual time=181.744..186.482 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = imdvc.dvc_id)
51. 0.340 186.144 ↑ 1.6 634 1

Hash Left Join (cost=7,116.17..8,490.80 rows=1,000 width=4,355) (actual time=181.728..186.144 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = voiceivrdvc.dvc_id)
52. 0.319 185.801 ↑ 1.6 634 1

Hash Left Join (cost=7,101.67..8,473.67 rows=1,000 width=4,189) (actual time=181.715..185.801 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = numpagedvc.dvc_id)
53. 0.315 185.478 ↑ 1.6 634 1

Hash Left Join (cost=7,089.64..8,459.02 rows=1,000 width=3,523) (actual time=181.702..185.478 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = faxdvc.dvc_id)
54. 0.399 185.158 ↑ 1.6 634 1

Hash Left Join (cost=7,075.59..8,442.35 rows=1,000 width=3,293) (actual time=181.684..185.158 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = txtphonedvc.dvc_id)
55. 0.313 182.814 ↑ 1.6 634 1

Hash Left Join (cost=6,919.82..8,283.95 rows=1,000 width=3,280) (actual time=179.720..182.814 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = txtpagedvc.dvc_id)
56. 0.349 182.498 ↑ 1.6 634 1

Hash Left Join (cost=6,905.77..8,267.27 rows=1,000 width=3,054) (actual time=179.709..182.498 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = appledvc.dvc_id)
57. 0.380 181.863 ↑ 1.6 634 1

Hash Left Join (cost=6,882.39..8,241.27 rows=1,000 width=2,928) (actual time=179.415..181.863 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = gcmdvc.dvc_id)
58. 0.310 181.132 ↑ 1.6 634 1

Hash Left Join (cost=6,853.90..8,210.15 rows=1,000 width=2,751) (actual time=179.057..181.132 rows=634 loops=1)

  • Hash Cond: (d.dvc_id = besdvc.dvc_id)
59. 0.450 180.819 ↑ 1.6 634 1

Nested Loop Left Join (cost=6,839.85..8,193.48 rows=1,000 width=2,533) (actual time=179.036..180.819 rows=634 loops=1)

60. 0.508 180.369 ↑ 1.6 634 1

Nested Loop Left Join (cost=6,839.56..7,859.33 rows=1,000 width=2,517) (actual time=179.030..180.369 rows=634 loops=1)

61. 0.408 179.861 ↑ 1.6 634 1

Nested Loop Left Join (cost=6,839.27..7,537.17 rows=1,000 width=1,317) (actual time=179.024..179.861 rows=634 loops=1)

62. 0.452 179.453 ↑ 1.6 634 1

Hash Right Join (cost=6,838.99..7,222.64 rows=1,000 width=1,313) (actual time=179.016..179.453 rows=634 loops=1)

  • Hash Cond: (ghdhc.date_holiday_cntner_id = gdrules.date_rule_id)
63. 0.002 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..382.75 rows=300 width=32) (actual time=0.011..0.012 rows=0 loops=1)

64. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on date_holiday_cntner ghdhc (cost=0.00..13.00 rows=300 width=24) (actual time=0.010..0.010 rows=0 loops=1)

65. 0.000 0.000 ↓ 0.0 0

Index Scan using date_rng_pk on date_rng ghdrng (cost=0.29..1.23 rows=1 width=24) (never executed)

  • Index Cond: (ghdhc.date_rng_id = date_rng_id)
66. 0.322 178.989 ↑ 1.6 634 1

Hash (cost=6,826.20..6,826.20 rows=1,000 width=1,281) (actual time=178.989..178.989 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 206kB
67. 1.243 178.667 ↑ 1.6 634 1

Hash Right Join (cost=6,647.31..6,826.20 rows=1,000 width=1,281) (actual time=176.566..178.667 rows=634 loops=1)

  • Hash Cond: (emaildvc.dvc_id = d.dvc_id)
68. 0.904 0.904 ↓ 1.0 6,507 1

Seq Scan on email_dvc_dtl emaildvc (cost=0.00..151.05 rows=6,505 width=31) (actual time=0.018..0.904 rows=6,507 loops=1)

69. 0.318 176.520 ↑ 1.6 634 1

Hash (cost=6,634.81..6,634.81 rows=1,000 width=1,258) (actual time=176.520..176.520 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 198kB
70. 1.350 176.202 ↑ 1.6 634 1

Hash Right Join (cost=6,417.06..6,634.81 rows=1,000 width=1,258) (actual time=175.871..176.202 rows=634 loops=1)

  • Hash Cond: (gdrngsrng.drngs_id = gdrules.date_rule_id)
71. 1.171 1.171 ↓ 1.0 9,089 1

Seq Scan on drngs_rng gdrngsrng (cost=0.00..182.64 rows=8,864 width=16) (actual time=0.013..1.171 rows=9,089 loops=1)

72. 0.382 173.681 ↑ 1.6 634 1

Hash (cost=6,404.56..6,404.56 rows=1,000 width=1,250) (actual time=173.681..173.681 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 198kB
73. 0.410 173.299 ↑ 1.6 634 1

Nested Loop Left Join (cost=1,995.21..6,404.56 rows=1,000 width=1,250) (actual time=163.762..173.299 rows=634 loops=1)

74. 0.262 172.889 ↑ 1.6 634 1

Hash Left Join (cost=1,994.92..4,988.56 rows=1,000 width=1,225) (actual time=163.752..172.889 rows=634 loops=1)

  • Hash Cond: (gtfotz.tz_id = gtftz.tz_id)
75. 0.237 172.404 ↑ 1.6 634 1

Hash Left Join (cost=1,978.64..4,969.63 rows=1,000 width=1,202) (actual time=163.515..172.404 rows=634 loops=1)

  • Hash Cond: (gtf.org_tz_id = gtfotz.org_tz_id)
76. 0.385 172.088 ↑ 1.6 634 1

Nested Loop Left Join (cost=1,971.18..4,959.52 rows=1,000 width=1,202) (actual time=163.422..172.088 rows=634 loops=1)

77. 0.245 171.703 ↑ 1.6 634 1

Hash Left Join (cost=1,970.90..4,522.19 rows=1,000 width=1,198) (actual time=163.398..171.703 rows=634 loops=1)

  • Hash Cond: (z.grp_tf_id = gtf.grp_tf_id)
78. 0.269 170.026 ↑ 1.6 634 1

Hash Left Join (cost=1,805.13..4,353.79 rows=1,000 width=1,167) (actual time=161.943..170.026 rows=634 loops=1)

  • Hash Cond: (dow.person_id = dowcred.web_cred_id)
79. 0.386 167.090 ↑ 1.6 634 1

Nested Loop Left Join (cost=1,549.58..4,095.62 rows=1,000 width=1,167) (actual time=159.252..167.090 rows=634 loops=1)

80. 0.643 166.704 ↑ 1.6 634 1

Nested Loop Left Join (cost=1,549.30..3,573.60 rows=1,000 width=1,110) (actual time=159.244..166.704 rows=634 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: 509
81. 0.614 165.427 ↑ 1.6 634 1

Hash Left Join (cost=1,549.01..3,232.04 rows=1,000 width=1,056) (actual time=159.228..165.427 rows=634 loops=1)

  • Hash Cond: (z.recipient_id = d.dvc_id)
82. 0.349 152.844 ↑ 1.6 634 1

Hash Left Join (cost=673.17..2,353.57 rows=1,000 width=972) (actual time=147.204..152.844 rows=634 loops=1)

  • Hash Cond: (z.recipient_id = t.tm_id)
83. 0.285 149.815 ↑ 1.6 634 1

Hash Left Join (cost=479.23..2,157.00 rows=1,000 width=378) (actual time=144.505..149.815 rows=634 loops=1)

  • Hash Cond: (z.recipient_id = g.grp_id)
84. 0.421 148.738 ↑ 1.6 634 1

Nested Loop (cost=411.02..2,086.16 rows=1,000 width=357) (actual time=143.694..148.738 rows=634 loops=1)

85. 0.897 145.147 ↑ 1.6 634 1

Hash Right Join (cost=410.73..629.16 rows=1,000 width=270) (actual time=143.657..145.147 rows=634 loops=1)

  • Hash Cond: (cred.web_cred_id = p.person_id)
86. 0.629 0.629 ↑ 1.0 4,995 1

Seq Scan on web_creds cred (cost=0.00..193.02 rows=5,002 width=16) (actual time=0.017..0.629 rows=4,995 loops=1)

87. 0.192 143.621 ↑ 1.6 634 1

Hash (cost=398.23..398.23 rows=1,000 width=262) (actual time=143.621..143.621 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 108kB
88. 0.248 143.429 ↑ 1.6 634 1

Hash Left Join (cost=385.61..398.23 rows=1,000 width=262) (actual time=143.177..143.429 rows=634 loops=1)

  • Hash Cond: (z.recipient_id = p.person_id)
89. 138.546 138.546 ↑ 1.6 634 1

Function Scan on resolve_recipients_with_source_ntfn z (cost=0.25..10.25 rows=1,000 width=208) (actual time=138.504..138.546 rows=634 loops=1)

90. 1.726 4.635 ↓ 1.0 7,529 1

Hash (cost=291.27..291.27 rows=7,527 width=54) (actual time=4.635..4.635 rows=7,529 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 673kB
91. 2.909 2.909 ↓ 1.0 7,529 1

Seq Scan on persons p (cost=0.00..291.27 rows=7,527 width=54) (actual time=0.024..2.909 rows=7,529 loops=1)

92. 3.170 3.170 ↑ 1.0 1 634

Index Scan using recipients_pk on recipients r (cost=0.29..1.46 rows=1 width=95) (actual time=0.005..0.005 rows=1 loops=634)

  • Index Cond: (recipient_id = z.recipient_id)
93. 0.232 0.792 ↓ 1.0 1,300 1

Hash (cost=51.98..51.98 rows=1,298 width=29) (actual time=0.792..0.792 rows=1,300 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 90kB
94. 0.560 0.560 ↓ 1.0 1,300 1

Seq Scan on grp g (cost=0.00..51.98 rows=1,298 width=29) (actual time=0.019..0.560 rows=1,300 loops=1)

95. 0.819 2.680 ↓ 1.0 4,368 1

Hash (cost=139.53..139.53 rows=4,353 width=594) (actual time=2.680..2.680 rows=4,368 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 376kB
96. 1.861 1.861 ↓ 1.0 4,368 1

Seq Scan on tm t (cost=0.00..139.53 rows=4,353 width=594) (actual time=0.012..1.861 rows=4,368 loops=1)

97. 6.381 11.969 ↓ 1.0 18,898 1

Hash (cost=639.82..639.82 rows=18,882 width=84) (actual time=11.969..11.969 rows=18,898 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2590kB
98. 5.588 5.588 ↓ 1.0 18,898 1

Seq Scan on dvc d (cost=0.00..639.82 rows=18,882 width=84) (actual time=0.010..5.588 rows=18,898 loops=1)

99. 0.634 0.634 ↑ 1.0 1 634

Index Scan using persons_pk on persons dow (cost=0.28..0.32 rows=1 width=54) (actual time=0.001..0.001 rows=1 loops=634)

  • Index Cond: (person_id = d.person_id)
100. 0.000 0.000 ↓ 0.0 0 634

Index Scan using recipients_pk on recipients dowr (cost=0.29..0.52 rows=1 width=57) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (recipient_id = dow.person_id)
101. 0.777 2.667 ↑ 1.0 4,995 1

Hash (cost=193.02..193.02 rows=5,002 width=16) (actual time=2.666..2.667 rows=4,995 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 321kB
102. 1.890 1.890 ↑ 1.0 4,995 1

Seq Scan on web_creds dowcred (cost=0.00..193.02 rows=5,002 width=16) (actual time=0.012..1.890 rows=4,995 loops=1)

103. 0.567 1.432 ↑ 1.0 3,409 1

Hash (cost=123.12..123.12 rows=3,412 width=39) (actual time=1.432..1.432 rows=3,409 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 268kB
104. 0.865 0.865 ↑ 1.0 3,409 1

Seq Scan on grp_tf gtf (cost=0.00..123.12 rows=3,412 width=39) (actual time=0.012..0.865 rows=3,409 loops=1)

105. 0.000 0.000 ↓ 0.0 0 634

Index Scan using drss_pk on drss gdrsroot (cost=0.29..0.44 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (gtf.drs_id = drs_id)
106. 0.025 0.079 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.079..0.079 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
107. 0.054 0.054 ↑ 1.0 198 1

Seq Scan on org_tz gtfotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.018..0.054 rows=198 loops=1)

108. 0.083 0.223 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
109. 0.140 0.140 ↑ 1.0 457 1

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

110. 0.000 0.000 ↓ 0.0 0 634

Index Scan using date_rules_pk on date_rules gdrules (cost=0.29..1.42 rows=1 width=25) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (z.date_rule_id = date_rule_id)
111. 0.000 0.000 ↓ 0.0 0 634

Index Scan using drss_pk on drss gdrss (cost=0.29..0.31 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (drs_id = gdrules.date_rule_id)
112. 0.000 0.000 ↓ 0.0 0 634

Index Scan using date_rpt_patterns_pk on date_rpt_patterns gdrptp (cost=0.29..0.32 rows=1 width=1,208) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (date_rpt_pattern_id = gdrules.date_rule_id)
113. 0.000 0.000 ↓ 0.0 0 634

Index Scan using date_rng_pk on date_rng gdaterng (cost=0.29..0.33 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=634)

  • Index Cond: (date_rng_id = gdrngsrng.date_rng_id)
114. 0.001 0.003 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
115. 0.002 0.002 ↓ 0.0 0 1

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

116. 0.112 0.351 ↓ 1.0 512 1

Hash (cost=22.11..22.11 rows=511 width=185) (actual time=0.351..0.351 rows=512 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 120kB
117. 0.239 0.239 ↓ 1.0 512 1

Seq Scan on gcm_push_dvc_dtl gcmdvc (cost=0.00..22.11 rows=511 width=185) (actual time=0.009..0.239 rows=512 loops=1)

118. 0.095 0.286 ↓ 1.0 463 1

Hash (cost=17.61..17.61 rows=461 width=134) (actual time=0.286..0.286 rows=463 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 80kB
119. 0.191 0.191 ↓ 1.0 463 1

Seq Scan on apple_push_dvc_dtl appledvc (cost=0.00..17.61 rows=461 width=134) (actual time=0.009..0.191 rows=463 loops=1)

120. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=11.80..11.80 rows=180 width=234) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on txt_page_dvc_dtl txtpagedvc (cost=0.00..11.80 rows=180 width=234) (actual time=0.003..0.003 rows=0 loops=1)

122. 0.690 1.945 ↓ 1.0 4,483 1

Hash (cost=99.79..99.79 rows=4,479 width=21) (actual time=1.945..1.945 rows=4,483 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 310kB
123. 1.255 1.255 ↓ 1.0 4,483 1

Seq Scan on txt_phone_dvc_dtl txtphonedvc (cost=0.00..99.79 rows=4,479 width=21) (actual time=0.012..1.255 rows=4,483 loops=1)

124. 0.000 0.005 ↓ 0.0 0 1

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

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

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

126. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=10.90..10.90 rows=90 width=674) (actual time=0.004..0.004 rows=0 loops=1)

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

Seq Scan on num_page_dvc_dtl numpagedvc (cost=0.00..10.90 rows=90 width=674) (actual time=0.003..0.003 rows=0 loops=1)

128. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=12.00..12.00 rows=200 width=174) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on voice_ivr_dvc_dtl voiceivrdvc (cost=0.00..12.00 rows=200 width=174) (actual time=0.003..0.003 rows=0 loops=1)

130. 0.000 0.003 ↓ 0.0 0 1

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

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

Seq Scan on im_dvc_dtl imdvc (cost=0.00..11.80 rows=180 width=226) (actual time=0.003..0.003 rows=0 loops=1)

132. 0.000 0.003 ↓ 0.0 0 1

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

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

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

134. 0.000 0.003 ↓ 0.0 0 1

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

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

Seq Scan on gen_dvc_dtl gendvc (cost=0.00..11.80 rows=180 width=226) (actual time=0.003..0.003 rows=0 loops=1)

136. 0.003 0.020 ↑ 1.0 4 1

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

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

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

138. 0.017 0.036 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=792) (actual time=0.036..0.036 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
139. 0.019 0.019 ↑ 1.0 42 1

Seq Scan on languages pl (cost=0.00..1.42 rows=42 width=792) (actual time=0.013..0.019 rows=42 loops=1)

140. 0.025 0.067 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.067..0.067 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
141. 0.042 0.042 ↑ 1.0 198 1

Seq Scan on org_tz potz (cost=0.00..4.98 rows=198 width=16) (actual time=0.006..0.042 rows=198 loops=1)

142. 0.078 0.185 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
143. 0.107 0.107 ↑ 1.0 457 1

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

144. 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
145. 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)

146. 0.009 0.020 ↑ 1.0 42 1

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

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

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

148. 0.024 0.051 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.051..0.051 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
149. 0.027 0.027 ↑ 1.0 198 1

Seq Scan on org_tz dowotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.002..0.027 rows=198 loops=1)

150. 0.080 0.138 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
151. 0.058 0.058 ↑ 1.0 457 1

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

152. 0.022 0.059 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=870) (actual time=0.059..0.059 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
153. 0.037 0.037 ↑ 1.0 39 1

Seq Scan on sites dows (cost=0.00..2.39 rows=39 width=870) (actual time=0.013..0.037 rows=39 loops=1)

154. 0.002 0.022 ↑ 1.0 4 1

Hash (cost=2.71..2.71 rows=4 width=792) (actual time=0.022..0.022 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
155. 0.012 0.020 ↑ 1.0 4 1

Hash Right Join (cost=1.09..2.71 rows=4 width=792) (actual time=0.012..0.020 rows=4 loops=1)

  • Hash Cond: (dowsl.language_id = dowsol.language_id)
156. 0.004 0.004 ↑ 1.0 42 1

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

157. 0.002 0.004 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
158. 0.002 0.002 ↑ 1.0 4 1

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

159. 0.006 0.027 ↑ 1.0 39 1

Hash (cost=1.39..1.39 rows=39 width=16) (actual time=0.027..0.027 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
160. 0.021 0.021 ↑ 1.0 39 1

Seq Scan on addresses dowaddress (cost=0.00..1.39 rows=39 width=16) (actual time=0.016..0.021 rows=39 loops=1)

161. 0.024 0.048 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.048..0.048 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
162. 0.024 0.024 ↑ 1.0 198 1

Seq Scan on org_tz dowsotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.002..0.024 rows=198 loops=1)

163. 0.079 0.144 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
164. 0.065 0.065 ↑ 1.0 457 1

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

165. 0.009 0.036 ↑ 1.0 37 1

Hash (cost=1.37..1.37 rows=37 width=820) (actual time=0.036..0.036 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
166. 0.027 0.027 ↑ 1.0 37 1

Seq Scan on org_dvc_names odn (cost=0.00..1.37 rows=37 width=820) (actual time=0.017..0.027 rows=37 loops=1)

167. 3.804 3.804 ↑ 1.0 1 634

Index Scan using idx_dvc_tf1 on dvc_tf dtf (cost=0.29..0.33 rows=1 width=121) (actual time=0.006..0.006 rows=1 loops=634)

  • Index Cond: (dvc_id = d.dvc_id)
168. 0.023 0.046 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.046..0.046 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
169. 0.023 0.023 ↑ 1.0 198 1

Seq Scan on org_tz dtfotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.002..0.023 rows=198 loops=1)

170. 0.079 0.136 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
171. 0.057 0.057 ↑ 1.0 457 1

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

172. 3.804 3.804 ↑ 1.0 1 634

Index Scan using drss_pk on drss (cost=0.29..0.34 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=634)

  • Index Cond: (dtf.drs_id = drs_id)
173. 0.013 0.036 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=870) (actual time=0.035..0.036 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
174. 0.023 0.023 ↑ 1.0 39 1

Seq Scan on sites s (cost=0.00..2.39 rows=39 width=870) (actual time=0.005..0.023 rows=39 loops=1)

175. 0.697 13.314 ↑ 1.0 1 634

Nested Loop Left Join (cost=0.86..1.01 rows=1 width=1,225) (actual time=0.020..0.021 rows=1 loops=634)

176. 0.213 6.974 ↑ 1.0 1 634

Nested Loop Left Join (cost=0.58..0.69 rows=1 width=33) (actual time=0.010..0.011 rows=1 loops=634)

177. 3.170 3.170 ↑ 1.0 1 634

Index Only Scan using drs_includes_pk on drs_includes inc (cost=0.29..0.31 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=634)

  • Index Cond: (drs_id = drss.drs_id)
  • Heap Fetches: 285
178. 3.591 3.591 ↑ 1.0 1 513

Index Scan using date_rules_pk on date_rules inc_rule (cost=0.29..0.38 rows=1 width=25) (actual time=0.007..0.007 rows=1 loops=513)

  • Index Cond: (inc.date_rule_id = date_rule_id)
179. 5.643 5.643 ↑ 1.0 1 513

Index Scan using date_rpt_patterns_pk on date_rpt_patterns inc_drule (cost=0.29..0.32 rows=1 width=1,208) (actual time=0.011..0.011 rows=1 loops=513)

  • Index Cond: (inc_rule.date_rule_id = date_rpt_pattern_id)
180. 0.006 0.053 ↑ 1.0 26 1

Hash (cost=2.65..2.65 rows=26 width=512) (actual time=0.053..0.053 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
181. 0.015 0.047 ↑ 1.0 26 1

Hash Left Join (cost=1.32..2.65 rows=26 width=512) (actual time=0.039..0.047 rows=26 loops=1)

  • Hash Cond: (sh.org_holiday_id = oh.org_holiday_id)
182. 0.014 0.014 ↑ 1.0 26 1

Seq Scan on site_holidays sh (cost=0.00..1.26 rows=26 width=16) (actual time=0.012..0.014 rows=26 loops=1)

183. 0.004 0.018 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=512) (actual time=0.018..0.018 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
184. 0.014 0.014 ↑ 1.0 14 1

Seq Scan on org_holidays oh (cost=0.00..1.14 rows=14 width=512) (actual time=0.010..0.014 rows=14 loops=1)

185. 0.002 0.029 ↑ 1.0 4 1

Hash (cost=2.71..2.71 rows=4 width=792) (actual time=0.029..0.029 rows=4 loops=1)

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

Hash Right Join (cost=1.09..2.71 rows=4 width=792) (actual time=0.019..0.027 rows=4 loops=1)

  • Hash Cond: (psl.language_id = psol.language_id)
187. 0.008 0.008 ↑ 1.0 42 1

Seq Scan on languages psl (cost=0.00..1.42 rows=42 width=792) (actual time=0.006..0.008 rows=42 loops=1)

188. 0.002 0.006 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
189. 0.004 0.004 ↑ 1.0 4 1

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

190. 0.005 0.013 ↑ 1.0 39 1

Hash (cost=1.39..1.39 rows=39 width=16) (actual time=0.013..0.013 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
191. 0.008 0.008 ↑ 1.0 39 1

Seq Scan on addresses address (cost=0.00..1.39 rows=39 width=16) (actual time=0.003..0.008 rows=39 loops=1)

192. 0.024 0.065 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.065..0.065 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
193. 0.041 0.041 ↑ 1.0 198 1

Seq Scan on org_tz psotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.003..0.041 rows=198 loops=1)

194. 0.082 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
195. 0.066 0.066 ↑ 1.0 457 1

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

196. 8.740 21.782 ↓ 1.0 47,512 1

Hash (cost=1,202.70..1,202.70 rows=47,370 width=25) (actual time=21.782..21.782 rows=47,512 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3076kB
197. 13.042 13.042 ↓ 1.0 47,512 1

Seq Scan on date_rules dr (cost=0.00..1,202.70 rows=47,370 width=25) (actual time=0.011..13.042 rows=47,512 loops=1)

198. 0.025 0.083 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.083..0.083 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
199. 0.058 0.058 ↑ 1.0 198 1

Seq Scan on org_tz otz (cost=0.00..4.98 rows=198 width=16) (actual time=0.019..0.058 rows=198 loops=1)

200. 0.069 0.169 ↑ 1.0 457 1

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

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

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

202. 0.000 0.000 ↓ 0.0 0 638

Index Scan using date_rpt_patterns_pk on date_rpt_patterns drp (cost=0.29..0.32 rows=1 width=1,208) (actual time=0.000..0.000 rows=0 loops=638)

  • Index Cond: (dr.date_rule_id = date_rpt_pattern_id)
203. 0.000 0.000 ↓ 0.0 0 638

Index Only Scan using drngs_rng_pk on drngs_rng drngs (cost=0.29..0.30 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=638)

  • Index Cond: (drngs_id = dr.date_rule_id)
  • Heap Fetches: 0
204. 0.000 0.000 ↓ 0.0 0 638

Index Scan using date_rng_pk on date_rng drng (cost=0.29..0.33 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=638)

  • Index Cond: (drngs.date_rng_id = date_rng_id)
205. 0.007 0.023 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=16) (actual time=0.023..0.023 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
206. 0.016 0.016 ↑ 1.0 39 1

Seq Scan on sites ghs (cost=0.00..2.39 rows=39 width=16) (actual time=0.006..0.016 rows=39 loops=1)

207. 0.008 0.106 ↑ 1.0 26 1

Hash (cost=49.22..49.22 rows=26 width=529) (actual time=0.106..0.106 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
208. 0.014 0.098 ↑ 1.0 26 1

Hash Right Join (cost=1.88..49.22 rows=26 width=529) (actual time=0.054..0.098 rows=26 loops=1)

  • Hash Cond: (ghoh.org_holiday_id = ghsh.org_holiday_id)
209. 0.006 0.068 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.29..47.45 rows=14 width=529) (actual time=0.032..0.068 rows=14 loops=1)

210. 0.006 0.006 ↑ 1.0 14 1

Seq Scan on org_holidays ghoh (cost=0.00..1.14 rows=14 width=512) (actual time=0.004..0.006 rows=14 loops=1)

211. 0.056 0.056 ↑ 1.0 1 14

Index Scan using date_rules_pk on date_rules ghdr (cost=0.29..3.31 rows=1 width=25) (actual time=0.004..0.004 rows=1 loops=14)

  • Index Cond: (ghoh.date_rule_id = date_rule_id)
212. 0.005 0.016 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=16) (actual time=0.016..0.016 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
213. 0.011 0.011 ↑ 1.0 26 1

Seq Scan on site_holidays ghsh (cost=0.00..1.26 rows=26 width=16) (actual time=0.006..0.011 rows=26 loops=1)

214. 0.024 0.047 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.047..0.047 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
215. 0.023 0.023 ↑ 1.0 198 1

Seq Scan on org_tz ghpsotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.002..0.023 rows=198 loops=1)

216. 0.085 0.145 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
217. 0.060 0.060 ↑ 1.0 457 1

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

218. 0.024 0.048 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=16) (actual time=0.048..0.048 rows=198 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
219. 0.024 0.024 ↑ 1.0 198 1

Seq Scan on org_tz ghotz (cost=0.00..4.98 rows=198 width=16) (actual time=0.002..0.024 rows=198 loops=1)

220. 0.065 0.117 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
221. 0.052 0.052 ↑ 1.0 457 1

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

222. 0.052 3.598 ↑ 33.5 195 1

Hash (cost=8,967.44..8,967.44 rows=6,523 width=8) (actual time=3.598..3.598 rows=195 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 72kB
223. 0.054 3.546 ↑ 33.5 195 1

Nested Loop (cost=0.42..8,967.44 rows=6,523 width=8) (actual time=0.208..3.546 rows=195 loops=1)

224. 0.005 0.029 ↑ 100.0 1 1

Result (cost=0.00..2.27 rows=100 width=8) (actual time=0.023..0.029 rows=1 loops=1)

225. 0.023 0.024 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.019..0.024 rows=1 loops=1)

226. 0.001 0.001 ↑ 1.0 1 1

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

227. 3.463 3.463 ↓ 3.0 195 1

Index Scan using idx_live_ntfn4 on live_ntfn lntfn (cost=0.42..88.99 rows=65 width=16) (actual time=0.182..3.463 rows=195 loops=1)

  • Index Cond: (root_ntfn_id = (((json_object_keys('{"568619018":[208392]}'::json)))::bigint))
228. 0.000 0.000 ↓ 0.0 0 443

Index Scan using date_rpt_patterns_pk on date_rpt_patterns ghdrp (cost=0.29..0.32 rows=1 width=1,208) (actual time=0.000..0.000 rows=0 loops=443)

  • Index Cond: (ghdr.date_rule_id = date_rpt_pattern_id)
229. 0.000 0.000 ↓ 0.0 0 443

Index Only Scan using drngs_rng_pk on drngs_rng ghdrngs (cost=0.29..0.30 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=443)

  • Index Cond: (drngs_id = ghdr.date_rule_id)
  • Heap Fetches: 0
230. 0.000 0.000 ↓ 0.0 0 443

Index Scan using date_rng_pk on date_rng ghonetimedrng (cost=0.29..0.33 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=443)

  • Index Cond: (ghdrngs.date_rng_id = date_rng_id)
231. 0.443 0.443 ↓ 0.0 0 443

Index Scan using tm_escalation_pk on tm_escalation tesc (cost=0.29..0.53 rows=1 width=30) (actual time=0.001..0.001 rows=0 loops=443)

  • Index Cond: (((z.sort_chain_ids)[(array_length(z.sort_chain_ids, 1) - 3)] = tm_id) AND ((z.sort_chain_ids)[(array_length(z.sort_chain_ids, 1) - 2)] = esc_seq_num))
232. 0.443 4.873 ↓ 0.0 0 443

Limit (cost=23.37..23.37 rows=1 width=17) (actual time=0.011..0.011 rows=0 loops=443)

233. 0.886 4.430 ↓ 0.0 0 443

Sort (cost=23.37..23.37 rows=1 width=17) (actual time=0.010..0.010 rows=0 loops=443)

  • Sort Key: dr_1.start_date
  • Sort Method: quicksort Memory: 25kB
234. 0.443 3.544 ↓ 0.0 0 443

Nested Loop (cost=3.93..23.36 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=443)

235. 1.772 3.101 ↓ 0.0 0 443

Bitmap Heap Scan on tmp_rpmt tr (cost=3.65..20.03 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=443)

  • 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: 3
  • Heap Blocks: exact=694
236. 0.000 1.329 ↓ 0.0 0 443

BitmapOr (cost=3.65..3.65 rows=12 width=0) (actual time=0.003..0.003 rows=0 loops=443)

237. 0.886 0.886 ↑ 3.0 2 443

Bitmap Index Scan on idx_tmp_rpmt3 (cost=0.00..1.82 rows=6 width=0) (actual time=0.002..0.002 rows=2 loops=443)

  • Index Cond: (tmper_id = d.person_id)
238. 0.443 0.443 ↑ 6.0 1 443

Bitmap Index Scan on idx_tmp_rpmt3 (cost=0.00..1.82 rows=6 width=0) (actual time=0.001..0.001 rows=1 loops=443)

  • Index Cond: (tmper_id = p.person_id)
239. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_date_rng_date_rng_id_desc_end_date_desc on date_rng dr_1 (cost=0.29..3.31 rows=1 width=24) (never executed)

  • Index Cond: ((date_rng_id = tr.date_rng_id) AND ('2019-01-03 01:21:45.759+00'::timestamp with time zone <= end_date))
  • Filter: ('2019-01-03 01:21:45.759+00'::timestamp with time zone >= start_date)
240.          

SubPlan (forNested Loop Left Join)

241. 0.443 0.443 ↑ 1.0 1 443

Aggregate (cost=9.40..9.41 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=443)

242. 0.000 0.000 ↓ 0.0 0 443

Index Only Scan using idx_tm_mbrships1 on tm_mbrships tm (cost=0.29..9.39 rows=6 width=0) (actual time=0.000..0.000 rows=0 loops=443)

  • Index Cond: (tm_id = t.tm_id)
  • Heap Fetches: 0
243. 0.886 0.886 ↑ 1.0 1 443

Aggregate (cost=6.09..6.10 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=443)

244. 0.000 0.000 ↓ 0.0 0 443

Bitmap Heap Scan on tm_escalation te (cost=1.81..6.09 rows=3 width=8) (actual time=0.000..0.000 rows=0 loops=443)

  • Recheck Cond: (tm_id = t.tm_id)
245. 0.000 0.000 ↓ 0.0 0 443

Bitmap Index Scan on idx_tm_escalation1 (cost=0.00..1.80 rows=3 width=0) (actual time=0.000..0.000 rows=0 loops=443)

  • Index Cond: (tm_id = t.tm_id)
246. 0.443 1.772 ↑ 1.0 1 443

Aggregate (cost=4.14..4.15 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=443)

247. 1.329 1.329 ↑ 2.0 1 443

Index Scan using idx_dvc_person_id_not_deleted on dvc activedevice (cost=0.29..4.13 rows=2 width=0) (actual time=0.002..0.003 rows=1 loops=443)

  • Index Cond: (person_id = p.person_id)
  • Filter: ((status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 0
248. 0.050 186.925 ↑ 1.0 1 5

Aggregate (cost=15,633.52..15,633.53 rows=1 width=8) (actual time=37.385..37.385 rows=1 loops=5)

249. 31.920 186.875 ↑ 14.8 5 5

Hash Join (cost=10,985.04..15,633.34 rows=74 width=0) (actual time=26.571..37.375 rows=5 loops=5)

  • Hash Cond: (pntfn.ntfn_id = rntfn.ntfn_id)
250. 62.785 62.785 ↑ 1.4 80,962 5

Index Only Scan Backward using person_ntfn_ntfn_id_not_delinked_pidx on person_ntfn pntfn (cost=0.42..4,351.68 rows=113,157 width=8) (actual time=0.025..12.557 rows=80,962 loops=5)

  • Heap Fetches: 98435
251. 1.775 92.170 ↑ 5.4 1,416 5

Hash (cost=10,889.49..10,889.49 rows=7,610 width=8) (actual time=18.434..18.434 rows=1,416 loops=5)

  • Buckets: 8192 Batches: 1 Memory Usage: 107kB
252. 88.630 90.395 ↑ 5.4 1,416 5

Bitmap Heap Scan on recipient_ntfn rntfn (cost=97.77..10,889.49 rows=7,610 width=8) (actual time=0.586..18.079 rows=1,416 loops=5)

  • Recheck Cond: ((recipient_id = dowr.recipient_id) OR (recipient_id = (z.chain_ids)[(array_length(z.chain_ids, 1) - 1)]))
  • Heap Blocks: exact=7413
253. 0.015 1.765 ↓ 0.0 0 5

BitmapOr (cost=97.77..97.77 rows=7,611 width=0) (actual time=0.353..0.353 rows=0 loops=5)

254. 0.000 0.000 ↓ 0.0 0 5

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..46.98 rows=3,806 width=0) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: (recipient_id = dowr.recipient_id)
255. 1.750 1.750 ↑ 2.5 1,516 5

Bitmap Index Scan on idx_recipient_ntfn5 (cost=0.00..46.98 rows=3,806 width=0) (actual time=0.350..0.350 rows=1,516 loops=5)

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