explain.depesz.com

PostgreSQL's explain analyze made readable

Result: epAc

Settings
# exclusive inclusive rows x rows loops node
1. 1,622.274 8,574.165 ↓ 300,000.0 300,000 1

Limit (cost=7.04..593.51 rows=1 width=680) (actual time=19.787..8,574.165 rows=300,000 loops=1)

2. 2,202.660 6,951.891 ↓ 300,000.0 300,000 1

Nested Loop (cost=6.76..589.67 rows=1 width=507) (actual time=19.742..6,951.891 rows=300,000 loops=1)

3. 4,749.231 4,749.231 ↓ 300,000.0 300,000 1

Nested Loop (cost=6.33..581.22 rows=1 width=538) (actual time=19.711..4,749.231 rows=300,000 loops=1)