explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WKnw

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

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

2. 149.666 149.666 ↓ 1.0 624 1

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

3. 0.228 0.228 ↓ 1.0 624 1

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

4. 149.283 149.283 ↓ 0.0 0 1

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

5. 149.282 149.282 ↓ 0.0 0 1

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

6. 149.281 149.281 ↓ 0.0 0 1

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

7. 149.279 149.279 ↓ 0.0 0 1

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

8. 169.102 169.102 ↓ 0.0 0 1

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

9. 708.975 708.975 ↓ 0.0 0 5

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

Planning time : 0.555 ms
Execution time : 169.763 ms