explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QaU5W

Settings
# exclusive inclusive rows x rows loops node
1. 0.733 3.517 ↓ 2,509.0 2,509 1

Hash Join (cost=292.12..360.77 rows=1 width=77) (actual time=2.416..3.517 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.178 1.428 ↓ 1.0 2,509 1

HashAggregate (cost=129.04..154.00 rows=2,496 width=16) (actual time=1.044..1.428 rows=2,509 loops=1)

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

Seq Scan on batch_job_execution (cost=0.00..112.03 rows=3,403 width=16) (actual time=0.002..0.250 rows=3,403 loops=1)

4. 0.724 1.356 ↑ 1.0 3,403 1

Hash (cost=112.03..112.03 rows=3,403 width=77) (actual time=1.356..1.356 rows=3,403 loops=1)

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

Seq Scan on batch_job_execution execution (cost=0.00..112.03 rows=3,403 width=77) (actual time=0.009..0.632 rows=3,403 loops=1)