explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gedi

Settings
# exclusive inclusive rows x rows loops node
1. 102.379 51,670.814 ↑ 5.3 18 1

Gather Merge (cost=612,226.72..612,237.92 rows=96 width=48) (actual time=51,663.871..51,670.814 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
2. 0.151 51,568.435 ↑ 5.3 9 2 / 2

Sort (cost=611,226.70..611,226.82 rows=48 width=48) (actual time=51,568.422..51,568.435 rows=9 loops=2)

  • Sort Key: res.analyz, res.dhresultat DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
3. 22,474.519 51,568.284 ↑ 5.3 9 2 / 2

Hash Join (cost=51.08..611,225.36 rows=48 width=48) (actual time=10,261.992..51,568.284 rows=9 loops=2)

  • Hash Cond: ((res.numtube)::text = (tub.numtube)::text)
4. 29,093.498 29,093.498 ↓ 1.2 12,295,677 2 / 2

Parallel Seq Scan on resjour_tout res (cost=0.00..572,753.85 rows=10,245,285 width=43) (actual time=0.230..29,093.498 rows=12,295,677 loops=2)

5. 0.081 0.267 ↑ 9.5 2 2 / 2

Hash (cost=50.84..50.84 rows=19 width=27) (actual time=0.265..0.267 rows=2 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.186 0.186 ↑ 9.5 2 2 / 2

Index Scan using idx_tubejour_tout5 on tubejour_tout tub (cost=0.43..50.84 rows=19 width=27) (actual time=0.153..0.186 rows=2 loops=2)

  • Index Cond: ((numpermanent)::text = 'B8030209156-50'::text)