explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGgD

Settings
# exclusive inclusive rows x rows loops node
1. 10,746.071 10,746.071 ↑ 1.2 233 1

Unique (cost=12240.41..12259.66 rows=275 width=647) (actual time=10940.021..10940.021 rows=1 loops=1) CTE local_point -> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1) CTE potential_stores -> Nested Loop Left Join (cost=2537.41..8851.15 rows=285 width=1336) (actual time=10730.845..10937.252 rows=233 loops=1) InitPlan 6 (returns $8) -> CTE Scan on local_point (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1) -> Nested Loop Left Join (cost=2537.11..3625.45 rows=285 width=1315) (actual time=10729.747..10748.362 rows=233 loops=1) -> Nested Loop Left Join (cost=2,536.83..3,509.50 rows=285 width=1,229) (actual time=10,729.726..10,746.071 rows=233 loops=1)