explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uk3F

Settings
# exclusive inclusive rows x rows loops node
1. 10,940.021 10,940.021 ↑ 275.0 1 1

Unique (cost=12,240.41..12,259.66 rows=275 width=647) (actual time=10,940.021..10,940.021 rows=1 loops=1)

2.          

CTE local_point

3. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

4.          

CTE potential_stores

5. 10,937.248 10,937.252 ↑ 1.2 233 1

Nested Loop Left Join (cost=2,537.41..8,851.15 rows=285 width=1,336) (actual time=10,730.845..10,937.252 rows=233 loops=1)

6.          

Initplan (for Nested Loop Left Join)

7. 0.000 0.004 ↑ 1.0 1 1

CTE Scan on local_point (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)

8. 2.291 10,748.362 ↑ 1.2 233 1

Nested Loop Left Join (cost=2,537.11..3,625.45 rows=285 width=1,315) (actual time=10,729.747..10,748.362 rows=233 loops=1)

9. 2.246 10,746.071 ↑ 1.2 233 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)

10. 2.211 10,743.825 ↑ 1.2 233 1

Nested Loop (cost=2,536.54..3,411.41 rows=285 width=1,225) (actual time=10,729.671..10,743.825 rows=233 loops=1)

11. 10,734.728 10,741.614 ↑ 1.2 233 1

Hash Join (cost=2,536.26..3,303.32 rows=285 width=1,173) (actual time=10,729.636..10,741.614 rows=233 loops=1)

  • Hash Cond: (ns.store_id = sts.store_id)
12. 6.886 6.886 ↑ 1.0 14,541 1

Seq Scan on nrs_stores ns (cost=0.00..709.61 rows=14,561 width=628) (actual time=0.017..6.886 rows=14,541 loops=1)