explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Zfz

Settings
# exclusive inclusive rows x rows loops node
1. 84.039 33,549.567 ↑ 134.7 18 1

Gather Merge (cost=600,777.41..601,060.23 rows=2,424 width=48) (actual time=33,539.477..33,549.567 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.211 33,465.528 ↑ 202.0 6 3 / 3

Sort (cost=599,777.39..599,780.42 rows=1,212 width=48) (actual time=33,465.510..33,465.528 rows=6 loops=3)

  • Sort Key: res.analyz, res.dhresultat DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
3. 15,370.926 33,465.317 ↑ 202.0 6 3 / 3

Hash Semi Join (cost=51.08..599,715.31 rows=1,212 width=48) (actual time=26,775.075..33,465.317 rows=6 loops=3)

  • Hash Cond: ((res.numtube)::text = (tubejour_tout.numtube)::text)
4. 18,094.189 18,094.189 ↑ 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.236..18,094.189 rows=8,197,118 loops=3)

5. 0.027 0.202 ↑ 9.5 2 3 / 3

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

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

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

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