explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bayx

Settings
# exclusive inclusive rows x rows loops node
1. 8.843 272.310 ↑ 30.0 694 1

Hash Join (cost=636.56..1,107.97 rows=20,821 width=16) (actual time=259.082..272.31 rows=694 loops=1)

  • Buffers: shared hit=65
2. 45.808 252.126 ↑ 30.0 694 1

Aggregate (cost=599.95..808.16 rows=20,821 width=16) (actual time=247.716..252.126 rows=694 loops=1)

  • Buffers: shared hit=44
3. 74.794 206.318 ↑ 3.3 6,247 1

Append (cost=0..547.89 rows=20,821 width=16) (actual time=0.065..206.318 rows=6,247 loops=1)

  • Buffers: shared hit=44
4. 0.105 0.105 ↑ 1.0 1 1

Seq Scan on application application_1 (cost=0..29.68 rows=1 width=16) (actual time=0.05..0.105 rows=1 loops=1)

  • Filter: (application_1.candidate_id = '00399af3-8204-4ce8-ad28-af8ea08a7e84'::uuid)
  • Buffers: shared hit=21
5. 84.033 131.419 ↑ 3.3 6,246 1

Nested Loop (cost=10.97..310.01 rows=20,820 width=16) (actual time=0.28..131.419 rows=6,246 loops=1)

  • Buffers: shared hit=23
6. 4.358 4.358 ↑ 1.0 694 1

Seq Scan on application application_2 (cost=0..27.94 rows=694 width=16) (actual time=0.011..4.358 rows=694 loops=1)

  • Buffers: shared hit=21
7. 42.592 43.028 ↑ 3.3 9 694

Materialize (cost=10.97..21.89 rows=30 width=0) (actual time=0.006..0.062 rows=9 loops=694)

  • Buffers: shared hit=2
8. 0.171 0.436 ↑ 3.3 9 1

Hash Join (cost=10.97..21.74 rows=30 width=0) (actual time=0.226..0.436 rows=9 loops=1)

  • Buffers: shared hit=2
9. 0.083 0.083 ↑ 6.7 9 1

Seq Scan on job job (cost=0..10.6 rows=60 width=16) (actual time=0.011..0.083 rows=9 loops=1)

  • Buffers: shared hit=1
10. 0.089 0.182 ↑ 3.3 9 1

Hash (cost=10.6..10.6 rows=30 width=16) (actual time=0.177..0.182 rows=9 loops=1)

  • Buffers: shared hit=1
11. 0.093 0.093 ↑ 3.3 9 1

Seq Scan on job job_1 (cost=0..10.6 rows=30 width=16) (actual time=0.017..0.093 rows=9 loops=1)

  • Filter: (NOT job_1.confidential)
  • Buffers: shared hit=1
12. 5.669 11.341 ↑ 1.0 694 1

Hash (cost=27.94..27.94 rows=694 width=16) (actual time=11.336..11.341 rows=694 loops=1)

  • Buffers: shared hit=21
13. 5.672 5.672 ↑ 1.0 694 1

Seq Scan on application application (cost=0..27.94 rows=694 width=16) (actual time=0.009..5.672 rows=694 loops=1)

  • Buffers: shared hit=21