explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LOI6

Settings
# exclusive inclusive rows x rows loops node
1. 0.923 4.502 ↓ 2,509.0 2,509 1

Hash Join (cost=293.76..363.26 rows=1 width=77) (actual time=3.237..4.502 rows=2,509 loops=1)

  • Hash Cond: ((batch_job_execution.job_instance_id = execution.job_instance_id) AND ((max(batch_job_execution.create_time)) = execution.create_time))
2. 1.478 1.802 ↑ 1.0 2,509 1

HashAggregate (cost=129.66..154.93 rows=2,527 width=16) (actual time=1.416..1.802 rows=2,509 loops=1)

  • Group Key: batch_job_execution.job_instance_id
3. 0.324 0.324 ↑ 1.0 3,403 1

Seq Scan on batch_job_execution (cost=0.00..112.44 rows=3,444 width=16) (actual time=0.004..0.324 rows=3,403 loops=1)

4. 0.978 1.777 ↑ 1.0 3,403 1

Hash (cost=112.44..112.44 rows=3,444 width=77) (actual time=1.777..1.777 rows=3,403 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 416kB
5. 0.799 0.799 ↑ 1.0 3,403 1

Seq Scan on batch_job_execution execution (cost=0.00..112.44 rows=3,444 width=77) (actual time=0.008..0.799 rows=3,403 loops=1)