explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pq3k

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,266.063 ↑ 1.0 621 1

Sort (cost=2,446,725.41..2,447,035.91 rows=621 width=101) (actual time=2,265.987..2,266.063 rows=621 loops=1)

2. 2,265.720 2,265.720 ↑ 1.0 621 1

Hash Left Join (cost=2,439,210.75..2,440,963.50 rows=621 width=101) (actual time=2,265.143..2,265.720 rows=621 loops=1)

3. 0.358 0.358 ↑ 1.0 621 1

Seq Scan on public.executavel (cost=0.00..1,286.50 rows=621 width=85) (actual time=0.007..0.358 rows=621 loops=1)

4. 2,265.115 2,265.115 ↓ 0.0 0 1

Hash (cost=2,439,209.75..2,439,209.75 rows=1 width=24) (actual time=2,265.114..2,265.115 rows=0 loops=1)

5. 2,265.112 2,265.112 ↓ 0.0 0 1

Subquery Scan on execucoes_sem_status (cost=2,439,205.75..2,439,209.75 rows=1 width=24) (actual time=2,265.112..2,265.112 rows=0 loops=1)

6. 2,265.111 2,265.111 ↓ 0.0 0 1

WindowAgg (cost=2,439,205.75..2,439,208.75 rows=1 width=72) (actual time=2,265.111..2,265.111 rows=0 loops=1)

7. 2,265.108 2,265.108 ↓ 0.0 0 1

Sort (cost=2,439,205.75..2,439,206.75 rows=1 width=24) (actual time=2,265.108..2,265.108 rows=0 loops=1)

8. 2,268.369 2,268.369 ↓ 0.0 0 1

Gather (cost=1,000.00..2,439,203.75 rows=1 width=24) (actual time=2,265.076..2,268.369 rows=0 loops=1)

9. 4,520.592 4,520.592 ↓ 0.0 0 2

Parallel Seq Scan on public.execucao (cost=0.00..2,438,203.65 rows=1 width=24) (actual time=2,260.296..2,260.296 rows=0 loops=2)

Planning time : 11.714 ms
Execution time : 2,269.518 ms