explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I32C

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 802.924 ↑ 1.0 621 1

Sort (cost=19,860,335.28..19,860,645.78 rows=621 width=93) (actual time=802.854..802.924 rows=621 loops=1)

2. 802.448 802.448 ↑ 1.0 621 1

Nested Loop Left Join (cost=31,968.37..19,854,573.36 rows=621 width=93) (actual time=5.099..802.448 rows=621 loops=1)

3. 0.535 0.535 ↑ 1.0 621 1

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

4. 801.090 801.090 ↑ 1.0 1 621

Aggregate (cost=31,968.37..31,968.87 rows=1 width=8) (actual time=1.290..1.290 rows=1 loops=621)

5. 801.090 801.090 ↓ 0.0 0 621

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

Planning time : 0.430 ms
Execution time : 803.061 ms