explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1iWG : Optimization for: plan #1Fs

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.026 14,608.263 ↑ 1.0 20 1

Limit (cost=57,450.94..57,450.95 rows=20 width=1,310) (actual time=14,608.232..14,608.263 rows=20 loops=1)

2. 1.609 14,608.237 ↑ 36.1 20 1

Sort (cost=57,450.94..57,451.31 rows=723 width=1,310) (actual time=14,608.230..14,608.237 rows=20 loops=1)

  • Sort Key: ab.createdatetime DESC
  • Sort Method: top-N heapsort Memory: 65kB
3. 4.827 14,606.628 ↑ 2.3 312 1

Nested Loop Left Join (cost=15,020.98..57,447.10 rows=723 width=1,310) (actual time=83.847..14,606.628 rows=312 loops=1)

4. 51.031 14,598.369 ↑ 2.3 312 1

Nested Loop Left Join (cost=15,020.93..57,311.21 rows=723 width=1,001) (actual time=83.802..14,598.369 rows=312 loops=1)

5. 0.829 785.018 ↓ 1.1 312 1

Nested Loop Left Join (cost=282.37..29,776.76 rows=272 width=326) (actual time=9.351..785.018 rows=312 loops=1)

6. 0.754 781.693 ↓ 1.1 312 1

Nested Loop Left Join (cost=282.32..29,742.72 rows=272 width=246) (actual time=9.338..781.693 rows=312 loops=1)

7. 0.620 209.355 ↓ 1.1 312 1

Nested Loop Left Join (cost=272.08..26,956.05 rows=272 width=253) (actual time=6.853..209.355 rows=312 loops=1)

8. 1.350 204.367 ↓ 1.1 312 1

Merge Join (cost=271.97..26,883.79 rows=272 width=240) (actual time=6.839..204.367 rows=312 loops=1)

  • Merge Cond: (oc.outboundcampaignid = ab.outboundcampaignid)
9. 1.066 200.328 ↓ 1.0 312 1

Nested Loop Left Join (cost=271.92..26,857.07 rows=311 width=160) (actual time=6.809..200.328 rows=312 loops=1)

10. 42.706 77.582 ↓ 1.0 312 1

Nested Loop Left Join (cost=186.66..339.83 rows=311 width=176) (actual time=6.022..77.582 rows=312 loops=1)

  • Join Filter: (oc.flowid = q.flowid)
  • Rows Removed by Join Filter: 305136
11. 0.642 7.732 ↓ 1.0 312 1

Nested Loop Left Join (cost=0.16..134.77 rows=311 width=118) (actual time=0.043..7.732 rows=312 loops=1)

12. 1.474 1.474 ↓ 1.0 312 1

Index Scan using idx_outboundcampaign_1 on outboundcampaign oc (cost=0.05..52.16 rows=311 width=118) (actual time=0.011..1.474 rows=312 loops=1)

  • Filter: (((bottype)::text = 'amplify'::text) AND (organizationid = '1f9292ae-5446-4b89-8e09-bf7c37f0d4c7'::uuid))
  • Rows Removed by Filter: 140
13. 0.312 5.616 ↑ 1.0 1 312

Nested Loop Left Join (cost=0.11..0.26 rows=1 width=16) (actual time=0.015..0.018 rows=1 loops=312)

14. 0.936 4.992 ↑ 1.0 1 312

Nested Loop (cost=0.11..0.25 rows=1 width=32) (actual time=0.013..0.016 rows=1 loops=312)

15. 1.872 1.872 ↑ 1.0 1 312

Index Scan using idx_agent_1 on agent a (cost=0.05..0.12 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=312)

  • Index Cond: (oc.agentid = agentid)
16. 2.184 2.184 ↑ 1.0 1 312

Index Only Scan using idx_account_1 on account acc (cost=0.05..0.13 rows=1 width=16) (actual time=0.005..0.007 rows=1 loops=312)

  • Index Cond: (accountid = a.accountid)
  • Heap Fetches: 312
17. 0.312 0.312 ↑ 1.0 1 312

Result (cost=0.00..0.00 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=312)

18. 20.885 27.144 ↓ 163.2 979 312

Materialize (cost=186.50..197.60 rows=6 width=74) (actual time=0.015..0.087 rows=979 loops=312)

19. 0.279 6.259 ↓ 163.2 979 1

Subquery Scan on q (cost=186.50..197.60 rows=6 width=74) (actual time=4.455..6.259 rows=979 loops=1)

  • Filter: (q._rownum = 1)
  • Rows Removed by Filter: 199
20. 1.255 5.980 ↑ 1.0 1,178 1

WindowAgg (cost=186.50..193.28 rows=1,233 width=2,932) (actual time=4.446..5.980 rows=1,178 loops=1)

21. 1.150 4.725 ↑ 1.0 1,178 1

Sort (cost=186.50..187.12 rows=1,233 width=86) (actual time=4.441..4.725 rows=1,178 loops=1)

  • Sort Key: f.flowid, fs.ordinal, fs.createdatetime
  • Sort Method: quicksort Memory: 248kB
22. 0.448 3.575 ↑ 1.0 1,178 1

Hash Join (cost=93.80..173.84 rows=1,233 width=86) (actual time=1.404..3.575 rows=1,178 loops=1)

  • Hash Cond: (ffp.flowid = f.flowid)
23. 0.447 2.711 ↑ 1.0 1,178 1

Hash Join (cost=57.28..132.70 rows=1,233 width=86) (actual time=0.974..2.711 rows=1,178 loops=1)

  • Hash Cond: (fp.flowpageid = ffp.flowpageid)
24. 0.500 1.812 ↑ 1.0 1,296 1

Hash Join (cost=28.83..99.58 rows=1,296 width=102) (actual time=0.502..1.812 rows=1,296 loops=1)

  • Hash Cond: (fs.flowpageid = fp.flowpageid)
25. 0.841 0.841 ↑ 1.0 1,296 1

Seq Scan on flowslot fs (cost=0.00..65.89 rows=1,296 width=86) (actual time=0.007..0.841 rows=1,296 loops=1)

26. 0.206 0.471 ↓ 1.0 1,227 1

Hash (cost=24.62..24.62 rows=1,205 width=16) (actual time=0.470..0.471 rows=1,227 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 74kB
27. 0.265 0.265 ↓ 1.0 1,227 1

Seq Scan on flowpage fp (cost=0.00..24.62 rows=1,205 width=16) (actual time=0.008..0.265 rows=1,227 loops=1)

28. 0.219 0.452 ↑ 1.0 1,141 1

Hash (cost=24.44..24.44 rows=1,146 width=32) (actual time=0.452..0.452 rows=1,141 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
29. 0.233 0.233 ↑ 1.0 1,141 1

Seq Scan on flowfirstpage ffp (cost=0.00..24.44 rows=1,146 width=32) (actual time=0.006..0.233 rows=1,141 loops=1)

30. 0.197 0.416 ↑ 1.0 1,141 1

Hash (cost=32.47..32.47 rows=1,156 width=16) (actual time=0.416..0.416 rows=1,141 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
31. 0.219 0.219 ↑ 1.0 1,141 1

Seq Scan on flow f (cost=0.00..32.47 rows=1,156 width=16) (actual time=0.005..0.219 rows=1,141 loops=1)

32. 3.744 121.680 ↑ 1.0 1 312

Aggregate (cost=85.26..85.26 rows=1 width=16) (actual time=0.390..0.390 rows=1 loops=312)

33. 56.016 117.936 ↓ 21.0 21 312

Hash Right Join (cost=40.55..85.25 rows=1 width=32) (actual time=0.280..0.378 rows=21 loops=312)

  • Hash Cond: (_ar.applicantid = _a.applicantid)
  • Filter: ((_ar.flowslotid = q.flowslotid) OR (_ar.flowslotid IS NULL))
  • Rows Removed by Filter: 0
34. 53.808 53.808 ↓ 1.0 1,561 304

Seq Scan on applicantresponse _ar (cost=0.00..43.56 rows=1,520 width=48) (actual time=0.004..0.177 rows=1,561 loops=304)

35. 2.496 8.112 ↑ 1.0 21 312

Hash (cost=40.47..40.47 rows=22 width=16) (actual time=0.026..0.026 rows=21 loops=312)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 2.808 5.616 ↑ 1.0 21 312

Bitmap Heap Scan on applicant _a (cost=2.09..40.47 rows=22 width=16) (actual time=0.014..0.018 rows=21 loops=312)

  • Recheck Cond: (flowid = oc.flowid)
  • Heap Blocks: exact=515
37. 2.808 2.808 ↑ 1.0 22 312

Bitmap Index Scan on idx_applicant_flow_cdt (cost=0.00..2.09 rows=22 width=0) (actual time=0.009..0.009 rows=22 loops=312)

  • Index Cond: (flowid = oc.flowid)
38. 2.689 2.689 ↓ 1.0 389 1

Index Scan using idx_amplifybot_2 on amplifybot ab (cost=0.05..25.56 rows=380 width=80) (actual time=0.008..2.689 rows=389 loops=1)

39. 0.312 4.368 ↑ 1.0 1 312

Nested Loop Left Join (cost=0.11..0.26 rows=1 width=29) (actual time=0.011..0.014 rows=1 loops=312)

40. 0.936 3.744 ↑ 1.0 1 312

Nested Loop (cost=0.11..0.25 rows=1 width=45) (actual time=0.009..0.012 rows=1 loops=312)

41. 1.560 1.560 ↑ 1.0 1 312

Index Scan using idx_agent_1 on agent a_1 (cost=0.05..0.12 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=312)

  • Index Cond: (oc.agentid = agentid)
42. 1.248 1.248 ↑ 1.0 1 312

Index Scan using idx_account_1 on account acc_1 (cost=0.05..0.13 rows=1 width=29) (actual time=0.003..0.004 rows=1 loops=312)

  • Index Cond: (accountid = a_1.accountid)
43. 0.312 0.312 ↑ 1.0 1 312

Result (cost=0.00..0.00 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=312)

44. 1.248 571.584 ↑ 1.0 1 312

Limit (cost=10.24..10.24 rows=1 width=17) (actual time=1.829..1.832 rows=1 loops=312)

45. 3.432 570.336 ↑ 1.0 1 312

Sort (cost=10.24..10.24 rows=1 width=17) (actual time=1.827..1.828 rows=1 loops=312)

  • Sort Key: _atd.createdatetime DESC
  • Sort Method: quicksort Memory: 25kB
46. 495.456 566.904 ↑ 1.0 1 312

Bitmap Heap Scan on asynctask _atd (cost=8.23..10.24 rows=1 width=17) (actual time=0.966..1.817 rows=1 loops=312)

  • Recheck Cond: ((organizationid = oc.organizationid) AND ((handlername)::text = 'amplifyBotCampaignCreateAudienceAndStartAsyncTaskHandler'::text) AND ((metadata -> 'refType'::text) ? 'OutboundCampaign'::text))
  • Filter: ((metadata -> 'refKey'::text) ? (oc.outboundcampaignid)::text)
  • Rows Removed by Filter: 514
  • Heap Blocks: exact=53664
47. 4.368 71.448 ↓ 0.0 0 312

BitmapAnd (cost=8.23..8.23 rows=1 width=0) (actual time=0.229..0.229 rows=0 loops=312)

48. 28.080 28.080 ↓ 9.6 564 312

Bitmap Index Scan on idx_asynctask_org_handler (cost=0.00..2.17 rows=59 width=0) (actual time=0.090..0.090 rows=564 loops=312)

  • Index Cond: ((organizationid = oc.organizationid) AND ((handlername)::text = 'amplifyBotCampaignCreateAudienceAndStartAsyncTaskHandler'::text))
49. 39.000 39.000 ↓ 283.0 849 312

Bitmap Index Scan on idx_asynctask_wrapper2 (cost=0.00..6.01 rows=3 width=0) (actual time=0.125..0.125 rows=849 loops=312)

  • Index Cond: ((metadata -> 'refType'::text) ? 'OutboundCampaign'::text)
50. 2.496 2.496 ↑ 1.0 1 312

Index Scan using pk_amplifybot on amplifybot amplifybot7_ (cost=0.05..0.12 rows=1 width=80) (actual time=0.006..0.008 rows=1 loops=312)

  • Index Cond: (ab.amplifybotid = amplifybotid)
51. 30.576 13,762.320 ↑ 3.0 1 312

Hash Right Join (cost=14,738.56..14,785.59 rows=3 width=675) (actual time=40.452..44.110 rows=1 loops=312)

  • Hash Cond: (oc_2.outboundcampaignid = oc_1.outboundcampaignid)
52. 2,174.016 9,801.168 ↓ 1.0 452 312

GroupAggregate (cost=3,309.70..3,355.09 rows=435 width=64) (actual time=23.833..31.414 rows=452 loops=312)

  • Group Key: oc_2.outboundcampaignid
53. 848.016 7,627.152 ↓ 1.0 6,889 312

Sort (cost=3,309.70..3,313.09 rows=6,783 width=41) (actual time=23.813..24.446 rows=6,889 loops=312)

  • Sort Key: oc_2.outboundcampaignid
  • Sort Method: quicksort Memory: 728kB
54. 572.651 6,779.136 ↓ 1.0 6,889 312

Hash Right Join (cost=346.21..3,223.37 rows=6,783 width=41) (actual time=0.068..21.728 rows=6,889 loops=312)

  • Hash Cond: (aca.outboundcampaignid = oc_2.outboundcampaignid)
55. 1,297.200 6,206.304 ↓ 1.0 6,816 312

Hash Right Join (cost=323.38..3,175.10 rows=6,783 width=41) (actual time=0.067..19.892 rows=6,816 loops=312)

  • Hash Cond: ((md.messageid = am.messageid) AND (md.torefkey = aca.outboundcampaignapplicantid))
56. 4,902.768 4,902.768 ↓ 1.0 19,232 312

Seq Scan on messagedelivery md (cost=0.00..2,823.51 rows=18,807 width=41) (actual time=0.006..15.714 rows=19,232 loops=312)

  • Filter: ((channeltype)::text = 'sms'::text)
  • Rows Removed by Filter: 46031
57. 1.606 6.336 ↓ 1.0 6,816 1

Hash (cost=296.25..296.25 rows=6,783 width=64) (actual time=6.336..6.336 rows=6,816 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 628kB
58. 1.339 4.730 ↓ 1.0 6,816 1

Hash Right Join (cost=182.09..296.25 rows=6,783 width=64) (actual time=2.537..4.730 rows=6,816 loops=1)

  • Hash Cond: (am.applicantid = aca.applicantid)
59. 0.908 0.908 ↓ 1.0 2,724 1

Seq Scan on applicantmessage am (cost=0.00..104.01 rows=2,706 width=32) (actual time=0.012..0.908 rows=2,724 loops=1)

  • Filter: ((direction)::text = 'out'::text)
  • Rows Removed by Filter: 1850
60. 1.435 2.483 ↓ 1.0 6,816 1

Hash (cost=158.35..158.35 rows=6,783 width=48) (actual time=2.482..2.483 rows=6,816 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 597kB
61. 1.048 1.048 ↓ 1.0 6,816 1

Seq Scan on outboundcampaignapplicant aca (cost=0.00..158.35 rows=6,783 width=48) (actual time=0.004..1.048 rows=6,816 loops=1)

62. 0.073 0.181 ↓ 1.0 452 1

Hash (cost=21.30..21.30 rows=435 width=16) (actual time=0.181..0.181 rows=452 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
63. 0.108 0.108 ↓ 1.0 452 1

Seq Scan on outboundcampaign oc_2 (cost=0.00..21.30 rows=435 width=16) (actual time=0.013..0.108 rows=452 loops=1)

64. 1.248 3,930.576 ↑ 3.0 1 312

Hash (cost=11,428.85..11,428.85 rows=3 width=611) (actual time=12.598..12.598 rows=1 loops=312)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
65. 2.496 3,929.328 ↑ 3.0 1 312

Nested Loop Left Join (cost=11,250.49..11,428.85 rows=3 width=611) (actual time=12.365..12.594 rows=1 loops=312)

66. 34.944 3,814.200 ↑ 3.0 1 312

Hash Right Join (cost=11,165.23..11,173.05 rows=3 width=587) (actual time=11.996..12.225 rows=1 loops=312)

  • Hash Cond: (f_1.flowid = oc_1.flowid)
67. 127.692 145.392 ↑ 1.0 1,141 312

HashAggregate (cost=886.35..889.82 rows=1,156 width=64) (actual time=0.094..0.466 rows=1,141 loops=312)

  • Group Key: f_1.flowid
68. 4.163 17.700 ↓ 1.1 14,843 1

Hash Left Join (cost=334.75..808.98 rows=14,068 width=56) (actual time=5.220..17.700 rows=14,843 loops=1)

  • Hash Cond: (a_3.applicantid = ac.applicantid)
69. 3.669 8.765 ↓ 1.1 14,843 1

Hash Right Join (cost=36.51..459.47 rows=14,068 width=40) (actual time=0.370..8.765 rows=14,843 loops=1)

  • Hash Cond: (a_3.flowid = f_1.flowid)
70. 4.747 4.747 ↓ 1.0 14,392 1

Seq Scan on applicant a_3 (cost=0.00..370.20 rows=14,068 width=40) (actual time=0.004..4.747 rows=14,392 loops=1)

71. 0.190 0.349 ↑ 1.0 1,141 1

Hash (cost=32.47..32.47 rows=1,156 width=16) (actual time=0.349..0.349 rows=1,141 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
72. 0.159 0.159 ↑ 1.0 1,141 1

Seq Scan on flow f_1 (cost=0.00..32.47 rows=1,156 width=16) (actual time=0.006..0.159 rows=1,141 loops=1)

73. 2.491 4.772 ↑ 1.0 13,497 1

Hash (cost=250.72..250.72 rows=13,574 width=32) (actual time=4.771..4.772 rows=13,497 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 972kB
74. 2.281 2.281 ↑ 1.0 13,497 1

Seq Scan on applicantcandidate ac (cost=0.00..250.72 rows=13,574 width=32) (actual time=0.010..2.281 rows=13,497 loops=1)

75. 3.432 3,633.864 ↑ 1.0 1 312

Hash (cost=10,278.88..10,278.88 rows=1 width=539) (actual time=11.647..11.647 rows=1 loops=312)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 38.376 3,630.432 ↑ 1.0 1 312

Hash Right Join (cost=10,267.77..10,278.88 rows=1 width=539) (actual time=10.898..11.636 rows=1 loops=312)

  • Hash Cond: (q_1.flowid = oc_1.flowid)
77. 54.912 3,584.256 ↓ 163.2 979 312

Subquery Scan on q_1 (cost=10,267.33..10,278.43 rows=6 width=319) (actual time=10.173..11.488 rows=979 loops=312)

  • Filter: (q_1._rownum = 1)
  • Rows Removed by Filter: 199
78. 306.384 3,529.344 ↑ 1.0 1,178 312

WindowAgg (cost=10,267.33..10,274.11 rows=1,233 width=3,113) (actual time=10.172..11.312 rows=1,178 loops=312)

79. 359.112 3,222.960 ↑ 1.0 1,178 312

Sort (cost=10,267.33..10,267.95 rows=1,233 width=331) (actual time=10.166..10.330 rows=1,178 loops=312)

  • Sort Key: f_2.flowid, fs_1.ordinal, fs_1.createdatetime
  • Sort Method: quicksort Memory: 567kB
80. 336.960 2,863.848 ↑ 1.0 1,178 312

Nested Loop Left Join (cost=101.96..10,254.67 rows=1,233 width=331) (actual time=0.026..9.179 rows=1,178 loops=312)

81. 149.423 689.208 ↑ 1.0 1,178 312

Hash Join (cost=93.80..173.84 rows=1,233 width=299) (actual time=0.016..2.209 rows=1,178 loops=312)

  • Hash Cond: (ffp_1.flowid = f_2.flowid)
82. 141.290 539.448 ↑ 1.0 1,178 312

Hash Join (cost=57.28..132.70 rows=1,233 width=299) (actual time=0.014..1.729 rows=1,178 loops=312)

  • Hash Cond: (fp_1.flowpageid = ffp_1.flowpageid)
83. 209.580 397.800 ↑ 1.0 1,296 312

Hash Join (cost=28.83..99.58 rows=1,296 width=315) (actual time=0.008..1.275 rows=1,296 loops=312)

  • Hash Cond: (fs_1.flowpageid = fp_1.flowpageid)
84. 187.824 187.824 ↑ 1.0 1,296 312

Seq Scan on flowslot fs_1 (cost=0.00..65.89 rows=1,296 width=299) (actual time=0.005..0.602 rows=1,296 loops=312)

85. 0.221 0.396 ↓ 1.0 1,227 1

Hash (cost=24.62..24.62 rows=1,205 width=16) (actual time=0.396..0.396 rows=1,227 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 74kB
86. 0.175 0.175 ↓ 1.0 1,227 1

Seq Scan on flowpage fp_1 (cost=0.00..24.62 rows=1,205 width=16) (actual time=0.003..0.175 rows=1,227 loops=1)

87. 0.233 0.358 ↑ 1.0 1,141 1

Hash (cost=24.44..24.44 rows=1,146 width=32) (actual time=0.358..0.358 rows=1,141 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
88. 0.125 0.125 ↑ 1.0 1,141 1

Seq Scan on flowfirstpage ffp_1 (cost=0.00..24.44 rows=1,146 width=32) (actual time=0.004..0.125 rows=1,141 loops=1)

89. 0.181 0.337 ↑ 1.0 1,141 1

Hash (cost=32.47..32.47 rows=1,156 width=16) (actual time=0.337..0.337 rows=1,141 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
90. 0.156 0.156 ↑ 1.0 1,141 1

Seq Scan on flow f_2 (cost=0.00..32.47 rows=1,156 width=16) (actual time=0.006..0.156 rows=1,141 loops=1)

91. 367.536 1,837.680 ↑ 1.0 1 367,536

Aggregate (cost=8.17..8.17 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=367,536)

92. 75.504 1,470.144 ↓ 0.0 0 367,536

Nested Loop (cost=0.13..8.17 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=367,536)

93. 105.456 1,102.608 ↓ 0.0 0 367,536

Nested Loop (cost=0.11..8.12 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=367,536)

94. 735.072 735.072 ↓ 0.0 0 367,536

Index Scan using idx_flowslotbranch_2 on flowslotbranch fsb (cost=0.05..4.06 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=367,536)

  • Index Cond: (flowslotid = fs_1.flowslotid)
95. 262.080 262.080 ↑ 1.0 1 131,040

Index Scan using idx_flowslotbranchaction_2 on flowslotbranchaction fsba (cost=0.05..4.06 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=131,040)

  • Index Cond: (flowslotbranchid = fsb.flowslotbranchid)
96. 292.032 292.032 ↑ 1.0 1 146,016

Index Only Scan using idx_flowaction_1 on flowaction fa (cost=0.03..0.04 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=146,016)

  • Index Cond: (flowactionid = fsba.flowactionid)
  • Heap Fetches: 146016
97. 0.936 7.800 ↑ 1.0 1 312

Hash (cost=0.44..0.44 rows=1 width=204) (actual time=0.025..0.025 rows=1 loops=312)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
98. 0.936 6.864 ↑ 1.0 1 312

Nested Loop Left Join (cost=0.16..0.44 rows=1 width=204) (actual time=0.021..0.022 rows=1 loops=312)

99. 2.184 2.184 ↑ 1.0 1 312

Index Scan using idx_outboundcampaign_1 on outboundcampaign oc_1 (cost=0.05..0.19 rows=1 width=191) (actual time=0.007..0.007 rows=1 loops=312)

  • Index Cond: (ab.outboundcampaignid = outboundcampaignid)
100. 0.312 3.744 ↑ 1.0 1 312

Nested Loop Left Join (cost=0.11..0.24 rows=1 width=29) (actual time=0.011..0.012 rows=1 loops=312)

101. 0.936 3.120 ↑ 1.0 1 312

Nested Loop (cost=0.11..0.24 rows=1 width=45) (actual time=0.009..0.010 rows=1 loops=312)

102. 0.936 0.936 ↑ 1.0 1 312

Index Scan using idx_agent_1 on agent a_2 (cost=0.05..0.10 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=312)

  • Index Cond: (oc_1.agentid = agentid)
103. 1.248 1.248 ↑ 1.0 1 312

Index Scan using idx_account_1 on account acc_2 (cost=0.05..0.13 rows=1 width=29) (actual time=0.003..0.004 rows=1 loops=312)

  • Index Cond: (accountid = a_2.accountid)
104. 0.312 0.312 ↑ 1.0 1 312

Result (cost=0.00..0.00 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=312)

105. 3.432 112.632 ↑ 1.0 1 312

Aggregate (cost=85.26..85.26 rows=1 width=16) (actual time=0.361..0.361 rows=1 loops=312)

106. 54.904 109.200 ↓ 21.0 21 312

Hash Right Join (cost=40.55..85.25 rows=1 width=32) (actual time=0.260..0.350 rows=21 loops=312)

  • Hash Cond: (_ar_1.applicantid = _a_1.applicantid)
  • Filter: ((_ar_1.flowslotid = q_1.flowslotid) OR (_ar_1.flowslotid IS NULL))
  • Rows Removed by Filter: 0
107. 47.120 47.120 ↓ 1.0 1,561 304

Seq Scan on applicantresponse _ar_1 (cost=0.00..43.56 rows=1,520 width=48) (actual time=0.003..0.155 rows=1,561 loops=304)

108. 2.184 7.176 ↑ 1.0 21 312

Hash (cost=40.47..40.47 rows=22 width=16) (actual time=0.023..0.023 rows=21 loops=312)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
109. 2.808 4.992 ↑ 1.0 21 312

Bitmap Heap Scan on applicant _a_1 (cost=2.09..40.47 rows=22 width=16) (actual time=0.012..0.016 rows=21 loops=312)

  • Recheck Cond: (flowid = oc_1.flowid)
  • Heap Blocks: exact=515
110. 2.184 2.184 ↑ 1.0 22 312

Bitmap Index Scan on idx_applicant_flow_cdt (cost=0.00..2.09 rows=22 width=0) (actual time=0.007..0.007 rows=22 loops=312)

  • Index Cond: (flowid = oc_1.flowid)
111. 3.432 3.432 ↑ 1.0 1 312

Index Scan using idx_outboundcampaign_1 on outboundcampaign outboundca2_ (cost=0.05..0.17 rows=1 width=191) (actual time=0.010..0.011 rows=1 loops=312)

  • Index Cond: (oc_1.outboundcampaignid = outboundcampaignid)