explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gxyf

Settings
# exclusive inclusive rows x rows loops node
1. 718.743 718.743 ↑ 100,000.0 10 1

Nested Loop Left Join (cost=2.30..1,407,406.60 rows=1,000,000 width=80) (actual time=83.888..718.743 rows=10 loops=1)