explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rB8

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

HashAggregate (cost=18048.98..18050.62 rows=82 width=28) (actual time=641.081..641.857 rows=319 loops=1)

2.          

Initplan (forHashAggregate)

3. 0.010 0.010 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.008..0.010 rows=1 loops=1)

4. 86.579 585.946 ↓ 3.9 16828 1

Hash Left Join (cost=180.62..17995.16 rows=4304 width=28) (actual time=168.504..585.946 rows=16828 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
5. 71.250 497.990 ↓ 3.9 16828 1

Hash Join (cost=170.44..17882.76 rows=4304 width=16) (actual time=167.083..497.990 rows=16828 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
6. 76.685 426.710 ↓ 3.9 16828 1

Hash Join (cost=169.37..17822.52 rows=4304 width=16) (actual time=167.026..426.710 rows=16828 loops=1)

  • Hash Cond: (s.vin_id = v.id)
7. 324.472 324.472 ↓ 3.9 16828 1

Seq Scan on stock s (cost=0.00..17567.06 rows=4304 width=16) (actual time=141.389..324.472 rows=16828 loops=1)

  • Filter: ((annee)::double precision = $0)
8. 13.104 25.553 ↑ 1.0 6061 1

Hash (cost=93.61..93.61 rows=6061 width=8) (actual time=25.553..25.553 rows=6061 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 190kB
9. 12.449 12.449 ↑ 1.0 6061 1

Seq Scan on vin v (cost=0.00..93.61 rows=6061 width=8) (actual time=0.014..12.449 rows=6061 loops=1)

10. 0.015 0.030 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.030..0.030 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.705 1.377 ↑ 1.0 319 1

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

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

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