explain.depesz.com

A tool for finding a real cause for slow queries.

Result: KNcv

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 53.783 675.646 ↓ 3.9 319 1

HashAggregate (cost=22,702.98..22,704.62 rows=82 width=28) (actual time=674.887..675.646 rows=319 loops=1)

  • Total runtime: 676.475 ms
2.          

Initplan (forHashAggregate)

3. 0.015 0.015 ↑ 1.0 1 1

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

4. 82.765 621.848 ↓ 3.9 16,879 1

Hash Left Join (cost=180.62..22,649.16 rows=4,304 width=28) (actual time=95.330..621.848 rows=16,879 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
5. 68.324 537.721 ↓ 3.9 16,879 1

Hash Join (cost=170.44..22,536.76 rows=4,304 width=16) (actual time=93.925..537.721 rows=16,879 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
6. 72.643 469.368 ↓ 3.9 16,879 1

Hash Join (cost=169.37..22,476.52 rows=4,304 width=16) (actual time=93.871..469.368 rows=16,879 loops=1)

  • Hash Cond: (s.vin_id = v.id)
7. 371.925 371.925 ↓ 3.9 16,879 1

Seq Scan on stock s (cost=0.00..22,221.06 rows=4,304 width=16) (actual time=68.993..371.925 rows=16,879 loops=1)

  • Filter: ((annee)::double precision = $0)
8. 12.564 24.800 ↑ 1.0 6,061 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 190kB
9. 12.236 12.236 ↑ 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.236 rows=6,061 loops=1)

10. 0.014 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
11. 0.015 0.015 ↑ 1.0 3 1

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

12. 0.703 1.362 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
13. 0.659 0.659 ↑ 1.0 319 1

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