explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yy3f

Settings
# exclusive inclusive rows x rows loops node
1. 2,605.466 54,034.069 ↓ 0.0 0 1

Update on load_fact lf (cost=4,537.65..61,819.17 rows=192,435 width=4,286) (actual time=54,034.069..54,034.069 rows=0 loops=1)

2. 47,170.393 51,428.603 ↑ 7.9 24,407 1

Hash Join (cost=4,537.65..61,819.17 rows=192,435 width=4,286) (actual time=564.440..51,428.603 rows=24,407 loops=1)

  • Hash Cond: (s.parent_id = lel.load_id)
3. 3,720.764 3,720.764 ↑ 1.0 137,010 1

Seq Scan on stop s (cost=0.00..6,392.10 rows=137,010 width=22) (actual time=9.982..3,720.764 rows=137,010 loops=1)

4. 27.781 537.446 ↓ 1.7 11,960 1

Hash (cost=4,450.11..4,450.11 rows=7,003 width=4,256) (actual time=537.446..537.446 rows=11,960 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 4604kB
5. 23.724 509.665 ↓ 1.7 11,960 1

Hash Join (cost=508.88..4,450.11 rows=7,003 width=4,256) (actual time=136.215..509.665 rows=11,960 loops=1)

  • Hash Cond: ((lf.load_id = lel.load_id) AND (lf.shipper_user_id = lel.shipper_user_id))
6. 356.280 356.280 ↑ 1.0 12,444 1

Seq Scan on load_fact lf (cost=0.00..3,653.44 rows=12,444 width=4,242) (actual time=0.134..356.280 rows=12,444 loops=1)

7. 7.276 129.661 ↑ 1.0 12,048 1

Hash (cost=322.95..322.95 rows=12,395 width=22) (actual time=129.661..129.661 rows=12,048 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 787kB
8. 122.385 122.385 ↑ 1.0 12,395 1

Seq Scan on load_execution_link lel (cost=0.00..322.95 rows=12,395 width=22) (actual time=0.123..122.385 rows=12,395 loops=1)

Planning time : 92.924 ms
Execution time : 54,038.913 ms