explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hUsm

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 26,144.836 ↓ 20.0 20 1

Limit (cost=541,578.71..541,612.63 rows=1 width=2,914) (actual time=26,141.174..26,144.836 rows=20 loops=1)

2. 4.480 26,144.826 ↓ 20.0 20 1

Result (cost=541,578.71..541,612.63 rows=1 width=2,914) (actual time=26,141.170..26,144.826 rows=20 loops=1)

3. 8.660 26,139.306 ↓ 20.0 20 1

Sort (cost=541,578.71..541,578.72 rows=1 width=2,690) (actual time=26,139.296..26,139.306 rows=20 loops=1)

  • Sort Key: conversation.lastmessagedatetime DESC
  • Sort Method: top-N heapsort Memory: 40kB
4. 3,522.663 26,130.646 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=86,939.23..541,578.70 rows=1 width=2,690) (actual time=813.729..26,130.646 rows=1,732 loops=1)

  • Join Filter: (candidate3_.candidateid = candidates6_.candidateid)
  • Rows Removed by Join Filter: 36003084
5. 434.440 15,811.615 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=86,939.23..537,654.98 rows=1 width=1,435) (actual time=790.320..15,811.615 rows=1,732 loops=1)

  • Join Filter: (candidater4_.candidateresumeid = candidatep5_.candidateresumeid)
  • Rows Removed by Join Filter: 5331096
6. 484.027 14,938.979 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=86,939.23..537,537.73 rows=1 width=1,339) (actual time=789.652..14,938.979 rows=1,732 loops=1)

  • Join Filter: (candidate3_.candidateid = candidater4_.candidateid)
  • Rows Removed by Join Filter: 5414232
7. 3.390 13,989.044 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=86,939.23..537,404.39 rows=1 width=1,209) (actual time=788.905..13,989.044 rows=1,732 loops=1)

8. 5.586 13,952.746 ↓ 1,732.0 1,732 1

Merge Join (cost=86,938.81..537,400.37 rows=1 width=573) (actual time=788.883..13,952.746 rows=1,732 loops=1)

  • Merge Cond: (c.candidateid = c_1.candidateid)
9. 3.614 13,601.406 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=23,183.53..473,241.63 rows=1 width=605) (actual time=472.986..13,601.406 rows=1,732 loops=1)

10. 5.152 13,583.936 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=23,182.68..473,224.72 rows=1 width=637) (actual time=472.970..13,583.936 rows=1,732 loops=1)

11. 129.133 13,469.668 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=23,165.78..473,207.79 rows=1 width=637) (actual time=472.866..13,469.668 rows=1,732 loops=1)

  • Join Filter: (((co.ownertype)::text = 'team'::text) AND (cot.conversationownerid = co.conversationownerid))
  • Rows Removed by Join Filter: 1378672
12. 3,481.871 13,222.759 ↓ 1,732.0 1,732 1

Nested Loop Left Join (cost=23,165.78..473,174.89 rows=1 width=658) (actual time=472.673..13,222.759 rows=1,732 loops=1)

  • Join Filter: (_cs.candidateid = c.candidateid)
  • Rows Removed by Join Filter: 36003084
13. 1,504.686 3,020.728 ↓ 1,732.0 1,732 1

Nested Loop (cost=23,165.78..469,251.18 rows=1 width=642) (actual time=449.653..3,020.728 rows=1,732 loops=1)

  • Join Filter: (pc.candidateid = c.candidateid)
  • Rows Removed by Join Filter: 17441240
14. 12.205 327.664 ↑ 1.0 10,071 1

Nested Loop Left Join (cost=18,687.88..440,415.90 rows=10,086 width=549) (actual time=37.687..327.664 rows=10,071 loops=1)

15. 10.228 124.110 ↑ 1.0 10,071 1

Nested Loop Left Join (cost=18,646.65..24,181.48 rows=10,086 width=421) (actual time=37.634..124.110 rows=10,071 loops=1)

  • Join Filter: (c.sourcetoolid = st.sourcetoolid)
  • Rows Removed by Join Filter: 80568
16. 14.958 103.811 ↑ 1.0 10,071 1

Nested Loop Left Join (cost=18,646.65..22,818.75 rows=10,086 width=357) (actual time=37.608..103.811 rows=10,071 loops=1)

  • Join Filter: (c.sourcedataid = sd.sourcedataid)
  • Rows Removed by Join Filter: 50355
17. 8.291 88.853 ↑ 1.0 10,071 1

Nested Loop Left Join (cost=18,646.65..21,909.94 rows=10,086 width=293) (actual time=37.561..88.853 rows=10,071 loops=1)

18. 6.680 50.349 ↑ 1.0 10,071 1

Merge Left Join (cost=18,646.37..18,713.71 rows=10,086 width=280) (actual time=37.550..50.349 rows=10,071 loops=1)

  • Merge Cond: (c.candidateid = cr.candidateid)
19. 12.753 36.450 ↑ 1.0 10,071 1

Sort (cost=18,038.75..18,063.96 rows=10,086 width=223) (actual time=31.765..36.450 rows=10,071 loops=1)

  • Sort Key: c.candidateid
  • Sort Method: quicksort Memory: 2852kB
20. 22.681 23.697 ↑ 1.0 10,071 1

Bitmap Heap Scan on candidate c (cost=234.59..17,368.02 rows=10,086 width=223) (actual time=1.421..23.697 rows=10,071 loops=1)

  • Recheck Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
  • Heap Blocks: exact=3383
21. 1.016 1.016 ↑ 1.0 10,071 1

Bitmap Index Scan on idx_candidate_4 (cost=0.00..232.06 rows=10,086 width=0) (actual time=1.016..1.016 rows=10,071 loops=1)

  • Index Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
22. 2.879 7.219 ↑ 1.0 3,126 1

Sort (cost=607.62..615.44 rows=3,126 width=73) (actual time=5.781..7.219 rows=3,126 loops=1)

  • Sort Key: cr.candidateid
  • Sort Method: quicksort Memory: 477kB
23. 0.825 4.340 ↑ 1.0 3,126 1

Hash Left Join (cost=246.41..426.16 rows=3,126 width=73) (actual time=2.318..4.340 rows=3,126 loops=1)

  • Hash Cond: (cpr.parsedresumeid = pr.parsedresumeid)
24. 0.851 2.181 ↑ 1.0 3,126 1

Hash Left Join (cost=117.26..254.02 rows=3,126 width=64) (actual time=0.972..2.181 rows=3,126 loops=1)

  • Hash Cond: (cr.candidateresumeid = cpr.candidateresumeid)
25. 0.385 0.385 ↑ 1.0 3,126 1

Seq Scan on candidateresume cr (cost=0.00..94.26 rows=3,126 width=32) (actual time=0.012..0.385 rows=3,126 loops=1)

26. 0.518 0.945 ↑ 1.0 3,078 1

Hash (cost=78.78..78.78 rows=3,078 width=48) (actual time=0.945..0.945 rows=3,078 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 233kB
27. 0.427 0.427 ↑ 1.0 3,078 1

Seq Scan on candidateparsedresume cpr (cost=0.00..78.78 rows=3,078 width=48) (actual time=0.007..0.427 rows=3,078 loops=1)

28. 0.643 1.334 ↑ 1.0 3,207 1

Hash (cost=89.07..89.07 rows=3,207 width=25) (actual time=1.334..1.334 rows=3,207 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 173kB
29. 0.691 0.691 ↑ 1.0 3,207 1

Seq Scan on parsedresume pr (cost=0.00..89.07 rows=3,207 width=25) (actual time=0.014..0.691 rows=3,207 loops=1)

30. 30.213 30.213 ↑ 1.0 1 10,071

Index Scan using idx_account_1 on account sa (cost=0.28..0.31 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=10,071)

  • Index Cond: (accountid = c.sourceaccountid)
31. 0.000 0.000 ↑ 1.0 6 10,071

Materialize (cost=0.00..1.09 rows=6 width=80) (actual time=0.000..0.000 rows=6 loops=10,071)

32. 0.041 0.041 ↑ 1.0 6 1

Seq Scan on sourcedata sd (cost=0.00..1.06 rows=6 width=80) (actual time=0.040..0.041 rows=6 loops=1)

33. 10.047 10.071 ↑ 1.0 9 10,071

Materialize (cost=0.00..1.14 rows=9 width=80) (actual time=0.000..0.001 rows=9 loops=10,071)

34. 0.024 0.024 ↑ 1.0 9 1

Seq Scan on sourcetool st (cost=0.00..1.09 rows=9 width=80) (actual time=0.022..0.024 rows=9 loops=1)

35. 50.355 191.349 ↑ 1.0 1 10,071

Aggregate (cost=41.24..41.25 rows=1 width=128) (actual time=0.019..0.019 rows=1 loops=10,071)

36. 51.372 140.994 ↑ 3.0 1 10,071

Nested Loop (cost=4.73..41.18 rows=3 width=52) (actual time=0.012..0.014 rows=1 loops=10,071)

37. 20.142 60.426 ↑ 3.0 1 10,071

Bitmap Heap Scan on bulkimportcandidate bic (cost=4.45..16.26 rows=3 width=22) (actual time=0.006..0.006 rows=1 loops=10,071)

  • Recheck Cond: (candidateid = c.candidateid)
  • Heap Blocks: exact=9533
38. 40.284 40.284 ↑ 3.0 1 10,071

Bitmap Index Scan on idx_bulkimportcandidate_3 (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=1 loops=10,071)

  • Index Cond: (candidateid = c.candidateid)
39. 29.196 29.196 ↑ 1.0 1 9,732

Index Scan using idx_bulkimport_4 on bulkimport __bi (cost=0.28..8.30 rows=1 width=46) (actual time=0.003..0.003 rows=1 loops=9,732)

  • Index Cond: (bulkimportid = bic.bulkimportid)
40. 778.493 1,188.378 ↓ 144.3 1,732 10,071

Materialize (cost=4,477.90..27,019.83 rows=12 width=93) (actual time=0.002..0.118 rows=1,732 loops=10,071)

41. 7.466 409.885 ↓ 144.3 1,732 1

Nested Loop (cost=4,477.90..27,019.77 rows=12 width=93) (actual time=17.832..409.885 rows=1,732 loops=1)

42. 1.553 362.539 ↓ 9.0 9,970 1

Nested Loop (cost=4,477.48..26,436.31 rows=1,107 width=77) (actual time=17.812..362.539 rows=9,970 loops=1)

43. 0.055 0.055 ↑ 1.0 1 1

Seq Scan on organization (cost=0.00..7.08 rows=1 width=16) (actual time=0.037..0.055 rows=1 loops=1)

  • Filter: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
  • Rows Removed by Filter: 165
44. 4.206 360.931 ↓ 9.0 9,970 1

Nested Loop (cost=4,477.48..26,418.17 rows=1,107 width=93) (actual time=17.773..360.931 rows=9,970 loops=1)

45. 2.448 296.905 ↓ 9.0 9,970 1

Nested Loop (cost=4,477.06..25,391.45 rows=1,107 width=77) (actual time=17.759..296.905 rows=9,970 loops=1)

  • Join Filter: (conversation.conversationid = p_system.conversationid)
46. 45.985 264.547 ↓ 9.0 9,970 1

Nested Loop (cost=4,476.63..24,615.68 rows=1,108 width=109) (actual time=17.750..264.547 rows=9,970 loops=1)

  • -> Index Scan using idx_participantcandidate_1 on participantcandidate pc (cost=0.42..0.53 rows=1 width=32) (actual time=0.004..0.004 rows=1 loo (...)
47. 49.860 218.562 ↓ 3.0 9,970 1

Nested Loop (cost=4,476.21..22,826.87 rows=3,319 width=125) (actual time=17.709..218.562 rows=9,970 loops=1)

  • -> Index Scan using idx_participantchannel_2 on participantchannel pcchan (cost=0.42..0.52 rows=1 width=16) (actual time=0.004..0.005 rows (...)
  • Index Cond: (participantid = p_candidate.participantid)
48. 77.866 168.702 ↓ 1.0 9,970 1

Nested Loop (cost=4,475.79..17,599.67 rows=9,944 width=109) (actual time=17.665..168.702 rows=9,970 loops=1)

  • Join Filter: (conversation.conversationid = p_candidate.conversationid)
  • -> Index Scan using idx_participant_3 on participant p_candidate (cost=0.42..0.69 rows=1 width=32) (actual time=0.007..0.007 rows=1 (...)
  • Index Cond: (participantid = p_candidate.participantid)
  • Filter: ((channeltype)::text = 'sms'::text)
49. 28.181 90.836 ↓ 1.0 9,970 1

Hash Join (cost=4,475.37..10,657.29 rows=9,875 width=77) (actual time=17.650..90.836 rows=9,970 loops=1)

  • Hash Cond: (co.conversationid = conversation.conversationid)
  • Index Cond: ((conversationid = co.conversationid) AND ((role)::text = 'candidate'::text))
50. 45.091 45.091 ↓ 1.0 175,963 1

Seq Scan on conversationowner co (cost=0.00..5,423.49 rows=175,916 width=37) (actual time=0.018..45.091 rows=175,963 loops=1)

  • Filter: ((ownertype)::text = 'agent'::text)
  • Rows Removed by Filter: 796
51. 17.564 17.564 ↓ 1.0 9,970 1

Hash (cost=4,351.34..4,351.34 rows=9,922 width=40) (actual time=17.564..17.564 rows=9,970 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 687kB
  • -> Bitmap Heap Scan on conversation (cost=233.32..4351.34 rows=9922 width=40) (actual time=1.181..15.409 rows=9970 loops (...)
  • Recheck Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
  • Heap Blocks: exact=2167
  • -> Bitmap Index Scan on idx_conversation_2 (cost=0.00..230.83 rows=9922 width=0) (actual time=0.928..0.928 rows=99 (...)
  • Index Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
52. 29.910 29.910 ↑ 1.0 1 9,970

Index Only Scan using idx_participant_3 on participant p_system (cost=0.42..0.69 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=9,970)

  • Index Cond: ((conversationid = p_candidate.conversationid) AND (role = 'system'::text))
  • Heap Fetches: 9970
53. 59.820 59.820 ↑ 1.0 1 9,970

Index Only Scan using idx_candidate_1 on candidate (cost=0.42..0.92 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=9,970)

  • Index Cond: (candidateid = pc.candidateid)
  • Heap Fetches: 9970
54. 39.880 39.880 ↓ 0.0 0 9,970

Index Scan using idx_conversationowneragent_2 on conversationowneragent coa (cost=0.42..0.52 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=9,970)

  • Index Cond: (conversationownerid = co.conversationownerid)
  • Filter: (agentid = 'dbb6b117-b9c9-4457-bac9-174c169653df'::uuid)
  • Rows Removed by Filter: 1
55. 6,720.160 6,720.160 ↑ 1.0 20,787 1,732

Seq Scan on candidatesync _cs (cost=0.00..3,663.87 rows=20,787 width=32) (actual time=0.002..3.880 rows=20,787 loops=1,732)

56. 117.776 117.776 ↑ 1.0 796 1,732

Seq Scan on conversationownerteam cot (cost=0.00..20.96 rows=796 width=16) (actual time=0.002..0.068 rows=796 loops=1,732)

57. 5.196 109.116 ↑ 1.0 1 1,732

Limit (cost=16.90..16.91 rows=1 width=628) (actual time=0.063..0.063 rows=1 loops=1,732)

58. 15.588 103.920 ↑ 1.0 1 1,732

Sort (cost=16.90..16.91 rows=1 width=628) (actual time=0.060..0.060 rows=1 loops=1,732)

  • Sort Key: _p_agent.lastmessagedatetime DESC
  • Sort Method: quicksort Memory: 17kB
59. 3.464 88.332 ↑ 1.0 1 1,732

Nested Loop (cost=0.84..16.89 rows=1 width=628) (actual time=0.051..0.051 rows=1 loops=1,732)

60. 57.156 57.156 ↑ 1.0 1 1,732

Index Scan using idx_participant_3 on participant _p_agent (cost=0.42..8.45 rows=1 width=24) (actual time=0.032..0.033 rows=1 loops=1,732)

  • Index Cond: ((conversationid = conversation.conversationid) AND ((role)::text = 'agent'::text))
61. 27.712 27.712 ↑ 1.0 1 1,732

Index Only Scan using idx_participantagent_3 on participantagent _pa (cost=0.42..8.44 rows=1 width=16) (actual time=0.015..0.016 rows=1 loops=1,732)

  • Index Cond: (participantid = _p_agent.participantid)
  • Heap Fetches: 1732
62. 1.732 13.856 ↑ 1.0 1 1,732

Limit (cost=0.84..16.90 rows=1 width=628) (actual time=0.008..0.008 rows=1 loops=1,732)

63. 3.464 12.124 ↑ 1.0 1 1,732

Nested Loop (cost=0.84..16.90 rows=1 width=628) (actual time=0.007..0.007 rows=1 loops=1,732)

64. 5.196 5.196 ↑ 1.0 1 1,732

Index Scan using idx_participant_3 on participant _p_agent_1 (cost=0.42..8.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,732)

  • Index Cond: ((conversationid = conversation.conversationid) AND ((role)::text = 'agent'::text))
65. 3.464 3.464 ↑ 1.0 1 1,732

Index Only Scan using idx_participantagent_3 on participantagent _pa_1 (cost=0.42..8.44 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,732)

  • Index Cond: ((participantid = _p_agent_1.participantid) AND (agentid = coa.agentid))
  • Heap Fetches: 1732
66. 1.745 345.754 ↑ 5.8 1,732 1

Materialize (cost=63,755.28..64,133.51 rows=10,086 width=16) (actual time=315.893..345.754 rows=1,732 loops=1)

67. 24.197 344.009 ↑ 5.8 1,732 1

GroupAggregate (cost=63,755.28..64,007.43 rows=10,086 width=160) (actual time=315.890..344.009 rows=1,732 loops=1)

  • Group Key: c_1.candidateid
  • Filter: (array_remove(array_agg(CASE WHEN (((co_1.ownertype)::text = 'agent'::text) AND ((_c.status)::text = 'active'::text)) THEN coa_1.agentid ELSE NULL::uuid END), NULL::uuid) @> '{dbb6b117-b9c9-44 (...)
  • Rows Removed by Filter: 8339
68. 10.615 319.812 ↓ 1.0 10,268 1

Sort (cost=63,755.28..63,780.50 rows=10,086 width=59) (actual time=315.869..319.812 rows=10,268 loops=1)

  • Sort Key: c_1.candidateid
  • Sort Method: quicksort Memory: 1602kB
69. 4.277 309.197 ↓ 1.0 10,268 1

Nested Loop Left Join (cost=236.97..63,084.56 rows=10,086 width=59) (actual time=1.702..309.197 rows=10,268 loops=1)

70. 21.899 22.932 ↑ 1.0 10,071 1

Bitmap Heap Scan on candidate c_1 (cost=234.59..17,368.02 rows=10,086 width=32) (actual time=1.445..22.932 rows=10,071 loops=1)

  • Recheck Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
  • Heap Blocks: exact=3383
71. 1.033 1.033 ↑ 1.0 10,071 1

Bitmap Index Scan on idx_candidate_4 (cost=0.00..232.06 rows=10,086 width=0) (actual time=1.033..1.033 rows=10,071 loops=1)

  • Index Cond: (organizationid = 'de6cd781-8caa-435b-85a3-c916b9c9397f'::uuid)
72. 10.172 281.988 ↑ 1.0 1 10,071

Nested Loop Left Join (cost=2.38..4.52 rows=1 width=43) (actual time=0.026..0.028 rows=1 loops=10,071)

  • Join Filter: ((co_1.ownertype)::text = 'team'::text)
73. 0.404 261.846 ↑ 1.0 1 10,071

Nested Loop Left Join (cost=2.11..4.22 rows=1 width=59) (actual time=0.025..0.026 rows=1 loops=10,071)

  • Join Filter: ((co_1.ownertype)::text = 'agent'::text)
74. 10.475 221.562 ↑ 1.0 1 10,071

Nested Loop (cost=1.68..3.69 rows=1 width=43) (actual time=0.021..0.022 rows=1 loops=10,071)

75. 10.576 171.207 ↑ 1.0 1 10,071

Nested Loop (cost=1.26..3.21 rows=1 width=54) (actual time=0.016..0.017 rows=1 loops=10,071)

76. 10.677 110.781 ↑ 1.0 1 10,071

Nested Loop (cost=0.84..2.73 rows=1 width=32) (actual time=0.010..0.011 rows=1 loops=10,071)

77. 40.284 40.284 ↑ 1.0 1 10,071

Index Scan using idx_participantcandidate_2 on participantcandidate _pc (cost=0.42..2.05 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=10,071)

  • Index Cond: (candidateid = c_1.candidateid)
78. 59.820 59.820 ↑ 1.0 1 9,970

Index Scan using idx_participant_2 on participant _p1 (cost=0.42..0.67 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=9,970)

  • Index Cond: (participantid = _pc.participantid)
79. 49.850 49.850 ↑ 1.0 1 9,970

Index Scan using idx_conversation_1 on conversation _c (cost=0.42..0.47 rows=1 width=22) (actual time=0.005..0.005 rows=1 loops=9,970)

  • Index Cond: (conversationid = _p1.conversationid)
80. 39.880 39.880 ↑ 1.0 1 9,970

Index Scan using idx_conversationowner_2 on conversationowner co_1 (cost=0.42..0.47 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=9,970)

  • Index Cond: (conversationid = _p1.conversationid)
81. 39.880 39.880 ↑ 1.0 1 9,970

Index Scan using idx_conversationowneragent_2 on conversationowneragent coa_1 (cost=0.42..0.51 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=9,970)

  • Index Cond: (conversationownerid = co_1.conversationownerid)
82. 9.970 9.970 ↓ 0.0 0 9,970

Index Only Scan using idx_conversationownerteam_2 on conversationownerteam cot_1 (cost=0.28..0.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=9,970)

  • Index Cond: (conversationownerid = co_1.conversationownerid)
  • Heap Fetches: 0
83. 32.908 32.908 ↑ 1.0 1 1,732

Index Scan using idx_candidate_1 on candidate candidate3_ (cost=0.42..4.02 rows=1 width=636) (actual time=0.018..0.019 rows=1 loops=1,732)

  • Index Cond: (c.candidateid = candidateid)
84. 465.908 465.908 ↑ 1.0 3,126 1,732

Seq Scan on candidateresume candidater4_ (cost=0.00..94.26 rows=3,126 width=130) (actual time=0.002..0.269 rows=3,126 loops=1,732)

85. 438.196 438.196 ↑ 1.0 3,078 1,732

Seq Scan on candidateparsedresume candidatep5_ (cost=0.00..78.78 rows=3,078 width=96) (actual time=0.002..0.253 rows=3,078 loops=1,732)

86. 6,796.368 6,796.368 ↑ 1.0 20,787 1,732

Seq Scan on candidatesync candidates6_ (cost=0.00..3,663.87 rows=20,787 width=1,282) (actual time=0.001..3.924 rows=20,787 loops=1,732)

87.          

SubPlan (forResult)

88. 0.240 0.240 ↓ 0.0 0 20

Index Scan using idx_candidatesocialsite_3 on candidatesocialsite css (cost=0.29..8.31 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=20)

  • Index Cond: (candidateid = c.candidateid)
89. 0.100 0.420 ↑ 2.0 1 20

Bitmap Heap Scan on candidatejob cj (cost=4.44..12.28 rows=2 width=16) (actual time=0.021..0.021 rows=1 loops=20)

  • Recheck Cond: (candidateid = c.candidateid)
  • Heap Blocks: exact=16
90. 0.320 0.320 ↑ 2.0 1 20

Bitmap Index Scan on idx_candidatejob_4 (cost=0.00..4.43 rows=2 width=0) (actual time=0.016..0.016 rows=1 loops=20)

  • Index Cond: (candidateid = c.candidateid)
91. 0.020 0.380 ↓ 0.0 0 20

Bitmap Heap Scan on taggeditem _ti (cost=4.44..12.30 rows=2 width=16) (actual time=0.019..0.019 rows=0 loops=20)

  • Recheck Cond: ((refkey = c.candidateid) AND ((reftype)::text = 'Candidate'::text))
92. 0.360 0.360 ↓ 0.0 0 20

Bitmap Index Scan on idx_taggeditem_3 (cost=0.00..4.44 rows=2 width=0) (actual time=0.018..0.018 rows=0 loops=20)

  • Index Cond: ((refkey = c.candidateid) AND ((reftype)::text = 'Candidate'::text))