explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zIkU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Merge (cost=612,238.04..612,249.24 rows=96 width=48) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Sort (cost=611,238.02..611,238.14 rows=48 width=48) (actual rows= loops=)

  • Sort Key: res.analyz, res.dhresultat DESC
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=51.08..611,236.68 rows=48 width=48) (actual rows= loops=)

  • Hash Cond: ((res.numtube)::text = (tub.numtube)::text)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on resjour_tout res (cost=0.00..572,762.08 rows=10,246,108 width=43) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=50.84..50.84 rows=19 width=27) (actual rows= loops=)

  • -> Index Scan using idx_tubejour_tout5 on tubejour_tout tub (cost=0.43..50.84 rows=19 width=27)" Index Cond: ((numpermanent)::text = 'B8030209156-50'::text)