explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HTYy

Settings
# exclusive inclusive rows x rows loops node
1. 4.321 93.128 ↑ 13.5 319 1

HashAggregate (cost=18,025.82..18,111.92 rows=4,305 width=48) (actual time=93.088..93.128 rows=319 loops=1)

  • Group Key: (((s.annee)::text || ' - '::text) || a.libelle)
2.          

Initplan (forHashAggregate)

3. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

4. 4.922 88.804 ↓ 3.9 16,858 1

Hash Left Join (cost=180.71..17,971.98 rows=4,305 width=40) (actual time=73.527..88.804 rows=16,858 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
5. 2.393 83.812 ↓ 3.9 16,858 1

Hash Join (cost=170.53..17,859.56 rows=4,305 width=16) (actual time=73.449..83.812 rows=16,858 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
6. 3.004 81.411 ↓ 3.9 16,858 1

Hash Join (cost=169.46..17,799.30 rows=4,305 width=16) (actual time=73.434..81.411 rows=16,858 loops=1)

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

Seq Scan on stock s (cost=0.00..17,570.64 rows=4,305 width=16) (actual time=72.277..77.280 rows=16,858 loops=1)

  • Filter: ($0 = (annee)::double precision)
  • Rows Removed by Filter: 844185
8. 0.591 1.127 ↑ 1.0 6,065 1

Hash (cost=93.65..93.65 rows=6,065 width=8) (actual time=1.127..1.127 rows=6,065 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 301kB
9. 0.536 0.536 ↑ 1.0 6,065 1

Seq Scan on vin v (cost=0.00..93.65 rows=6,065 width=8) (actual time=0.006..0.536 rows=6,065 loops=1)

10. 0.002 0.008 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.006 0.006 ↑ 1.0 3 1

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

12. 0.038 0.070 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
13. 0.032 0.032 ↑ 1.0 319 1

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