explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Avqs

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 2,513.460 ↑ 1.0 30 1

Limit (cost=205,604.09..205,604.17 rows=30 width=61) (actual time=2,513.427..2,513.460 rows=30 loops=1)

2. 51.431 2,513.428 ↑ 96,862.3 30 1

Sort (cost=205,604.09..212,868.76 rows=2,905,868 width=61) (actual time=2,513.423..2,513.428 rows=30 loops=1)

  • Sort Key: l.internal_reference_id DESC
  • Sort Method: top-N heapsort Memory: 29kB
3. 333.371 2,461.997 ↑ 13.3 218,174 1

Hash Join (cost=67,140.73..119,780.87 rows=2,905,868 width=61) (actual time=2,000.165..2,461.997 rows=218,174 loops=1)

  • Hash Cond: (s.id = al.parent_id)
4. 53.525 221.528 ↑ 13.0 25,322 1

Hash Join (cost=4,111.70..14,490.89 rows=330,204 width=53) (actual time=86.504..221.528 rows=25,322 loops=1)

  • Hash Cond: (s.parent_id = l.id)
5. 82.181 82.181 ↑ 1.0 137,010 1

Seq Scan on stop s (cost=0.00..6,392.10 rows=137,010 width=32) (actual time=0.067..82.181 rows=137,010 loops=1)

6. 5.306 85.822 ↑ 1.0 12,395 1

Hash (cost=3,956.77..3,956.77 rows=12,395 width=45) (actual time=85.822..85.822 rows=12,395 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1097kB
7. 8.069 80.516 ↑ 1.0 12,395 1

Hash Join (cost=3,463.38..3,956.77 rows=12,395 width=45) (actual time=70.094..80.516 rows=12,395 loops=1)

  • Hash Cond: (lel.load_id = l.id)
8. 2.514 2.514 ↑ 1.0 12,395 1

Seq Scan on load_execution_link lel (cost=0.00..322.95 rows=12,395 width=8) (actual time=0.073..2.514 rows=12,395 loops=1)

9. 4.262 69.933 ↑ 1.0 5,143 1

Hash (cost=3,399.10..3,399.10 rows=5,143 width=37) (actual time=69.933..69.933 rows=5,143 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 426kB
10. 29.089 65.671 ↑ 1.0 5,143 1

Hash Join (cost=273.72..3,399.10 rows=5,143 width=37) (actual time=6.826..65.671 rows=5,143 loops=1)

  • Hash Cond: (v.id = l.vehicle_id)
11. 29.917 29.917 ↑ 1.0 101,960 1

Seq Scan on vehicle v (cost=0.00..2,691.60 rows=101,960 width=8) (actual time=0.041..29.917 rows=101,960 loops=1)

12. 1.818 6.665 ↑ 1.0 5,143 1

Hash (cost=209.43..209.43 rows=5,143 width=45) (actual time=6.665..6.665 rows=5,143 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 466kB
13. 4.847 4.847 ↑ 1.0 5,143 1

Seq Scan on load l (cost=0.00..209.43 rows=5,143 width=45) (actual time=0.047..4.847 rows=5,143 loops=1)

14. 174.825 1,907.098 ↑ 1.0 522,209 1

Hash (cost=56,487.05..56,487.05 rows=523,358 width=16) (actual time=1,907.098..1,907.098 rows=522,209 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 28575kB
15. 234.000 1,732.273 ↑ 1.0 522,209 1

Hash Join (cost=26,976.12..56,487.05 rows=523,358 width=16) (actual time=817.035..1,732.273 rows=522,209 loops=1)

  • Hash Cond: (c.stop_id = al.parent_id)
16. 465.034 1,268.412 ↓ 1.0 523,624 1

Hash Join (cost=19,413.54..41,728.29 rows=523,358 width=8) (actual time=584.889..1,268.412 rows=523,624 loops=1)

  • Hash Cond: (g.id = c.good_id)
17. 224.933 224.933 ↑ 1.0 523,358 1

Seq Scan on good g (cost=0.00..15,118.58 rows=523,358 width=8) (actual time=0.035..224.933 rows=523,358 loops=1)

18. 316.421 578.445 ↑ 1.0 523,624 1

Hash (cost=12,868.24..12,868.24 rows=523,624 width=16) (actual time=578.445..578.445 rows=523,624 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 28641kB
19. 262.024 262.024 ↑ 1.0 523,624 1

Seq Scan on consignment c (cost=0.00..12,868.24 rows=523,624 width=16) (actual time=0.057..262.024 rows=523,624 loops=1)

20. 102.691 229.861 ↑ 1.0 154,429 1

Hash (cost=5,623.20..5,623.20 rows=155,151 width=8) (actual time=229.860..229.861 rows=154,429 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8081kB
21. 81.616 127.170 ↑ 1.0 154,429 1

Hash Join (cost=174.36..5,623.20 rows=155,151 width=8) (actual time=3.195..127.170 rows=154,429 loops=1)

  • Hash Cond: (al.address_id = a.id)
22. 42.557 42.557 ↑ 1.0 155,151 1

Seq Scan on address_link al (cost=0.00..3,315.51 rows=155,151 width=16) (actual time=0.071..42.557 rows=155,151 loops=1)

23. 1.188 2.997 ↑ 1.0 4,416 1

Hash (cost=119.16..119.16 rows=4,416 width=8) (actual time=2.997..2.997 rows=4,416 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 237kB
24. 1.809 1.809 ↑ 1.0 4,416 1

Seq Scan on address a (cost=0.00..119.16 rows=4,416 width=8) (actual time=0.030..1.809 rows=4,416 loops=1)

25.          

SubPlan (for Hash Join)

26. 0.000 0.000 ↑ 1.0 1 218,174

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=218,174)

Planning time : 41.087 ms
Execution time : 2,540.678 ms