explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xxdT

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 17.791 ↑ 1.0 1 1

Nested Loop (cost=10,824.79..10,840.93 rows=1 width=630) (actual time=17.788..17.791 rows=1 loops=1)

  • Buffers: shared hit=3266
2. 0.002 0.149 ↑ 1.0 1 1

Nested Loop (cost=1.26..17.33 rows=1 width=646) (actual time=0.147..0.149 rows=1 loops=1)

  • Buffers: shared hit=12
3. 0.005 0.136 ↑ 1.0 1 1

Nested Loop (cost=0.84..12.88 rows=1 width=646) (actual time=0.134..0.136 rows=1 loops=1)

  • Buffers: shared hit=8
4. 0.086 0.086 ↑ 1.0 1 1

Index Only Scan using published_candidate_pkey on published_candidate published_candidate (cost=0.42..4.44 rows=1 width=16) (actual time=0.086..0.086 rows=1 loops=1)

  • Index Cond: (published_candidate.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
5. 0.045 0.045 ↑ 1.0 1 1

Index Scan using candidate_data_pkey on candidate_data candidate_data (cost=0.42..8.44 rows=1 width=630) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (candidate_data.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
6. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using published_candidate_pkey on published_candidate published_candidate_1 (cost=0.42..4.44 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (published_candidate_1.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
7. 0.006 17.635 ↑ 3.0 1 1

Aggregate (cost=10,823.53..10,823.56 rows=3 width=16) (actual time=17.635..17.635 rows=1 loops=1)

  • Buffers: shared hit=3254
8. 0.002 17.629 ↑ 3.0 1 1

Append (cost=1.26..10,823.52 rows=3 width=16) (actual time=16.835..17.629 rows=1 loops=1)

  • Buffers: shared hit=3254
9. 0.002 0.083 ↓ 0.0 0 1

Nested Loop (cost=1.26..17.34 rows=1 width=16) (actual time=0.083..0.083 rows=0 loops=1)

  • Buffers: shared hit=12
10. 0.002 0.051 ↑ 1.0 1 1

Nested Loop (cost=0.84..8.88 rows=1 width=32) (actual time=0.049..0.051 rows=1 loops=1)

  • Buffers: shared hit=8
11. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using published_candidate_pkey on published_candidate published_candidate_2 (cost=0.42..4.44 rows=1 width=16) (actual time=0.01..0.01 rows=1 loops=1)

  • Index Cond: (published_candidate_2.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
12. 0.039 0.039 ↑ 1.0 1 1

Index Only Scan using candidate_data_pkey on candidate_data candidate_data_1 (cost=0.42..4.44 rows=1 width=16) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (candidate_data_1.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
13. 0.030 0.030 ↑ 1.0 1 1

Index Only Scan using application_candidate_id_idx on application application (cost=0.42..8.44 rows=1 width=16) (actual time=0.03..0.03 rows=1 loops=1)

  • Index Cond: (application.candidate_id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
14. 0.002 16.755 ↑ 1.0 1 1

Unique (cost=3,586.15..3,610.49 rows=1 width=16) (actual time=16.751..16.755 rows=1 loops=1)

  • Buffers: shared hit=3158
15. 0.002 16.753 ↑ 1.0 1 1

Nested Loop (cost=3,586.15..3,610.49 rows=1 width=16) (actual time=16.749..16.753 rows=1 loops=1)

  • Buffers: shared hit=3158
16. 0.003 16.737 ↑ 1.0 1 1

Nested Loop (cost=3,585.73..3,606.04 rows=1 width=32) (actual time=16.734..16.737 rows=1 loops=1)

  • Buffers: shared hit=3154
17. 0.003 16.717 ↑ 1.0 1 1

Nested Loop (cost=3,585.31..3,601.59 rows=1 width=16) (actual time=16.715..16.717 rows=1 loops=1)

  • Buffers: shared hit=3150
18. 0.016 0.016 ↑ 1.0 1 1

Index Scan using application_candidate_id_idx on application application_1 (cost=0.42..8.44 rows=1 width=32) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (application_1.candidate_id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
19. 0.003 16.698 ↑ 1.0 1 1

Nested Loop (cost=3,584.89..3,593.14 rows=1 width=48) (actual time=16.698..16.698 rows=1 loops=1)

  • Buffers: shared hit=3146
20. 0.002 0.049 ↑ 1.0 1 1

Nested Loop (cost=0.84..8.93 rows=1 width=32) (actual time=0.049..0.049 rows=1 loops=1)

  • Buffers: shared hit=8
21. 0.036 0.036 ↑ 1.0 1 1

Index Scan using application_pkey on application application_4 (cost=0.42..8.44 rows=1 width=16) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: (application_4.id = application_1.id)
  • Filter: (COALESCE(((application_4.status)::text <> 'hired'::text), true) AND (application_4.organization_id = 'ec647f56-f27a-49a1-84af-021ad0a19f21'::uuid))
  • Buffers: shared hit=4
22. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using application_pkey on application application_2 (cost=0.42..0.48 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (application_2.id = application_4.id)
  • Buffers: shared hit=4
23. 0.004 16.646 ↑ 1.0 1 1

Nested Loop (cost=3,584.05..3,584.2 rows=1 width=16) (actual time=16.646..16.646 rows=1 loops=1)

  • Buffers: shared hit=3138
24. 0.087 16.563 ↑ 1.0 1 1

Hash Join (cost=3,583.77..3,583.9 rows=1 width=48) (actual time=16.563..16.563 rows=1 loops=1)

  • Buffers: shared hit=3135
25. 0.902 16.434 ↓ 59.2 296 1

Aggregate (cost=3,583.21..3,583.26 rows=5 width=16) (actual time=16.356..16.434 rows=296 loops=1)

  • Buffers: shared hit=3131
26. 0.224 15.532 ↓ 195.8 979 1

Append (cost=0.28..3,583.2 rows=5 width=16) (actual time=0.112..15.532 rows=979 loops=1)

  • Buffers: shared hit=3131
27. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.28..6.68 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=1)

  • Buffers: shared hit=1
28. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=0..2.38 rows=1 width=16) (actual time=0.016..0.017 rows=0 loops=1)

  • Buffers: shared hit=1
29. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on user_job_security_roles user_job_security_roles (cost=0..1.29 rows=1 width=32) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (user_job_security_roles.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=1
30. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on security_role security_role (cost=0..1.04 rows=4 width=16) (never executed)

  • Filter: security_role.can_see_candidates
31. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using job_pkey on job job_1 (cost=0.28..4.3 rows=1 width=16) (never executed)

  • Index Cond: (job_1.id = user_job_security_roles.job_id)
32. 7.862 14.590 ↓ 326.3 979 1

Nested Loop (cost=1.06..3,476.5 rows=3 width=16) (actual time=0.094..14.59 rows=979 loops=1)

  • Buffers: shared hit=3070
33. 0.003 0.069 ↑ 1.0 1 1

Nested Loop (cost=1.06..3.29 rows=1 width=70) (actual time=0.062..0.069 rows=1 loops=1)

  • Buffers: shared hit=3
34. 0.023 0.054 ↑ 1.0 1 1

Hash Join (cost=1.06..2.2 rows=1 width=86) (actual time=0.047..0.054 rows=1 loops=1)

  • Buffers: shared hit=2
35. 0.008 0.008 ↑ 1.0 9 1

Seq Scan on team team (cost=0..1.09 rows=9 width=86) (actual time=0.007..0.008 rows=9 loops=1)

  • Buffers: shared hit=1
36. 0.004 0.023 ↑ 1.0 1 1

Hash (cost=1.05..1.05 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=1)

  • Buffers: shared hit=1
37. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on user_team_security_roles user_team_security_roles (cost=0..1.05 rows=1 width=32) (actual time=0.018..0.019 rows=1 loops=1)

  • Filter: (user_team_security_roles.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=1
38. 0.012 0.012 ↑ 1.3 3 1

Seq Scan on security_role security_role_1 (cost=0..1.04 rows=4 width=16) (actual time=0.011..0.012 rows=3 loops=1)

  • Filter: security_role_1.can_see_candidates
  • Buffers: shared hit=1
39. 0.641 0.641 ↑ 1.0 3,009 1

Seq Scan on job job_2 (cost=0..88.09 rows=3,009 width=32) (actual time=0.007..0.641 rows=3,009 loops=1)

  • Buffers: shared hit=58
40.          

SubPlan (for Nested Loop)

41. 6.018 6.018 ↑ 1.0 1 3,009

Seq Scan on team team_3 (cost=0..1.11 rows=1 width=70) (actual time=0.002..0.002 rows=1 loops=3,009)

  • Filter: (team_3.id = job_2.team_id)
  • Buffers: shared hit=3009
42. 0.001 0.701 ↓ 0.0 0 1

Result (cost=0.28..99.96 rows=1 width=16) (actual time=0.701..0.701 rows=0 loops=1)

  • Buffers: shared hit=60
43. 0.001 0.700 ↓ 0.0 0 1

SetOp (cost=0.28..99.95 rows=1 width=20) (actual time=0.7..0.7 rows=0 loops=1)

  • Buffers: shared hit=60
44. 0.001 0.699 ↓ 0.0 0 1

Append (cost=0.28..99.94 rows=2 width=20) (actual time=0.699..0.699 rows=0 loops=1)

  • Buffers: shared hit=60
45. 0.001 0.024 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=0.28..4.31 rows=1 width=20) (actual time=0.024..0.024 rows=0 loops=1)

  • Buffers: shared hit=2
46. 0.023 0.023 ↓ 0.0 0 1

Index Scan using job_confidential_idx on job job_3 (cost=0.28..4.3 rows=1 width=16) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (job_3.confidential = true)
  • Filter: job_3.confidential
  • Buffers: shared hit=2
47. 0.001 0.674 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0..95.62 rows=1 width=20) (actual time=0.674..0.674 rows=0 loops=1)

  • Buffers: shared hit=58
48. 0.673 0.673 ↓ 0.0 0 1

Seq Scan on job job_4 (cost=0..95.61 rows=1 width=16) (actual time=0.673..0.673 rows=0 loops=1)

  • Filter: (job_4.author_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=58
49. 0.030 0.042 ↑ 1.0 1 1

Hash (cost=0.55..0.55 rows=1 width=32) (actual time=0.042..0.042 rows=1 loops=1)

  • Buffers: shared hit=4
50. 0.012 0.012 ↑ 1.0 1 1

Index Scan using application_pkey on application application_3 (cost=0.42..0.55 rows=1 width=32) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (application_3.id = application_2.id)
  • Buffers: shared hit=4
51. 0.079 0.079 ↑ 1.0 1 1

Index Only Scan using job_pkey on job job (cost=0.28..0.3 rows=1 width=16) (actual time=0.079..0.079 rows=1 loops=1)

  • Index Cond: (job.id = application_3.job_id)
  • Buffers: shared hit=3
52. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using published_candidate_pkey on published_candidate published_candidate_3 (cost=0.42..4.44 rows=1 width=16) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (published_candidate_3.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
53. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using candidate_data_pkey on candidate_data candidate_data_2 (cost=0.42..4.44 rows=1 width=16) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (candidate_data_2.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
54. 0.000 0.789 ↓ 0.0 0 1

Nested Loop (cost=7,171..7,195.65 rows=1 width=16) (actual time=0.789..0.789 rows=0 loops=1)

  • Buffers: shared hit=84
55. 0.001 0.789 ↓ 0.0 0 1

Nested Loop (cost=7,170.58..7,191.2 rows=1 width=32) (actual time=0.789..0.789 rows=0 loops=1)

  • Buffers: shared hit=84
56. 0.003 0.788 ↓ 0.0 0 1

Nested Loop (cost=7,170.16..7,186.76 rows=1 width=16) (actual time=0.788..0.788 rows=0 loops=1)

  • Buffers: shared hit=84
57. 0.016 0.016 ↑ 1.0 1 1

Index Scan using application_candidate_id_idx on application application_5 (cost=0.42..8.44 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (application_5.candidate_id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
  • Buffers: shared hit=4
58. 0.003 0.769 ↓ 0.0 0 1

Nested Loop (cost=7,169.74..7,178.31 rows=1 width=96) (actual time=0.769..0.769 rows=0 loops=1)

  • Buffers: shared hit=80
59. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using application_pkey on application application_6 (cost=0.42..8.44 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (application_6.id = application_5.id)
  • Buffers: shared hit=4
60. 0.004 0.752 ↓ 0.0 0 1

Nested Loop (cost=7,169.32..7,169.86 rows=1 width=80) (actual time=0.752..0.752 rows=0 loops=1)

  • Buffers: shared hit=76
61. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using application_pkey on application application_7 (cost=0.42..0.46 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (application_7.id = application_6.id)
  • Buffers: shared hit=4
62. 0.001 0.739 ↓ 0.0 0 1

Nested Loop (cost=7,168.9..7,169.39 rows=1 width=64) (actual time=0.739..0.739 rows=0 loops=1)

  • Buffers: shared hit=72
63. 0.001 0.738 ↓ 0.0 0 1

Nested Loop (cost=7,168.48..7,168.83 rows=1 width=48) (actual time=0.738..0.738 rows=0 loops=1)

  • Buffers: shared hit=72
64. 0.004 0.737 ↓ 0.0 0 1

Nested Loop (cost=3,584.42..3,584.62 rows=1 width=32) (actual time=0.737..0.737 rows=0 loops=1)

  • Buffers: shared hit=72
65. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using application_pkey on application application_8 (cost=0.42..0.46 rows=1 width=16) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (application_8.id = application_7.id)
  • Buffers: shared hit=4
66. 0.001 0.724 ↓ 0.0 0 1

Nested Loop (cost=3,584..3,584.15 rows=1 width=16) (actual time=0.724..0.724 rows=0 loops=1)

  • Buffers: shared hit=68
67. 0.028 0.723 ↓ 0.0 0 1

Hash Join (cost=3,583.72..3,583.85 rows=1 width=48) (actual time=0.723..0.723 rows=0 loops=1)

  • Buffers: shared hit=68
68. 0.001 0.680 ↓ 0.0 0 1

Aggregate (cost=3,583.16..3,583.21 rows=5 width=16) (actual time=0.68..0.68 rows=0 loops=1)

  • Buffers: shared hit=64
69. 0.002 0.679 ↓ 0.0 0 1

Append (cost=0.28..3,583.15 rows=5 width=16) (actual time=0.679..0.679 rows=0 loops=1)

  • Buffers: shared hit=64
70. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.28..6.65 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
71. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0..2.35 rows=1 width=16) (actual time=0.01..0.01 rows=0 loops=1)

  • Buffers: shared hit=1
72. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on user_job_security_roles user_job_security_roles_1 (cost=0..1.29 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (user_job_security_roles_1.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=1
73. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on security_role security_role_2 (cost=0..1.04 rows=2 width=16) (never executed)

  • Filter: security_role_2.can_see_and_edit_hired_candidates
74. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using job_pkey on job job_7 (cost=0.28..4.3 rows=1 width=16) (never executed)

  • Index Cond: (job_7.id = user_job_security_roles_1.job_id)
75. 0.001 0.045 ↓ 0.0 0 1

Nested Loop (cost=1.06..3,476.48 rows=3 width=16) (actual time=0.045..0.045 rows=0 loops=1)

  • Buffers: shared hit=3
76. 0.003 0.044 ↓ 0.0 0 1

Nested Loop (cost=1.06..3.26 rows=1 width=70) (actual time=0.044..0.044 rows=0 loops=1)

  • Buffers: shared hit=3
77. 0.021 0.035 ↑ 1.0 1 1

Hash Join (cost=1.06..2.2 rows=1 width=86) (actual time=0.031..0.035 rows=1 loops=1)

  • Buffers: shared hit=2
78. 0.004 0.004 ↑ 1.0 9 1

Seq Scan on team team_1 (cost=0..1.09 rows=9 width=86) (actual time=0.003..0.004 rows=9 loops=1)

  • Buffers: shared hit=1
79. 0.004 0.010 ↑ 1.0 1 1

Hash (cost=1.05..1.05 rows=1 width=32) (actual time=0.01..0.01 rows=1 loops=1)

  • Buffers: shared hit=1
80. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on user_team_security_roles user_team_security_roles_1 (cost=0..1.05 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: (user_team_security_roles_1.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=1
81. 0.006 0.006 ↑ 1.0 2 1

Seq Scan on security_role security_role_3 (cost=0..1.04 rows=2 width=16) (actual time=0.005..0.006 rows=2 loops=1)

  • Filter: security_role_3.can_see_and_edit_hired_candidates
  • Buffers: shared hit=1
82. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on job job_8 (cost=0..88.09 rows=3,009 width=32) (never executed)

83.          

SubPlan (for Nested Loop)

84. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on team team_5 (cost=0..1.11 rows=1 width=70) (never executed)

  • Filter: (team_5.id = job_8.team_id)
85. 0.001 0.621 ↓ 0.0 0 1

Result (cost=0.28..99.96 rows=1 width=16) (actual time=0.621..0.621 rows=0 loops=1)

  • Buffers: shared hit=60
86. 0.000 0.620 ↓ 0.0 0 1

SetOp (cost=0.28..99.95 rows=1 width=20) (actual time=0.62..0.62 rows=0 loops=1)

  • Buffers: shared hit=60
87. 0.001 0.620 ↓ 0.0 0 1

Append (cost=0.28..99.94 rows=2 width=20) (actual time=0.62..0.62 rows=0 loops=1)

  • Buffers: shared hit=60
88. 0.001 0.009 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3_1 (cost=0.28..4.31 rows=1 width=20) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=2
89. 0.008 0.008 ↓ 0.0 0 1

Index Scan using job_confidential_idx on job job_9 (cost=0.28..4.3 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (job_9.confidential = true)
  • Filter: job_9.confidential
  • Buffers: shared hit=2
90. 0.001 0.610 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_1 (cost=0..95.62 rows=1 width=20) (actual time=0.61..0.61 rows=0 loops=1)

  • Buffers: shared hit=58
91. 0.609 0.609 ↓ 0.0 0 1

Seq Scan on job job_10 (cost=0..95.61 rows=1 width=16) (actual time=0.609..0.609 rows=0 loops=1)

  • Filter: (job_10.author_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
  • Buffers: shared hit=58
92. 0.005 0.015 ↑ 1.0 1 1

Hash (cost=0.55..0.55 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=1)

  • Buffers: shared hit=4
93. 0.010 0.010 ↑ 1.0 1 1

Index Scan using application_pkey on application application_10 (cost=0.42..0.55 rows=1 width=32) (actual time=0.009..0.01 rows=1 loops=1)

  • Index Cond: (application_10.id = application_8.id)
  • Buffers: shared hit=4
94. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using job_pkey on job job_6 (cost=0.28..0.3 rows=1 width=16) (never executed)

  • Index Cond: (job_6.id = application_10.job_id)
95. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=3,584.05..3,584.2 rows=1 width=16) (never executed)

96. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=3,583.77..3,583.9 rows=1 width=48) (never executed)

97. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=3,583.21..3,583.26 rows=5 width=16) (never executed)

98. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.28..3,583.2 rows=5 width=16) (never executed)

99. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..6.68 rows=1 width=16) (never executed)

100. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0..2.38 rows=1 width=16) (never executed)

101. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on user_job_security_roles user_job_security_roles_2 (cost=0..1.29 rows=1 width=32) (never executed)

  • Filter: (user_job_security_roles_2.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
102. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on security_role security_role_4 (cost=0..1.04 rows=4 width=16) (never executed)

  • Filter: security_role_4.can_see_candidates
103. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using job_pkey on job job_11 (cost=0.28..4.3 rows=1 width=16) (never executed)

  • Index Cond: (job_11.id = user_job_security_roles_2.job_id)
104. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.06..3,476.5 rows=3 width=16) (never executed)

105. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.06..3.29 rows=1 width=70) (never executed)

106. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=1.06..2.2 rows=1 width=86) (never executed)

107. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on team team_2 (cost=0..1.09 rows=9 width=86) (never executed)

108. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=1.05..1.05 rows=1 width=32) (never executed)

109. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on user_team_security_roles user_team_security_roles_2 (cost=0..1.05 rows=1 width=32) (never executed)

  • Filter: (user_team_security_roles_2.user_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
110. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on security_role security_role_5 (cost=0..1.04 rows=4 width=16) (never executed)

  • Filter: security_role_5.can_see_candidates
111. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on job job_12 (cost=0..88.09 rows=3,009 width=32) (never executed)

112.          

SubPlan (for Nested Loop)

113. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on team team_4 (cost=0..1.11 rows=1 width=70) (never executed)

  • Filter: (team_4.id = job_12.team_id)
114. 0.000 0.000 ↓ 0.0 0 0

Result (cost=0.28..99.96 rows=1 width=16) (never executed)

115. 0.000 0.000 ↓ 0.0 0 0

SetOp (cost=0.28..99.95 rows=1 width=20) (never executed)

116. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.28..99.94 rows=2 width=20) (never executed)

117. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 3_2 (cost=0.28..4.31 rows=1 width=20) (never executed)

118. 0.000 0.000 ↓ 0.0 0 0

Index Scan using job_confidential_idx on job job_13 (cost=0.28..4.3 rows=1 width=16) (never executed)

  • Index Cond: (job_13.confidential = true)
  • Filter: job_13.confidential
119. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 4_2 (cost=0..95.62 rows=1 width=20) (never executed)

120. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on job job_14 (cost=0..95.61 rows=1 width=16) (never executed)

  • Filter: (job_14.author_id = '348e57a2-a11e-4e03-8a83-4c60015e3e10'::uuid)
121. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=0.55..0.55 rows=1 width=32) (never executed)

122. 0.000 0.000 ↓ 0.0 0 0

Index Scan using application_pkey on application application_9 (cost=0.42..0.55 rows=1 width=32) (never executed)

  • Index Cond: (application_9.id = application_8.id)
123. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using job_pkey on job job_5 (cost=0.28..0.3 rows=1 width=16) (never executed)

  • Index Cond: (job_5.id = application_9.job_id)
124. 0.000 0.000 ↓ 0.0 0 0

Index Scan using application_pkey on application application_11 (cost=0.42..0.56 rows=1 width=16) (never executed)

  • Index Cond: (application_11.id = application_8.id)
  • Filter: (COALESCE(((application_11.status)::text <> 'hired'::text), true) AND (application_11.organization_id = 'ec647f56-f27a-49a1-84af-021ad0a19f21'::uuid))
125. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using published_candidate_pkey on published_candidate published_candidate_4 (cost=0.42..4.44 rows=1 width=16) (never executed)

  • Index Cond: (published_candidate_4.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
126. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using candidate_data_pkey on candidate_data candidate_data_3 (cost=0.42..4.44 rows=1 width=16) (never executed)

  • Index Cond: (candidate_data_3.id = '000130da-d2aa-4977-979e-c4dbdff5fcf8'::uuid)
Planning time : 18.517 ms
Execution time : 19.054 ms