explain.depesz.com

A tool for finding a real cause for slow queries.

Result: U3M

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 61.228 4,009.842 ↑ 1.0 319 1

HashAggregate (cost=18,092.05..18,098.42 rows=319 width=32) (actual time=4,009.066..4,009.842 rows=319 loops=1)

  • Total runtime: 4010.805 ms
2. 123.088 3,948.614 ↓ 3.9 16,833 1

Hash Left Join (cost=180.66..18,038.25 rows=4,304 width=32) (actual time=185.033..3,948.614 rows=16,833 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
3. 72.665 3,824.137 ↓ 3.9 16,833 1

Hash Join (cost=170.48..17,925.85 rows=4,304 width=20) (actual time=183.579..3,824.137 rows=16,833 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
4. 79.521 3,751.443 ↓ 3.9 16,833 1

Hash Join (cost=169.42..17,865.60 rows=4,304 width=20) (actual time=183.529..3,751.443 rows=16,833 loops=1)

  • Hash Cond: (s.vin_id = v.id)
5. 1,881.882 3,646.208 ↓ 3.9 16,833 1

Hash Join (cost=0.04..17,610.15 rows=4,304 width=20) (actual time=157.734..3,646.208 rows=16,833 loops=1)

  • Hash Cond: ((s.annee)::double precision = ((round((random() * 50::double precision)) + 1950::double precision)))
6. 1,764.307 1,764.307 ↑ 1.0 860,871 1

Seq Scan on stock s (cost=0.00..13,262.71 rows=860,871 width=16) (actual time=0.006..1,764.307 rows=860,871 loops=1)

7. 0.008 0.019 ↑ 1.0 1 1

Hash (cost=0.03..0.03 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.011 0.011 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.009..0.011 rows=1 loops=1)

9. 12.921 25.714 ↑ 1.0 6,061 1

Hash (cost=93.61..93.61 rows=6,061 width=8) (actual time=25.714..25.714 rows=6,061 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 190kB
10. 12.793 12.793 ↑ 1.0 6,061 1

Seq Scan on vin v (cost=0.00..93.61 rows=6,061 width=8) (actual time=0.015..12.793 rows=6,061 loops=1)

11. 0.015 0.029 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.029..0.029 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.014 0.014 ↑ 1.0 3 1

Seq Scan on contenant c (cost=0.00..1.03 rows=3 width=8) (actual time=0.007..0.014 rows=3 loops=1)

13. 0.708 1.389 ↑ 1.0 319 1

Hash (cost=6.19..6.19 rows=319 width=20) (actual time=1.389..1.389 rows=319 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
14. 0.681 0.681 ↑ 1.0 319 1

Seq Scan on appellation a (cost=0.00..6.19 rows=319 width=20) (actual time=0.012..0.681 rows=319 loops=1)