explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EECO

Settings
# exclusive inclusive rows x rows loops node
1. 88.899 35,846.290 ↑ 5.3 18 1

Gather Merge (cost=612,226.72..612,237.92 rows=96 width=48) (actual time=35,839.048..35,846.290 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.217 35,757.391 ↑ 8.0 6 3 / 3

Sort (cost=611,226.70..611,226.82 rows=48 width=48) (actual time=35,757.383..35,757.391 rows=6 loops=3)

  • Sort Key: res.analyz, res.dhresultat DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
3. 16,383.697 35,757.174 ↑ 8.0 6 3 / 3

Hash Join (cost=51.08..611,225.36 rows=48 width=48) (actual time=31,967.329..35,757.174 rows=6 loops=3)

  • Hash Cond: ((res.numtube)::text = (tub.numtube)::text)
4. 19,373.241 19,373.241 ↑ 1.2 8,197,118 3 / 3

Parallel Seq Scan on resjour_tout res (cost=0.00..572,753.85 rows=10,245,285 width=43) (actual time=0.364..19,373.241 rows=8,197,118 loops=3)

5. 0.033 0.236 ↑ 9.5 2 3 / 3

Hash (cost=50.84..50.84 rows=19 width=27) (actual time=0.234..0.236 rows=2 loops=3)

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

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

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