explain.depesz.com

A tool for finding a real cause for slow queries.

Result: m0m

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

HashAggregate (cost=1768.21..1774.61 rows=320 width=28) (actual time=339.314..340.086 rows=319 loops=1)

2.          

Initplan (forHashAggregate)

3. 0.012 0.012 ↑ 1.0 1 1

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

4. 86.387 278.576 ↑ 1.0 16837 1

Hash Join (cost=263.96..1557.19 rows=16880 width=28) (actual time=52.897..278.576 rows=16837 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
5. 82.687 192.159 ↑ 1.0 16837 1

Hash Join (cost=262.89..1155.22 rows=16880 width=28) (actual time=52.827..192.159 rows=16837 loops=1)

  • Hash Cond: (s.vin_id = v.id)
6. 56.867 56.867 ↑ 1.0 16837 1

Index Scan using stock_annee on stock s (cost=0.00..554.74 rows=16880 width=16) (actual time=0.187..56.867 rows=16837 loops=1)

  • Index Cond: (annee = ($0)::integer)
7. 13.175 52.605 ↑ 1.0 6061 1

Hash (cost=187.13..187.13 rows=6061 width=20) (actual time=52.605..52.605 rows=6061 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 265kB
8. 25.936 39.430 ↑ 1.0 6061 1

Hash Left Join (cost=10.18..187.13 rows=6061 width=20) (actual time=1.419..39.430 rows=6061 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
9. 12.104 12.104 ↑ 1.0 6061 1

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

10. 0.716 1.390 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
11. 0.674 0.674 ↑ 1.0 319 1

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

12. 0.016 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
13. 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)