explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vpRT

Settings
# exclusive inclusive rows x rows loops node
1. 4.437 91.480 ↑ 13.5 319 1

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

  • Group Key: (((s.annee)::text || ' - '::text) || a.libelle)
  • Planning time: 0.342 ms
  • Execution time: 91.553 ms
2.          

Initplan (forHashAggregate)

3. 0.002 0.002 ↑ 1.0 1 1

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

4. 5.354 87.041 ↓ 3.9 16,846 1

Hash Left Join (cost=180.71..17,971.98 rows=4,305 width=40) (actual time=14.655..87.041 rows=16,846 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
5. 2.434 81.621 ↓ 3.9 16,846 1

Hash Join (cost=170.53..17,859.56 rows=4,305 width=16) (actual time=14.579..81.621 rows=16,846 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
6. 3.122 79.181 ↓ 3.9 16,846 1

Hash Join (cost=169.46..17,799.30 rows=4,305 width=16) (actual time=14.567..79.181 rows=16,846 loops=1)

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

Seq Scan on stock s (cost=0.00..17,570.64 rows=4,305 width=16) (actual time=13.424..74.942 rows=16,846 loops=1)

  • Filter: ($0 = (annee)::double precision)
  • Rows Removed by Filter: 844197
8. 0.598 1.117 ↑ 1.0 6,065 1

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

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

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

10. 0.003 0.006 ↑ 1.0 3 1

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

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

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

12. 0.039 0.066 ↑ 1.0 319 1

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

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

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