explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCM2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,156.768 ↑ 1.0 621 1

Sort (cost=20,571,569.20..20,571,879.70 rows=621 width=93) (actual time=4,156.654..4,156.768 rows=621 loops=1)

2. 4,154.965 4,154.965 ↑ 1.0 621 1

Nested Loop Left Join (cost=33,113.67..20,565,807.28 rows=621 width=93) (actual time=5.160..4,154.965 rows=621 loops=1)

3. 0.747 0.747 ↑ 1.0 621 1

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

4. 4,137.102 4,137.102 ↑ 1.0 1 621

Aggregate (cost=33,113.67..33,114.17 rows=1 width=8) (actual time=6.662..6.662 rows=1 loops=621)

5. 3,632.229 3,632.229 ↑ 1.5 1,481 621

Index Scan using idx_execucao_executavel_id_idx on public.execucao (cost=86.00..31,974.67 rows=2,278 width=8) (actual time=0.007..5.849 rows=1,481 loops=621)

Planning time : 0.355 ms
Execution time : 4,156.872 ms