explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5zg8

Settings
# exclusive inclusive rows x rows loops node
1. 2,184.875 30,127.338 ↓ 1.0 15,662,224 1

Hash Join (cost=537,591.40..1,363,086.67 rows=15,649,840 width=4) (actual time=8,198.940..30,127.338 rows=15,662,224 loops=1)

  • Output: q.id
  • Inner Unique: true
  • Hash Cond: (tje.transform_job_id = tj.id)
  • Buffers: shared hit=11,677 read=264,003, temp read=148,782 written=148,782
  • Functions: 17
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4.875 ms, Inlining 5.352 ms, Optimization 100.426 ms, Emission 43.425 ms, Total 154.077 ms
2. 14,172.342 27,793.000 ↓ 1.0 15,662,224 1

Hash Join (cost=537,579.40..1,321,558.58 rows=15,649,840 width=8) (actual time=8,049.463..27,793.000 rows=15,662,224 loops=1)

  • Output: tje.transform_job_id, q.id
  • Inner Unique: true
  • Hash Cond: (tje.id = q.transform_job_execution_id)
  • Buffers: shared hit=11,674 read=264,003, temp read=148,782 written=148,782
3. 5,571.498 5,571.498 ↑ 1.0 27,962,784 1

Seq Scan on orchestration.transform_job_execution tje (cost=0.00..430,981.44 rows=27,962,944 width=8) (actual time=0.007..5,571.498 rows=27,962,784 loops=1)

  • Output: tje.transform_job_id, tje.id
  • Buffers: shared hit=6,601 read=144,751
4. 3,068.411 8,049.160 ↓ 1.0 15,662,224 1

Hash (cost=280,823.40..280,823.40 rows=15,649,840 width=8) (actual time=8,049.156..8,049.160 rows=15,662,224 loops=1)

  • Output: q.id, q.transform_job_execution_id
  • Buckets: 131,072 Batches: 256 Memory Usage: 3,401kB
  • Buffers: shared hit=5,073 read=119,252, temp written=53,202
5. 4,980.749 4,980.749 ↓ 1.0 15,662,224 1

Seq Scan on orchestration.transform_job_execution_queue q (cost=0.00..280,823.40 rows=15,649,840 width=8) (actual time=0.005..4,980.749 rows=15,662,224 loops=1)

  • Output: q.id, q.transform_job_execution_id
  • Buffers: shared hit=5,073 read=119,252
6. 0.046 149.463 ↑ 1.0 400 1

Hash (cost=7.00..7.00 rows=400 width=4) (actual time=149.463..149.463 rows=400 loops=1)

  • Output: tj.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=3
7. 149.417 149.417 ↑ 1.0 400 1

Seq Scan on orchestration.transform_job tj (cost=0.00..7.00 rows=400 width=4) (actual time=149.385..149.417 rows=400 loops=1)

  • Output: tj.id
  • Buffers: shared hit=3
Planning time : 1.379 ms
Execution time : 30,708.292 ms