explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jWzy

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

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

2. 154.250 154.250 ↓ 1.0 624 1

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

3. 0.289 0.289 ↓ 1.0 624 1

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

4. 153.784 153.784 ↓ 0.0 0 1

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

5. 153.784 153.784 ↓ 0.0 0 1

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

6. 153.784 153.784 ↓ 0.0 0 1

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

7. 153.780 153.780 ↓ 0.0 0 1

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

8. 173.197 173.197 ↓ 0.0 0 1

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

9. 733.025 733.025 ↓ 0.0 0 5

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

Planning time : 0.595 ms
Execution time : 174.013 ms