explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xw2t

Settings
# exclusive inclusive rows x rows loops node
1. 110.720 2,231.381 ↓ 1.1 103,269 1

Hash Left Join (cost=32,790.39..42,946.42 rows=93,272 width=1,661) (actual time=1,070.188..2,231.381 rows=103,269 loops=1)

  • Hash Cond: (rhv.id_veh = veh.id)
  • Planning time: 5.467 ms
  • Execution time: 2269.536 ms
2. 111.145 2,117.150 ↓ 1.1 103,269 1

Hash Left Join (cost=29,520.56..37,565.78 rows=93,272 width=1,133) (actual time=1,066.646..2,117.150 rows=103,269 loops=1)

  • Hash Cond: (rh.id_hrut = rhv.id_hrut)
3. 107.719 1,691.637 ↓ 1.1 103,269 1

Hash Left Join (cost=21,131.00..27,893.73 rows=93,272 width=1,129) (actual time=749.611..1,691.637 rows=103,269 loops=1)

  • Hash Cond: (rh.id_hrut = rhc.id_hrut)
4. 133.141 1,555.537 ↓ 1.1 103,269 1

Hash Left Join (cost=19,458.59..24,938.84 rows=93,272 width=1,097) (actual time=721.150..1,555.537 rows=103,269 loops=1)

  • Hash Cond: (c.id_car = rh.id_car)
5. 101.588 1,333.471 ↓ 1.2 103,250 1

Hash Left Join (cost=16,763.97..20,499.84 rows=87,189 width=1,089) (actual time=631.666..1,333.471 rows=103,250 loops=1)

  • Hash Cond: (suc.id_direccion = dir.id)
6. 102.951 1,105.624 ↓ 1.2 103,250 1

Hash Left Join (cost=12,631.11..16,138.09 rows=87,189 width=1,062) (actual time=505.284..1,105.624 rows=103,250 loops=1)

  • Hash Cond: (c.id_suc = suc.id)
7. 109.751 694.481 ↓ 1.2 103,250 1

Hash Join (cost=5,712.61..8,990.72 rows=87,189 width=1,057) (actual time=196.017..694.481 rows=103,250 loops=1)

  • Hash Cond: (c.id_est = ec.id_estcar)
8. 116.609 584.702 ↓ 1.2 103,250 1

Hash Join (cost=5,711.31..8,685.94 rows=87,189 width=1,037) (actual time=195.977..584.702 rows=103,250 loops=1)

  • Hash Cond: (c.id_dir = d.id)
9. 108.781 329.147 ↓ 1.2 103,250 1

Hash Join (cost=1,578.45..4,324.19 rows=87,189 width=972) (actual time=56.469..329.147 rows=103,250 loops=1)

  • Hash Cond: (c.id_per = p.id)
10. 93.169 164.223 ↓ 1.2 103,250 1

Hash Left Join (cost=14.09..2,530.93 rows=87,189 width=919) (actual time=0.018..164.223 rows=103,250 loops=1)

  • Hash Cond: (c.id_car = j.id_car)
11. 71.048 71.048 ↓ 1.2 103,250 1

Seq Scan on carga c (cost=0.00..2,188.89 rows=87,189 width=153) (actual time=0.005..71.048 rows=103,250 loops=1)

12. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=12.84..12.84 rows=100 width=774) (actual time=0.005..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
13. 0.001 0.005 ↓ 0.0 0 1

Hash Left Join (cost=1.56..12.84 rows=100 width=774) (actual time=0.004..0.005 rows=0 loops=1)

  • Hash Cond: (j.id_motiv = m.id_mot)
14. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on justificacion j (cost=0.00..11.00 rows=100 width=754) (actual time=0.003..0.004 rows=0 loops=1)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.25..1.25 rows=25 width=24) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on motivo_negativo m (cost=0.00..1.25 rows=25 width=24) (never executed)

17. 29.695 56.143 ↓ 1.0 43,833 1

Hash (cost=1,019.16..1,019.16 rows=43,616 width=57) (actual time=56.142..56.143 rows=43,833 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3779kB
18. 26.448 26.448 ↓ 1.0 43,833 1

Seq Scan on persona p (cost=0.00..1,019.16 rows=43,616 width=57) (actual time=0.009..26.448 rows=43,833 loops=1)

19. 75.725 138.946 ↓ 1.0 118,095 1

Hash (cost=2,666.83..2,666.83 rows=117,283 width=73) (actual time=138.945..138.946 rows=118,095 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 11746kB
20. 63.221 63.221 ↓ 1.0 118,095 1

Seq Scan on direccion d (cost=0.00..2,666.83 rows=117,283 width=73) (actual time=0.007..63.221 rows=118,095 loops=1)

21. 0.012 0.028 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=28) (actual time=0.028..0.028 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.016 0.016 ↑ 1.0 13 1

Seq Scan on estado_carga ec (cost=0.00..1.13 rows=13 width=28) (actual time=0.006..0.016 rows=13 loops=1)

23. 166.600 308.192 ↓ 1.3 286,998 1

Hash (cost=4,136.00..4,136.00 rows=222,600 width=9) (actual time=308.192..308.192 rows=286,998 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 1 (originally 1) Memory Usage: 16501kB
24. 141.592 141.592 ↓ 1.3 286,998 1

Seq Scan on sucursal suc (cost=0.00..4,136.00 rows=222,600 width=9) (actual time=0.008..141.592 rows=286,998 loops=1)

25. 67.196 126.259 ↓ 1.0 118,095 1

Hash (cost=2,666.83..2,666.83 rows=117,283 width=35) (actual time=126.259..126.259 rows=118,095 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8925kB
26. 59.063 59.063 ↓ 1.0 118,095 1

Seq Scan on direccion dir (cost=0.00..2,666.83 rows=117,283 width=35) (actual time=0.008..59.063 rows=118,095 loops=1)

27. 45.906 88.925 ↓ 1.0 93,480 1

Hash (cost=1,528.72..1,528.72 rows=93,272 width=16) (actual time=88.924..88.925 rows=93,480 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5406kB
28. 43.019 43.019 ↓ 1.0 93,480 1

Seq Scan on rel_hrut_car rh (cost=0.00..1,528.72 rows=93,272 width=16) (actual time=0.010..43.019 rows=93,480 loops=1)

29. 8.216 28.381 ↓ 1.1 10,840 1

Hash (cost=1,545.82..1,545.82 rows=10,127 width=40) (actual time=28.380..28.381 rows=10,840 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 812kB
30. 13.625 20.165 ↓ 1.1 10,840 1

Hash Left Join (cost=1,243.30..1,545.82 rows=10,127 width=40) (actual time=1.110..20.165 rows=10,840 loops=1)

  • Hash Cond: (rhc.id_con = con.id_con)
31. 5.455 5.455 ↓ 1.1 10,840 1

Seq Scan on rel_hrut_con rhc (cost=0.00..163.27 rows=10,127 width=12) (actual time=0.007..5.455 rows=10,840 loops=1)

32. 0.134 1.085 ↑ 1.0 210 1

Hash (cost=1,240.68..1,240.68 rows=210 width=32) (actual time=1.085..1.085 rows=210 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
33. 0.230 0.951 ↑ 1.0 210 1

Nested Loop Left Join (cost=0.29..1,240.68 rows=210 width=32) (actual time=0.029..0.951 rows=210 loops=1)

34. 0.091 0.091 ↑ 1.0 210 1

Seq Scan on conductor con (cost=0.00..4.10 rows=210 width=12) (actual time=0.005..0.091 rows=210 loops=1)

35. 0.630 0.630 ↑ 1.0 1 210

Index Scan using persona_pkey on persona per (cost=0.29..5.89 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=210)

  • Index Cond: (id = con.id_per)
36. 183.486 314.368 ↓ 1.1 322,527 1

Hash (cost=4,556.47..4,556.47 rows=306,647 width=8) (actual time=314.367..314.368 rows=322,527 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 16695kB
37. 130.882 130.882 ↓ 1.1 322,527 1

Seq Scan on rel_hrut_veh rhv (cost=0.00..4,556.47 rows=306,647 width=8) (actual time=0.011..130.882 rows=322,527 loops=1)

38. 0.433 3.511 ↑ 2.2 867 1

Hash (cost=3,245.48..3,245.48 rows=1,948 width=11) (actual time=3.511..3.511 rows=867 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 54kB
39. 3.078 3.078 ↑ 2.2 867 1

Seq Scan on vehiculo veh (cost=0.00..3,245.48 rows=1,948 width=11) (actual time=0.007..3.078 rows=867 loops=1)