explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YgV

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

HashAggregate (cost=18,068.88..18,075.26 rows=319 width=32) (actual time=1,827.959..1,828.338 rows=319 loops=1)

2. 51.328 1,801.989 ↓ 3.9 16,802 1

Hash Left Join (cost=180.50..18,015.15 rows=4,299 width=32) (actual time=697.538..1,801.989 rows=16,802 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
3. 32.216 1,749.928 ↓ 3.9 16,802 1

Hash Join (cost=170.32..17,902.87 rows=4,299 width=20) (actual time=696.754..1,749.928 rows=16,802 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
4. 34.570 1,717.696 ↓ 3.9 16,802 1

Hash Join (cost=169.26..17,842.69 rows=4,299 width=20) (actual time=696.714..1,717.696 rows=16,802 loops=1)

  • Hash Cond: (s.vin_id = v.id)
5. 931.273 1,669.459 ↓ 3.9 16,802 1

Hash Join (cost=0.04..17,587.49 rows=4,299 width=20) (actual time=683.013..1,669.459 rows=16,802 loops=1)

  • Hash Cond: ((s.annee)::double precision = ((round((random() * 50::double precision)) + 1950::double precision)))
6. 738.169 738.169 ↑ 1.0 859,764 1

Seq Scan on stock s (cost=0.00..13,245.64 rows=859,764 width=16) (actual time=0.004..738.169 rows=859,764 loops=1)

7. 0.003 0.017 ↑ 1.0 1 1

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

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

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.013..0.014 rows=1 loops=1)

9. 6.796 13.667 ↑ 1.0 6,054 1

Hash (cost=93.54..93.54 rows=6,054 width=8) (actual time=13.667..13.667 rows=6,054 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 237kB
10. 6.871 6.871 ↑ 1.0 6,054 1

Seq Scan on vin v (cost=0.00..93.54 rows=6,054 width=8) (actual time=0.007..6.871 rows=6,054 loops=1)

11. 0.009 0.016 ↑ 1.0 3 1

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

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

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

13. 0.369 0.733 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
14. 0.364 0.364 ↑ 1.0 319 1

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