explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9e35

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

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

2. 200.243 200.243 ↓ 1.0 624 1

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

3. 0.189 0.189 ↓ 1.0 624 1

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

4. 199.929 199.929 ↓ 0.0 0 1

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

5. 199.928 199.928 ↓ 0.0 0 1

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

6. 199.928 199.928 ↓ 0.0 0 1

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

7. 199.927 199.927 ↓ 0.0 0 1

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

8. 218.262 218.262 ↓ 0.0 0 1

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

9. 963.465 963.465 ↓ 0.0 0 5

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

Planning time : 0.236 ms
Execution time : 218.790 ms