explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QVZc

Settings
# exclusive inclusive rows x rows loops node
1. 102.173 34,969.716 ↑ 5.3 18 1

Gather Merge (cost=612,238.04..612,249.24 rows=96 width=48) (actual time=34,960.756..34,969.716 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.518 34,867.543 ↑ 8.0 6 3 / 3

Sort (cost=611,238.02..611,238.14 rows=48 width=48) (actual time=34,867.531..34,867.543 rows=6 loops=3)

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

Hash Join (cost=51.08..611,236.68 rows=48 width=48) (actual time=13,068.648..34,867.025 rows=6 loops=3)

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

Parallel Seq Scan on resjour_tout res (cost=0.00..572,762.08 rows=10,246,108 width=43) (actual time=0.600..18,811.185 rows=8,197,118 loops=3)

5. 0.038 0.304 ↑ 9.5 2 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.266 0.266 ↑ 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.240..0.266 rows=2 loops=3)

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