explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U2D4W

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

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

2. 165.836 165.836 ↓ 1.0 624 1

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

3. 0.233 0.233 ↓ 1.0 624 1

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

4. 165.460 165.460 ↓ 0.0 0 1

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

5. 165.460 165.460 ↓ 0.0 0 1

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

6. 165.459 165.459 ↓ 0.0 0 1

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

7. 165.457 165.457 ↓ 0.0 0 1

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

8. 185.492 185.492 ↓ 0.0 0 1

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

9. 792.285 792.285 ↓ 0.0 0 5

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

Planning time : 0.487 ms
Execution time : 186.146 ms