explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pZnN

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 13,488.943 ↓ 0.0 0 1

Limit (cost=155,538.8..155,552.63 rows=50 width=717) (actual time=13,488.938..13,488.943 rows=0 loops=1)

  • Buffers: shared hit=5301, temp read=829 written=834
2. 0.015 13,488.930 ↓ 0.0 0 1

Merge Join (cost=155,538.8..186,748.69 rows=112,849 width=717) (actual time=13,488.925..13,488.93 rows=0 loops=1)

  • Buffers: shared hit=5301, temp read=829 written=834
3. 0.037 0.037 ↑ 225,695.0 1 1

Index Scan using application_pkey on application application (cost=0.42..28,953.34 rows=225,695 width=717) (actual time=0.031..0.037 rows=1 loops=1)

  • Buffers: shared hit=4
4. 0.022 13,488.878 ↓ 0.0 0 1

Sort (cost=155,538.38..155,820.5 rows=112,849 width=16) (actual time=13,488.873..13,488.878 rows=0 loops=1)

  • Sort Key: "*SELECT* 2".id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5297, temp read=829 written=834
5. 0.305 13,488.856 ↓ 0.0 0 1

Aggregate (cost=141,879.1..143,007.59 rows=112,849 width=16) (actual time=13,488.851..13,488.856 rows=0 loops=1)

  • Buffers: shared hit=5297, temp read=829 written=834
6. 0.013 13,488.551 ↓ 0.0 0 1

Append (cost=64,175.81..141,596.97 rows=112,849 width=16) (actual time=13,488.546..13,488.551 rows=0 loops=1)

  • Buffers: shared hit=5297, temp read=829 written=834
7. 0.013 13,475.520 ↓ 0.0 0 1

Result (cost=64,175.81..66,495.46 rows=112,848 width=16) (actual time=13,475.514..13,475.52 rows=0 loops=1)

  • Buffers: shared hit=5270, temp read=829 written=834
8. 1,383.461 13,475.507 ↓ 0.0 0 1

SetOp (cost=64,175.81..65,366.98 rows=112,848 width=20) (actual time=13,475.502..13,475.507 rows=0 loops=1)

  • Buffers: shared hit=5270, temp read=829 written=834
9. 2,843.318 12,092.046 ↑ 1.1 225,695 1

Sort (cost=64,175.81..64,771.39 rows=238,234 width=20) (actual time=10,730.625..12,092.046 rows=225,695 loops=1)

  • Sort Key: "*SELECT* 2".id
  • Sort Method: external merge Disk: 6632kB
  • Buffers: shared hit=5270, temp read=829 written=834
10. 2,582.599 9,248.728 ↑ 1.1 225,695 1

Append (cost=18.39..38,013.11 rows=238,234 width=20) (actual time=7.496..9,248.728 rows=225,695 loops=1)

  • Buffers: shared hit=5270
11. 2,617.569 6,665.731 ↓ 2.0 225,695 1

Subquery Scan on *SELECT* 2 (cost=18.39..17,557.69 rows=112,848 width=20) (actual time=7.482..6,665.731 rows=225,695 loops=1)

  • Buffers: shared hit=5260
12. 2,699.847 4,048.162 ↓ 2.0 225,695 1

Hash Join (cost=18.39..16,429.21 rows=112,848 width=16) (actual time=7.468..4,048.162 rows=225,695 loops=1)

  • Buffers: shared hit=5260
13. 1,340.899 1,340.899 ↑ 1.0 225,695 1

Seq Scan on application application_1 (cost=0..7,509.95 rows=225,695 width=32) (actual time=0.019..1,340.899 rows=225,695 loops=1)

  • Buffers: shared hit=5253
14. 3.611 7.416 ↓ 0.0 0 1

Hash (cost=12.06..12.06 rows=506 width=16) (actual time=7.411..7.416 rows=0 loops=1)

  • Buffers: shared hit=7
15. 3.805 3.805 ↑ 1.0 506 1

Seq Scan on employee employee (cost=0..12.06 rows=506 width=16) (actual time=0.035..3.805 rows=506 loops=1)

  • Filter: (NOT employee.is_alumni)
  • Buffers: shared hit=7
16. 0.011 0.398 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=18,574.63..20,455.42 rows=125,386 width=20) (actual time=0.393..0.398 rows=0 loops=1)

  • Buffers: shared hit=10
17. 0.011 0.387 ↓ 0.0 0 1

Unique (cost=18,574.63..19,201.56 rows=125,386 width=16) (actual time=0.382..0.387 rows=0 loops=1)

  • Buffers: shared hit=10
18. 0.019 0.376 ↓ 0.0 0 1

Sort (cost=18,574.63..18,888.09 rows=125,386 width=16) (actual time=0.371..0.376 rows=0 loops=1)

  • Sort Key: application_2.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10
19. 0.012 0.357 ↓ 0.0 0 1

Nested Loop (cost=2,299.78..5,811.43 rows=125,386 width=16) (actual time=0.351..0.357 rows=0 loops=1)

  • Buffers: shared hit=10
20. 0.011 0.345 ↓ 0.0 0 1

Nested Loop (cost=2,299.36..2,320.67 rows=5 width=32) (actual time=0.34..0.345 rows=0 loops=1)

  • Buffers: shared hit=10
21. 0.012 0.334 ↓ 0.0 0 1

Aggregate (cost=2,299.08..2,299.13 rows=5 width=16) (actual time=0.329..0.334 rows=0 loops=1)

  • Buffers: shared hit=10
22. 0.012 0.322 ↓ 0.0 0 1

Append (cost=0.28..2,299.06 rows=5 width=16) (actual time=0.316..0.322 rows=0 loops=1)

  • Buffers: shared hit=10
23. 0.011 0.055 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
24. 0.012 0.044 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
25. 0.032 0.032 ↓ 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.026..0.032 rows=0 loops=1)

  • Filter: (user_job_security_roles.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
26. 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
27. 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)
28. 0.011 0.158 ↓ 0.0 0 1

Nested Loop (cost=1.2..2,279.72 rows=3 width=16) (actual time=0.153..0.158 rows=0 loops=1)

  • Buffers: shared hit=5
29. 0.013 0.147 ↓ 0.0 0 1

Merge Join (cost=1.2..2,278.52 rows=3 width=32) (actual time=0.141..0.147 rows=0 loops=1)

  • Buffers: shared hit=5
30. 0.025 0.093 ↑ 27.0 1 1

Nested Loop (cost=0.14..30,743.31 rows=27 width=32) (actual time=0.088..0.093 rows=1 loops=1)

  • Buffers: shared hit=4
31. 0.019 0.019 ↑ 9.0 1 1

Index Scan using team_pkey on team team (cost=0.14..12.27 rows=9 width=86) (actual time=0.014..0.019 rows=1 loops=1)

  • Buffers: shared hit=2
32. 0.013 0.028 ↑ 3,019.0 1 1

Materialize (cost=0..103.28 rows=3,019 width=32) (actual time=0.022..0.028 rows=1 loops=1)

  • Buffers: shared hit=1
33. 0.015 0.015 ↑ 3,019.0 1 1

Seq Scan on job job_2 (cost=0..88.19 rows=3,019 width=32) (actual time=0.01..0.015 rows=1 loops=1)

  • Buffers: shared hit=1
34.          

SubPlan (for Nested Loop)

35. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on team team_5 (cost=0..1.11 rows=1 width=70) (actual time=0.009..0.021 rows=1 loops=1)

  • Filter: (team_5.id = job_2.team_id)
  • Buffers: shared hit=1
36. 0.012 0.041 ↓ 0.0 0 1

Materialize (cost=1.06..1.07 rows=1 width=32) (actual time=0.036..0.041 rows=0 loops=1)

  • Buffers: shared hit=1
37. 0.014 0.029 ↓ 0.0 0 1

Sort (cost=1.06..1.06 rows=1 width=32) (actual time=0.024..0.029 rows=0 loops=1)

  • Sort Key: user_team_security_roles.team_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
38. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: (user_team_security_roles.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
39. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..1.06 rows=4 width=16) (never executed)

40. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: security_role_1.can_see_candidates
41. 0.011 0.097 ↓ 0.0 0 1

Result (cost=0.28..12.63 rows=1 width=16) (actual time=0.092..0.097 rows=0 loops=1)

  • Buffers: shared hit=4
42. 0.011 0.086 ↓ 0.0 0 1

SetOp (cost=0.28..12.62 rows=1 width=20) (actual time=0.081..0.086 rows=0 loops=1)

  • Buffers: shared hit=4
43. 0.012 0.075 ↓ 0.0 0 1

Append (cost=0.28..12.61 rows=2 width=20) (actual time=0.069..0.075 rows=0 loops=1)

  • Buffers: shared hit=4
44. 0.011 0.029 ↓ 0.0 0 1

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

  • Buffers: shared hit=2
45. 0.018 0.018 ↓ 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.012..0.018 rows=0 loops=1)

  • Index Cond: (job_3.confidential = true)
  • Filter: job_3.confidential
  • Buffers: shared hit=2
46. 0.011 0.034 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_1 (cost=0.28..8.31 rows=1 width=20) (actual time=0.029..0.034 rows=0 loops=1)

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

Index Scan using job_author_id_idx on job job_4 (cost=0.28..8.3 rows=1 width=16) (actual time=0.017..0.023 rows=0 loops=1)

  • Index Cond: (job_4.author_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=2
48. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (job.id = job_1.id)
49. 0.000 0.000 ↓ 0.0 0 0

Index Scan using application_job_id_idx on application application_2 (cost=0.42..447.38 rows=25,077 width=32) (never executed)

  • Index Cond: (application_2.job_id = job.id)
50. 0.011 13.018 ↓ 0.0 0 1

Result (cost=0.42..75,101.51 rows=1 width=16) (actual time=13.012..13.018 rows=0 loops=1)

  • Buffers: shared hit=27
51. 0.012 13.007 ↓ 0.0 0 1

SetOp (cost=0.42..75,101.5 rows=1 width=20) (actual time=13.001..13.007 rows=0 loops=1)

  • Buffers: shared hit=27
52. 0.012 12.995 ↓ 0.0 0 1

Append (cost=0.42..74,788.04 rows=125,387 width=20) (actual time=12.99..12.995 rows=0 loops=1)

  • Buffers: shared hit=27
53. 0.011 12.126 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=0.42..3,735.32 rows=1 width=20) (actual time=12.121..12.126 rows=0 loops=1)

  • Buffers: shared hit=7
54. 5.991 12.115 ↓ 0.0 0 1

Nested Loop (cost=0.42..3,735.31 rows=1 width=16) (actual time=12.11..12.115 rows=0 loops=1)

  • Buffers: shared hit=7
55. 3.094 3.094 ↑ 1.0 505 1

Seq Scan on employee employee_1 (cost=0..13.32 rows=505 width=16) (actual time=0.026..3.094 rows=505 loops=1)

  • Filter: ((NOT employee_1.is_alumni) AND (employee_1.user_id IS DISTINCT FROM '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid))
  • Buffers: shared hit=7
56. 3.030 3.030 ↓ 0.0 0 505

Index Scan using application_candidate_id_idx on application application_3 (cost=0.42..7.36 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=505)

  • Index Cond: (application_3.candidate_id = employee_1.candidate_id)
57. 0.011 0.857 ↓ 0.0 0 1

Result (cost=68,544.99..71,052.71 rows=125,386 width=20) (actual time=0.852..0.857 rows=0 loops=1)

  • Buffers: shared hit=20
58. 0.011 0.846 ↓ 0.0 0 1

SetOp (cost=68,544.99..69,798.85 rows=125,386 width=20) (actual time=0.84..0.846 rows=0 loops=1)

  • Buffers: shared hit=20
59. 0.019 0.835 ↓ 0.0 0 1

Sort (cost=68,544.99..69,171.92 rows=250,772 width=20) (actual time=0.829..0.835 rows=0 loops=1)

  • Sort Key: "*SELECT* 3".id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=20
60. 0.011 0.816 ↓ 0.0 0 1

Append (cost=18,574.63..40,910.74 rows=250,772 width=20) (actual time=0.811..0.816 rows=0 loops=1)

  • Buffers: shared hit=20
61. 0.011 0.367 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=18,574.63..20,455.42 rows=125,386 width=20) (actual time=0.362..0.367 rows=0 loops=1)

  • Buffers: shared hit=10
62. 0.011 0.356 ↓ 0.0 0 1

Unique (cost=18,574.63..19,201.56 rows=125,386 width=16) (actual time=0.351..0.356 rows=0 loops=1)

  • Buffers: shared hit=10
63. 0.013 0.345 ↓ 0.0 0 1

Sort (cost=18,574.63..18,888.09 rows=125,386 width=16) (actual time=0.34..0.345 rows=0 loops=1)

  • Sort Key: application_4.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10
64. 0.009 0.332 ↓ 0.0 0 1

Nested Loop (cost=2,299.78..5,811.43 rows=125,386 width=16) (actual time=0.327..0.332 rows=0 loops=1)

  • Buffers: shared hit=10
65. 0.013 0.323 ↓ 0.0 0 1

Nested Loop (cost=2,299.36..2,320.67 rows=5 width=32) (actual time=0.316..0.323 rows=0 loops=1)

  • Buffers: shared hit=10
66. 0.012 0.310 ↓ 0.0 0 1

Aggregate (cost=2,299.08..2,299.13 rows=5 width=16) (actual time=0.304..0.31 rows=0 loops=1)

  • Buffers: shared hit=10
67. 0.012 0.298 ↓ 0.0 0 1

Append (cost=0.28..2,299.06 rows=5 width=16) (actual time=0.292..0.298 rows=0 loops=1)

  • Buffers: shared hit=10
68. 0.011 0.040 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
69. 0.012 0.029 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
70. 0.017 0.017 ↓ 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.012..0.017 rows=0 loops=1)

  • Filter: (user_job_security_roles_1.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
71. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: security_role_2.can_see_candidates
72. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (job_6.id = user_job_security_roles_1.job_id)
73. 0.011 0.157 ↓ 0.0 0 1

Nested Loop (cost=1.2..2,279.72 rows=3 width=16) (actual time=0.152..0.157 rows=0 loops=1)

  • Buffers: shared hit=5
74. 0.013 0.146 ↓ 0.0 0 1

Merge Join (cost=1.2..2,278.52 rows=3 width=32) (actual time=0.141..0.146 rows=0 loops=1)

  • Buffers: shared hit=5
75. 0.023 0.092 ↑ 27.0 1 1

Nested Loop (cost=0.14..30,743.31 rows=27 width=32) (actual time=0.087..0.092 rows=1 loops=1)

  • Buffers: shared hit=4
76. 0.017 0.017 ↑ 9.0 1 1

Index Scan using team_pkey on team team_1 (cost=0.14..12.27 rows=9 width=86) (actual time=0.012..0.017 rows=1 loops=1)

  • Buffers: shared hit=2
77. 0.016 0.031 ↑ 3,019.0 1 1

Materialize (cost=0..103.28 rows=3,019 width=32) (actual time=0.026..0.031 rows=1 loops=1)

  • Buffers: shared hit=1
78. 0.015 0.015 ↑ 3,019.0 1 1

Seq Scan on job job_7 (cost=0..88.19 rows=3,019 width=32) (actual time=0.009..0.015 rows=1 loops=1)

  • Buffers: shared hit=1
79.          

SubPlan (for Nested Loop)

80. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on team team_3 (cost=0..1.11 rows=1 width=70) (actual time=0.009..0.021 rows=1 loops=1)

  • Filter: (team_3.id = job_7.team_id)
  • Buffers: shared hit=1
81. 0.011 0.041 ↓ 0.0 0 1

Materialize (cost=1.06..1.07 rows=1 width=32) (actual time=0.036..0.041 rows=0 loops=1)

  • Buffers: shared hit=1
82. 0.014 0.030 ↓ 0.0 0 1

Sort (cost=1.06..1.06 rows=1 width=32) (actual time=0.024..0.03 rows=0 loops=1)

  • Sort Key: user_team_security_roles_1.team_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
83. 0.016 0.016 ↓ 0.0 0 1

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

  • Filter: (user_team_security_roles_1.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
84. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..1.06 rows=4 width=16) (never executed)

85. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: security_role_3.can_see_candidates
86. 0.011 0.089 ↓ 0.0 0 1

Result (cost=0.28..12.63 rows=1 width=16) (actual time=0.084..0.089 rows=0 loops=1)

  • Buffers: shared hit=4
87. 0.011 0.078 ↓ 0.0 0 1

SetOp (cost=0.28..12.62 rows=1 width=20) (actual time=0.073..0.078 rows=0 loops=1)

  • Buffers: shared hit=4
88. 0.012 0.067 ↓ 0.0 0 1

Append (cost=0.28..12.61 rows=2 width=20) (actual time=0.061..0.067 rows=0 loops=1)

  • Buffers: shared hit=4
89. 0.011 0.028 ↓ 0.0 0 1

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

  • Buffers: shared hit=2
90. 0.017 0.017 ↓ 0.0 0 1

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

  • Index Cond: (job_8.confidential = true)
  • Filter: job_8.confidential
  • Buffers: shared hit=2
91. 0.011 0.027 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_2 (cost=0.28..8.31 rows=1 width=20) (actual time=0.022..0.027 rows=0 loops=1)

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

Index Scan using job_author_id_idx on job job_9 (cost=0.28..8.3 rows=1 width=16) (actual time=0.01..0.016 rows=0 loops=1)

  • Index Cond: (job_9.author_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=2
93. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (job_5.id = job_6.id)
94. 0.000 0.000 ↓ 0.0 0 0

Index Scan using application_job_id_idx on application application_4 (cost=0.42..447.38 rows=25,077 width=32) (never executed)

  • Index Cond: (application_4.job_id = job_5.id)
95. 0.011 0.438 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=18,574.53..20,455.32 rows=125,386 width=20) (actual time=0.432..0.438 rows=0 loops=1)

  • Buffers: shared hit=10
96. 0.012 0.427 ↓ 0.0 0 1

Unique (cost=18,574.53..19,201.46 rows=125,386 width=16) (actual time=0.421..0.427 rows=0 loops=1)

  • Buffers: shared hit=10
97. 0.018 0.415 ↓ 0.0 0 1

Sort (cost=18,574.53..18,888 rows=125,386 width=16) (actual time=0.41..0.415 rows=0 loops=1)

  • Sort Key: application_5.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10
98. 0.011 0.397 ↓ 0.0 0 1

Nested Loop (cost=2,299.68..5,811.34 rows=125,386 width=16) (actual time=0.392..0.397 rows=0 loops=1)

  • Buffers: shared hit=10
99. 0.011 0.386 ↓ 0.0 0 1

Nested Loop (cost=2,299.26..2,320.57 rows=5 width=32) (actual time=0.381..0.386 rows=0 loops=1)

  • Buffers: shared hit=10
100. 0.012 0.375 ↓ 0.0 0 1

Aggregate (cost=2,298.98..2,299.03 rows=5 width=16) (actual time=0.369..0.375 rows=0 loops=1)

  • Buffers: shared hit=10
101. 0.012 0.363 ↓ 0.0 0 1

Append (cost=0.28..2,298.97 rows=5 width=16) (actual time=0.358..0.363 rows=0 loops=1)

  • Buffers: shared hit=10
102. 0.012 0.125 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
103. 0.095 0.113 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
104. 0.018 0.018 ↓ 0.0 0 1

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

  • Filter: (user_job_security_roles_2.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
105. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: security_role_4.can_see_and_edit_hired_candidates
106. 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)
107. 0.011 0.143 ↓ 0.0 0 1

Nested Loop (cost=1.2..2,279.65 rows=3 width=16) (actual time=0.138..0.143 rows=0 loops=1)

  • Buffers: shared hit=5
108. 0.012 0.132 ↓ 0.0 0 1

Merge Join (cost=1.2..2,278.52 rows=3 width=32) (actual time=0.127..0.132 rows=0 loops=1)

  • Buffers: shared hit=5
109. 0.022 0.081 ↑ 27.0 1 1

Nested Loop (cost=0.14..30,743.31 rows=27 width=32) (actual time=0.075..0.081 rows=1 loops=1)

  • Buffers: shared hit=4
110. 0.014 0.014 ↑ 9.0 1 1

Index Scan using team_pkey on team team_2 (cost=0.14..12.27 rows=9 width=86) (actual time=0.008..0.014 rows=1 loops=1)

  • Buffers: shared hit=2
111. 0.012 0.025 ↑ 3,019.0 1 1

Materialize (cost=0..103.28 rows=3,019 width=32) (actual time=0.02..0.025 rows=1 loops=1)

  • Buffers: shared hit=1
112. 0.013 0.013 ↑ 3,019.0 1 1

Seq Scan on job job_12 (cost=0..88.19 rows=3,019 width=32) (actual time=0.008..0.013 rows=1 loops=1)

  • Buffers: shared hit=1
113.          

SubPlan (for Nested Loop)

114. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on team team_4 (cost=0..1.11 rows=1 width=70) (actual time=0.008..0.02 rows=1 loops=1)

  • Filter: (team_4.id = job_12.team_id)
  • Buffers: shared hit=1
115. 0.012 0.039 ↓ 0.0 0 1

Materialize (cost=1.06..1.07 rows=1 width=32) (actual time=0.034..0.039 rows=0 loops=1)

  • Buffers: shared hit=1
116. 0.013 0.027 ↓ 0.0 0 1

Sort (cost=1.06..1.06 rows=1 width=32) (actual time=0.022..0.027 rows=0 loops=1)

  • Sort Key: user_team_security_roles_2.team_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
117. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on user_team_security_roles user_team_security_roles_2 (cost=0..1.05 rows=1 width=32) (actual time=0.009..0.014 rows=0 loops=1)

  • Filter: (user_team_security_roles_2.user_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=1
118. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..1.05 rows=2 width=16) (never executed)

119. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: security_role_5.can_see_and_edit_hired_candidates
120. 0.010 0.083 ↓ 0.0 0 1

Result (cost=0.28..12.63 rows=1 width=16) (actual time=0.078..0.083 rows=0 loops=1)

  • Buffers: shared hit=4
121. 0.012 0.073 ↓ 0.0 0 1

SetOp (cost=0.28..12.62 rows=1 width=20) (actual time=0.067..0.073 rows=0 loops=1)

  • Buffers: shared hit=4
122. 0.011 0.061 ↓ 0.0 0 1

Append (cost=0.28..12.61 rows=2 width=20) (actual time=0.056..0.061 rows=0 loops=1)

  • Buffers: shared hit=4
123. 0.011 0.025 ↓ 0.0 0 1

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

  • Buffers: shared hit=2
124. 0.014 0.014 ↓ 0.0 0 1

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

  • Index Cond: (job_13.confidential = true)
  • Filter: job_13.confidential
  • Buffers: shared hit=2
125. 0.011 0.025 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_3 (cost=0.28..8.31 rows=1 width=20) (actual time=0.019..0.025 rows=0 loops=1)

  • Buffers: shared hit=2
126. 0.014 0.014 ↓ 0.0 0 1

Index Scan using job_author_id_idx on job job_14 (cost=0.28..8.3 rows=1 width=16) (actual time=0.008..0.014 rows=0 loops=1)

  • Index Cond: (job_14.author_id = '0f568568-d909-4f86-a3c2-1f5fdf19de92'::uuid)
  • Buffers: shared hit=2
127. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (job_10.id = job_11.id)
128. 0.000 0.000 ↓ 0.0 0 0

Index Scan using application_job_id_idx on application application_5 (cost=0.42..447.38 rows=25,077 width=32) (never executed)

  • Index Cond: (application_5.job_id = job_10.id)
Planning time : 4.07 ms
Execution time : 13,493.304 ms