explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eeWa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 261.966 ↓ 1.0 624 1

Sort (cost=78,799.99..78,801.53 rows=616 width=100) (actual time=261.924..261.966 rows=624 loops=1)

2. 261.834 261.834 ↓ 1.0 624 1

Hash Left Join (cost=78,728.63..78,771.45 rows=616 width=100) (actual time=261.501..261.834 rows=624 loops=1)

3. 0.219 0.219 ↓ 1.0 624 1

Seq Scan on public.executavel (cost=0.00..40.50 rows=616 width=84) (actual time=0.012..0.219 rows=624 loops=1)

4. 261.479 261.479 ↓ 0.0 0 1

Hash (cost=78,728.62..78,728.62 rows=1 width=24) (actual time=261.479..261.479 rows=0 loops=1)

5. 261.479 261.479 ↓ 0.0 0 1

Subquery Scan on execucoes_sem_status (cost=78,728.59..78,728.62 rows=1 width=24) (actual time=261.479..261.479 rows=0 loops=1)

6. 261.477 261.477 ↓ 0.0 0 1

WindowAgg (cost=78,728.59..78,728.61 rows=1 width=72) (actual time=261.477..261.477 rows=0 loops=1)

7. 261.476 261.476 ↓ 0.0 0 1

Sort (cost=78,728.59..78,728.59 rows=1 width=24) (actual time=261.476..261.476 rows=0 loops=1)

8. 282.773 282.773 ↓ 0.0 0 1

Gather (cost=1,000.00..78,728.58 rows=1 width=24) (actual time=261.470..282.773 rows=0 loops=1)

9. 1,277.360 1,277.360 ↓ 0.0 0 5

Parallel Seq Scan on public.execucao (cost=0.00..77,728.48 rows=1 width=24) (actual time=255.472..255.472 rows=0 loops=5)

Planning time : 0.450 ms
Execution time : 283.368 ms