explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x7OM

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

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

2. 654.587 654.587 ↓ 1.0 624 1

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

3. 0.346 0.346 ↓ 1.0 624 1

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

4. 653.952 653.952 ↓ 0.0 0 624

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

5. 653.328 653.328 ↓ 0.0 0 624

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

6. 652.080 652.080 ↓ 0.0 0 624

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

7. 80.496 80.496 ↑ 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.129..0.129 rows=1,441 loops=624)

Planning time : 0.367 ms
Execution time : 654.952 ms