explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9dGE : req1_efo

Settings
# exclusive inclusive rows x rows loops node
1. 4.699 174.569 ↑ 1.0 319 1

HashAggregate (cost=18,800.55..18,806.93 rows=319 width=48) (actual time=174.516..174.569 rows=319 loops=1)

  • Group Key: (((((round((random() * '50'::double precision)) + '1950'::double precision)))::text || ' - '::text) || a.libelle)
2. 12.771 169.870 ↓ 3.9 16,797 1

Hash Left Join (cost=184.41..18,746.87 rows=4,295 width=40) (actual time=91.709..169.870 rows=16,797 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
3. 3.297 157.009 ↓ 3.9 16,797 1

Hash Join (cost=174.24..18,682.32 rows=4,295 width=20) (actual time=91.605..157.009 rows=16,797 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
4. 3.775 153.699 ↓ 3.9 16,797 1

Hash Join (cost=173.17..18,654.05 rows=4,295 width=20) (actual time=91.587..153.699 rows=16,797 loops=1)

  • Hash Cond: (s.vin_id = v.id)
5. 86.325 148.443 ↓ 3.9 16,797 1

Hash Join (cost=0.04..18,469.64 rows=4,295 width=20) (actual time=90.089..148.443 rows=16,797 loops=1)

  • Hash Cond: ((s.annee)::double precision = ((round((random() * '50'::double precision)) + '1950'::double precision)))
6. 62.114 62.114 ↑ 1.0 859,043 1

Seq Scan on stock s (cost=0.00..14,131.43 rows=859,043 width=16) (actual time=0.006..62.114 rows=859,043 loops=1)

7. 0.001 0.004 ↑ 1.0 1 1

Hash (cost=0.03..0.03 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

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

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

9. 0.735 1.481 ↑ 1.0 6,050 1

Hash (cost=97.50..97.50 rows=6,050 width=8) (actual time=1.481..1.481 rows=6,050 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 301kB
10. 0.746 0.746 ↑ 1.0 6,050 1

Seq Scan on vin v (cost=0.00..97.50 rows=6,050 width=8) (actual time=0.008..0.746 rows=6,050 loops=1)

11. 0.004 0.013 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.009 0.009 ↑ 1.0 3 1

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

13. 0.047 0.090 ↑ 1.0 319 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
14. 0.043 0.043 ↑ 1.0 319 1

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