explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gVs

Settings
# exclusive inclusive rows x rows loops node
1. 26.551 884.939 ↑ 1.0 16,269 1

Finalize HashAggregate (cost=66,838.01..67,163.39 rows=16,269 width=48) (actual time=882.242..884.939 rows=16,269 loops=1)

  • Group Key: ((((s.annee)::text || ' - '::text) || a.libelle))
  • Planning Time: 1.263 ms
  • Execution Time: 886.372 ms
2.          

Initplan (forFinalize HashAggregate)

3. 0.422 0.422 ↑ 1,000.0 1 1

Function Scan on generate_series (cost=0.00..10.00 rows=1,000 width=0) (actual time=0.422..0.422 rows=1 loops=1)

4. 15.328 857.966 ↓ 1.5 48,800 1

Gather (cost=63,014.78..66,593.96 rows=32,538 width=48) (actual time=846.155..857.966 rows=48,800 loops=1)

  • Workers Planned: 2
  • Params Evaluated: $0
  • Workers Launched: 2
5. 155.709 842.638 ↑ 1.0 16,267 3

Partial HashAggregate (cost=62,014.78..62,340.16 rows=16,269 width=48) (actual time=837.752..842.638 rows=16,267 loops=3)

  • Group Key: (((s.annee)::text || ' - '::text) || a.libelle)
6. 127.030 686.929 ↑ 1.2 286,509 3

Result (cost=525.02..57,538.08 rows=358,136 width=40) (actual time=5.329..686.929 rows=286,509 loops=3)

  • One-Time Filter: $0
7. 100.157 559.899 ↑ 1.2 286,509 3

Hash Left Join (cost=525.02..53,956.72 rows=358,136 width=28) (actual time=5.321..559.899 rows=286,509 loops=3)

  • Hash Cond: (v.appellation_id = a.id)
8. 102.137 459.514 ↑ 1.2 286,509 3

Hash Join (cost=502.10..52,981.20 rows=358,136 width=16) (actual time=5.077..459.514 rows=286,509 loops=3)

  • Hash Cond: (s.vin_id = v.id)
9. 352.398 352.425 ↑ 1.2 286,509 3

Hash Join (cost=81.58..51,620.00 rows=358,136 width=16) (actual time=0.091..352.425 rows=286,509 loops=3)

  • Hash Cond: (s.contenant_id = c.id)
  • -> Parallel Index Scan using stock_pkey on stock s (cost=0.42..50595.42 rows=358136 width=16) (actual time=0.023..229.387 rows=286509
10. 0.011 0.027 ↑ 400.0 3 3

Hash (cost=66.15..66.15 rows=1,200 width=8) (actual time=0.026..0.027 rows=3 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
11. 0.016 0.016 ↑ 400.0 3 3

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

12. 1.994 4.952 ↑ 1.1 6,057 3

Hash (cost=334.96..334.96 rows=6,845 width=8) (actual time=4.952..4.952 rows=6,057 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 301kB
13. 2.958 2.958 ↑ 1.1 6,057 3

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

14. 0.099 0.228 ↑ 1.0 319 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
15. 0.129 0.129 ↑ 1.0 319 3

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