explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qOoU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=60,810.85..60,881.70 rows=319 width=48) (actual rows= loops=)

  • Group Key: ((((((round((random() * '50'::double precision)) + '1950'::double precision)))::text || ' - '::text) || a.libelle))
2. 0.000 0.000 ↓ 0.0

Sort (cost=60,810.85..60,821.59 rows=4,298 width=40) (actual rows= loops=)

  • Sort Key: ((((((round((random() * '50'::double precision)) + '1950'::double precision)))::text || ' - '::text) || a.libelle))
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=525.06..60,551.48 rows=4,298 width=40) (actual rows= loops=)

  • Hash Cond: (v.appellation_id = a.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=502.14..60,474.15 rows=4,298 width=20) (actual rows= loops=)

  • Hash Cond: (s.vin_id = v.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=81.62..60,042.34 rows=4,298 width=20) (actual rows= loops=)

  • Hash Cond: (s.contenant_id = c.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.47..59,949.86 rows=4,298 width=20) (actual rows= loops=)

  • Hash Cond: ((s.annee)::double precision = ((round((random() * '50'::double precision)) + '1950'::double precision)))
7. 0.000 0.000 ↓ 0.0

Index Scan using stock_pkey on stock s (cost=0.42..55,609.20 rows=859,527 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

Hash (cost=66.15..66.15 rows=1,200 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using contenant_pkey on contenant c (cost=0.15..66.15 rows=1,200 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=334.96..334.96 rows=6,845 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using vin_pkey on vin v (cost=0.28..334.96 rows=6,845 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=18.93..18.93 rows=319 width=20) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using appellation_pkey on appellation a (cost=0.15..18.93 rows=319 width=20) (actual rows= loops=)