explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RPDZ

Settings
# exclusive inclusive rows x rows loops node
1. 24.685 962.958 ↑ 1.0 16,269 1

Finalize HashAggregate (cost=41,254.82..41,580.20 rows=16,269 width=48) (actual time=959.914..962.958 rows=16,269 loops=1)

  • Group Key: ((((s.annee)::text || ' - '::text) || a.libelle))
  • Planning Time: 1.133 ms
  • Execution Time: 964.240 ms
2. 10.520 938.273 ↓ 1.5 48,758 1

Gather (cost=37,431.60..41,010.78 rows=32,538 width=48) (actual time=926.951..938.273 rows=48,758 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 157.519 927.753 ↑ 1.0 16,253 3

Partial HashAggregate (cost=36,431.60..36,756.98 rows=16,269 width=48) (actual time=922.658..927.753 rows=16,253 loops=3)

  • Group Key: (((s.annee)::text || ' - '::text) || a.libelle)
4. 194.631 770.234 ↑ 1.2 286,509 3

Hash Left Join (cost=525.02..31,954.90 rows=358,136 width=40) (actual time=4.602..770.234 rows=286,509 loops=3)

  • Hash Cond: (v.appellation_id = a.id)
5. 123.329 575.374 ↑ 1.2 286,509 3

Hash Join (cost=502.10..27,398.02 rows=358,136 width=16) (actual time=4.351..575.374 rows=286,509 loops=3)

  • Hash Cond: (s.vin_id = v.id)
6. 132.637 447.902 ↑ 1.2 286,509 3

Hash Join (cost=81.58..26,036.81 rows=358,136 width=16) (actual time=0.175..447.902 rows=286,509 loops=3)

  • Hash Cond: (s.contenant_id = c.id)
7. 315.232 315.232 ↑ 1.2 286,509 3

Parallel Index Scan using stk_anne on stock s (cost=0.42..25,012.24 rows=358,136 width=16) (actual time=0.093..315.232 rows=286,509 loops=3)

  • Index Cond: (annee <= 2000)
8. 0.011 0.033 ↑ 400.0 3 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
9. 0.022 0.022 ↑ 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.018..0.022 rows=3 loops=3)

10. 1.657 4.143 ↑ 1.1 6,057 3

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

  • Buckets: 8192 Batches: 1 Memory Usage: 301kB
11. 2.486 2.486 ↑ 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.028..2.486 rows=6,057 loops=3)

12. 0.100 0.229 ↑ 1.0 319 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
13. 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.017..0.129 rows=319 loops=3)