explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uWNO

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

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

2. 666.061 666.061 ↓ 1.0 624 1

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

3. 0.336 0.336 ↓ 1.0 624 1

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

4. 665.184 665.184 ↓ 0.0 0 624

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

5. 665.184 665.184 ↓ 0.0 0 624

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

6. 663.312 663.312 ↓ 0.0 0 624

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

7. 81.120 81.120 ↑ 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.130..0.130 rows=1,441 loops=624)

Planning time : 0.357 ms
Execution time : 666.471 ms