explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dxwW

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

Sort (cost=15,610,630.05..15,610,631.59 rows=616 width=100) (actual time=773.693..773.735 rows=624 loops=1)

2. 773.362 773.362 ↓ 1.0 624 1

Nested Loop Left Join (cost=25,341.79..15,610,601.50 rows=616 width=100) (actual time=7.080..773.362 rows=624 loops=1)

3. 0.433 0.433 ↓ 1.0 624 1

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

4. 772.512 772.512 ↓ 0.0 0 624

Limit (cost=25,341.79..25,341.80 rows=1 width=64) (actual time=1.238..1.238 rows=0 loops=624)

5. 771.888 771.888 ↓ 0.0 0 624

Sort (cost=25,341.79..25,341.80 rows=1 width=64) (actual time=1.237..1.237 rows=0 loops=624)

6. 770.016 770.016 ↓ 0.0 0 624

Bitmap Heap Scan on public.execucao (cost=173.33..25,341.78 rows=1 width=64) (actual time=1.234..1.234 rows=0 loops=624)

7. 110.448 110.448 ↑ 6.4 1,441 624

Bitmap Index Scan on idx_execucao_executavel_id_idx (cost=0.00..173.33 rows=9,187 width=0) (actual time=0.177..0.177 rows=1,441 loops=624)

Planning time : 0.529 ms
Execution time : 773.821 ms