explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cMm

Settings
# exclusive inclusive rows x rows loops node
1. 0.942 873,659.916 ↑ 3.2 294 1

Unique (cost=71,553,103.87..71,553,110.98 rows=948 width=56) (actual time=873,658.377..873,659.916 rows=294 loops=1)

2. 8.531 873,658.974 ↓ 6.3 6,003 1

Sort (cost=71,553,103.87..71,553,106.24 rows=948 width=56) (actual time=873,658.355..873,658.974 rows=6,003 loops=1)

  • Sort Key: g.latitude, g.longitude
  • Sort Method: quicksort Memory: 1037kB
3. 375,825.600 873,650.443 ↓ 6.3 6,003 1

Nested Loop Left Join (cost=12.17..71,553,056.99 rows=948 width=56) (actual time=1.456..873,650.443 rows=6,003 loops=1)

  • Join Filter: (a.network && g.network)
  • Rows Removed by Join Filter: 3025007415
4. 5.438 5.701 ↑ 1.1 837 1

Bitmap Heap Scan on n_asn a (cost=12.17..921.49 rows=948 width=32) (actual time=0.346..5.701 rows=837 loops=1)

  • Recheck Cond: (autonomous_system_number = 4837)
  • Heap Blocks: exact=250
5. 0.263 0.263 ↑ 1.1 837 1

Bitmap Index Scan on n_asn_autonomous_system_number_idx (cost=0.00..11.93 rows=948 width=0) (actual time=0.262..0.263 rows=837 loops=1)

  • Index Cond: (autonomous_system_number = 4837)
6. 497,006.958 497,819.142 ↑ 1.0 3,614,114 837

Materialize (cost=0.00..113,850.71 rows=3,614,114 width=24) (actual time=0.005..594.766 rows=3,614,114 loops=837)

7. 812.184 812.184 ↑ 1.0 3,614,114 1

Seq Scan on n_geo_ip g (cost=0.00..74,603.14 rows=3,614,114 width=24) (actual time=0.042..812.184 rows=3,614,114 loops=1)