explain.depesz.com

A tool for finding a real cause for slow queries.

Result: v8hN

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

HashAggregate (cost=1652.22..1977.60 rows=16269 width=28) (actual time=146.961..147.552 rows=319 loops=1)

2. 25.440 110.563 ↓ 1.0 16881 1

Hash Join (cost=267.92..1399.98 rows=16816 width=28) (actual time=19.398..110.563 rows=16881 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
3. 29.373 85.107 ↓ 1.0 16881 1

Hash Join (cost=266.85..1167.69 rows=16816 width=28) (actual time=19.371..85.107 rows=16881 loops=1)

  • Hash Cond: (s.vin_id = v.id)
4. 36.387 36.399 ↓ 1.0 16881 1

Append (cost=0.00..564.52 rows=16816 width=16) (actual time=0.021..36.399 rows=16881 loops=1)

  • -> Index Scan using stock_annee on stock s (cost=0.00..536.45 rows=16807 width=16) (actual time=0.020..20.750 rows=16881 loops
  • Index Cond: (annee = 1955)
5. 0.003 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on stock_1950 s (cost=17.53..28.07 rows=9 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (annee = 1955)
6. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on pk_stock_1950 (cost=0.00..17.53 rows=9 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (annee = 1955)
7. 5.900 19.335 ↑ 1.0 6060 1

Hash (cost=191.10..191.10 rows=6060 width=20) (actual time=19.335..19.335 rows=6060 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 251kB
8. 8.976 13.435 ↑ 1.0 6060 1

Hash Join (cost=10.18..191.10 rows=6060 width=20) (actual time=0.526..13.435 rows=6060 loops=1)

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

Seq Scan on vin v (cost=0.00..97.60 rows=6060 width=8) (actual time=0.009..3.952 rows=6060 loops=1)

10. 0.276 0.507 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.231 0.231 ↑ 1.0 319 1

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

12. 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
13. 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.005..0.007 rows=3 loops=1)