explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OqLs

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 66,958.767 ↑ 1.1 9 1

Sort (cost=1,104,474.24..1,104,474.27 rows=10 width=37) (actual time=66,958.766..66,958.767 rows=9 loops=1)

  • Sort Key: (max(generations.start_time)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 86.995 66,958.711 ↑ 1.1 9 1

HashAggregate (cost=1,104,473.93..1,104,474.08 rows=10 width=37) (actual time=66,958.707..66,958.711 rows=9 loops=1)

  • Group Key: generations.experiment
3. 80.665 66,871.716 ↑ 1.2 108,798 1

Hash Left Join (cost=10,715.83..1,102,466.49 rows=133,829 width=32) (actual time=356.510..66,871.716 rows=108,798 loops=1)

  • Hash Cond: (executions.phase_group_id = grasp_verify.phase_group_id)
4. 381.250 66,762.431 ↑ 1.2 108,798 1

Hash Join (cost=9,910.80..1,100,865.22 rows=133,829 width=33) (actual time=327.750..66,762.431 rows=108,798 loops=1)

  • Hash Cond: (candidates.grasp_generation_id = generations.grasp_generation_id)
5. 311.425 66,058.435 ↑ 1.1 122,144 1

Nested Loop (cost=0.56..1,086,314.83 rows=133,829 width=32) (actual time=4.725..66,058.435 rows=122,144 loops=1)

6. 121.800 121.800 ↓ 1.0 133,929 1

Seq Scan on grasp_executions executions (cost=0.00..7,270.29 rows=133,829 width=32) (actual time=0.470..121.800 rows=133,929 loops=1)

7. 65,625.210 65,625.210 ↑ 1.0 1 133,929

Index Scan using grasp_processed_candidates_pkey on grasp_processed_candidates candidates (cost=0.56..8.05 rows=1 width=32) (actual time=0.489..0.490 rows=1 loops=133,929)

  • Index Cond: (candidate_id = executions.executed_candidate_id)
8. 62.144 322.746 ↑ 1.0 124,130 1

Hash (cost=7,388.44..7,388.44 rows=124,144 width=33) (actual time=322.746..322.746 rows=124,130 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2631kB
9. 260.602 260.602 ↑ 1.0 124,130 1

Seq Scan on grasp_generations generations (cost=0.00..7,388.44 rows=124,144 width=33) (actual time=0.464..260.602 rows=124,130 loops=1)

10. 7.191 28.620 ↓ 1.0 19,403 1

Hash (cost=562.79..562.79 rows=19,379 width=31) (actual time=28.620..28.620 rows=19,403 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1460kB
11. 21.429 21.429 ↓ 1.0 19,403 1

Seq Scan on grasp_verify (cost=0.00..562.79 rows=19,379 width=31) (actual time=0.447..21.429 rows=19,403 loops=1)