explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TXDs

Settings
# exclusive inclusive rows x rows loops node
1. 6.283 878.962 ↑ 1.0 319 1

HashAggregate (cost=21,362.66..21,369.04 rows=319 width=48) (actual time=878.876..878.962 rows=319 loops=1)

  • Group Key: (((((round((random() * '50'::double precision)) + '1950'::double precision)))::text || ' - '::text) || a.libelle)
2. 23.304 872.679 ↓ 3.3 16,796 1

Hash Left Join (cost=238.23..21,298.60 rows=5,125 width=40) (actual time=436.585..872.679 rows=16,796 loops=1)

  • Hash Cond: (v.appellation_id = a.id)
3. 3.772 849.267 ↓ 3.3 16,796 1

Hash Join (cost=228.06..21,223.54 rows=5,125 width=20) (actual time=427.247..849.267 rows=16,796 loops=1)

  • Hash Cond: (s.vin_id = v.id)
4. 3.444 839.627 ↓ 3.3 16,796 1

Hash Join (cost=37.04..21,019.07 rows=5,125 width=20) (actual time=421.324..839.627 rows=16,796 loops=1)

  • Hash Cond: (s.contenant_id = c.id)
5. 128.038 829.972 ↓ 3.3 16,796 1

Hash Join (cost=0.04..20,968.57 rows=5,125 width=20) (actual time=415.053..829.972 rows=16,796 loops=1)

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

Seq Scan on stock s (cost=0.00..15,791.85 rows=1,025,085 width=16) (actual time=15.967..701.906 rows=859,832 loops=1)

7. 0.009 0.028 ↑ 1.0 1 1

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

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

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

9. 0.023 6.211 ↑ 400.0 3 1

Hash (cost=22.00..22.00 rows=1,200 width=8) (actual time=6.211..6.211 rows=3 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
10. 6.188 6.188 ↑ 400.0 3 1

Seq Scan on contenant c (cost=0.00..22.00 rows=1,200 width=8) (actual time=6.186..6.188 rows=3 loops=1)

11. 1.265 5.868 ↑ 1.1 6,056 1

Hash (cost=105.45..105.45 rows=6,845 width=8) (actual time=5.868..5.868 rows=6,056 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 301kB
12. 4.603 4.603 ↑ 1.1 6,056 1

Seq Scan on vin v (cost=0.00..105.45 rows=6,845 width=8) (actual time=0.522..4.603 rows=6,056 loops=1)

13. 0.057 0.108 ↑ 1.0 319 1

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

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

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

Planning time : 240.671 ms
Execution time : 901.234 ms