explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ycds

Settings
# exclusive inclusive rows x rows loops node
1. 8.541 52.232 ↓ 358.4 2,509 1

GroupAggregate (cost=1,149.96..1,150.21 rows=7 width=204) (actual time=40.351..52.232 rows=2,509 loops=1)

  • Group Key: execution.job_execution_id, batch_job_instance.job_name, batch_job_restart_execution.job_next_restart_time
2. 21.061 43.691 ↓ 2,645.9 18,521 1

Sort (cost=1,149.96..1,149.98 rows=7 width=147) (actual time=40.335..43.691 rows=18,521 loops=1)

  • Sort Key: execution.job_execution_id, batch_job_instance.job_name, batch_job_restart_execution.job_next_restart_time
  • Sort Method: external sort Disk: 3168kB
3. 5.836 22.630 ↓ 2,645.9 18,521 1

Hash Join (cost=364.80..1,149.86 rows=7 width=147) (actual time=14.316..22.630 rows=18,521 loops=1)

  • Hash Cond: (batch_job_execution_params.job_execution_id = execution.job_execution_id)
4. 2.500 2.500 ↑ 1.0 25,227 1

Seq Scan on batch_job_execution_params (cost=0.00..689.27 rows=25,527 width=47) (actual time=0.007..2.500 rows=25,227 loops=1)

5. 0.813 14.294 ↓ 2,509.0 2,509 1

Hash (cost=364.79..364.79 rows=1 width=108) (actual time=14.294..14.294 rows=2,509 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 404kB
6. 3.879 13.481 ↓ 2,509.0 2,509 1

Nested Loop Left Join (cost=294.04..364.79 rows=1 width=108) (actual time=2.320..13.481 rows=2,509 loops=1)

  • Join Filter: ((execution.job_instance_id = batch_job_restart_execution.job_instance_id) AND (execution.job_execution_id = batch_job_restart_execution.job_execution_id))
  • Rows Removed by Join Filter: 10032
7. 0.979 7.093 ↓ 2,509.0 2,509 1

Nested Loop (cost=294.04..363.64 rows=1 width=100) (actual time=2.313..7.093 rows=2,509 loops=1)

8. 0.865 3.605 ↓ 2,509.0 2,509 1

Hash Join (cost=293.76..363.26 rows=1 width=85) (actual time=2.307..3.605 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))
9. 1.186 1.421 ↑ 1.0 2,509 1

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

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

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

11. 0.600 1.319 ↑ 1.0 3,403 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 416kB
12. 0.719 0.719 ↑ 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.003..0.719 rows=3,403 loops=1)

13. 2.509 2.509 ↑ 1.0 1 2,509

Index Scan using batch_job_instance_pkey on batch_job_instance (cost=0.28..0.36 rows=1 width=31) (actual time=0.001..0.001 rows=1 loops=2,509)

  • Index Cond: (job_instance_id = execution.job_instance_id)
14. 2.509 2.509 ↑ 1.5 4 2,509

Seq Scan on batch_job_restart_execution (cost=0.00..1.06 rows=6 width=24) (actual time=0.001..0.001 rows=4 loops=2,509)