explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tnAj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,725.641 ↑ 1.0 621 1

Sort (cost=19,861,577.28..19,861,887.78 rows=621 width=101) (actual time=3,725.546..3,725.641 rows=621 loops=1)

2. 3,724.934 3,724.934 ↑ 1.0 621 1

Nested Loop Left Join (cost=31,969.87..19,855,815.36 rows=621 width=101) (actual time=9.689..3,724.934 rows=621 loops=1)

3. 0.730 0.730 ↑ 1.0 621 1

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

4. 3,722.895 3,722.895 ↓ 0.0 0 621

Limit (cost=31,969.87..31,970.87 rows=1 width=64) (actual time=5.995..5.995 rows=0 loops=621)

5. 3,722.274 3,722.274 ↓ 0.0 0 621

Sort (cost=31,969.87..31,970.87 rows=1 width=64) (actual time=5.994..5.994 rows=0 loops=621)

6. 3,719.790 3,719.790 ↓ 0.0 0 621

Index Scan using idx_execucao_executavel_id_idx on public.execucao (cost=86.00..31,967.87 rows=1 width=64) (actual time=5.990..5.990 rows=0 loops=621)

Planning time : 0.290 ms
Execution time : 3,725.732 ms