explain.depesz.com

A tool for finding a real cause for slow queries.

Result: IYt

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

HashAggregate (cost=22,745.56..22,751.94 rows=319 width=32) (actual time=3,939.293..3,940.063 rows=319 loops=1)

2. 120.262 3,882.407 ↓ 3.9 16,879 1

Hash Left Join (cost=180.66..22,691.86 rows=4,296 width=32) (actual time=287.259..3,882.407 rows=16,879 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
3. 68.765 3,760.781 ↓ 3.9 16,879 1

Hash Join (cost=170.48..22,579.66 rows=4,296 width=20) (actual time=285.838..3,760.781 rows=16,879 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
4. 74.559 3,691.987 ↓ 3.9 16,879 1

Hash Join (cost=169.42..22,519.52 rows=4,296 width=20) (actual time=285.783..3,691.987 rows=16,879 loops=1)

  • Hash Cond: (s.vin_id = v.id)
5. 1,845.824 3,592.057 ↓ 3.9 16,879 1

Hash Join (cost=0.04..22,264.15 rows=4,304 width=20) (actual time=260.339..3,592.057 rows=16,879 loops=1)

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

Seq Scan on stock s (cost=0.00..17,916.71 rows=860,871 width=16) (actual time=52.281..1,746.201 rows=860,871 loops=1)

7. 0.014 0.032 ↑ 1.0 1 1

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

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

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.016..0.018 rows=1 loops=1)

9. 12.722 25.371 ↑ 1.0 6,061 1

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

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

Seq Scan on vin v (cost=0.00..93.61 rows=6,061 width=8) (actual time=0.012..12.649 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.696 1.364 ↑ 1.0 319 1

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

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

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