explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 76kI

Settings
# exclusive inclusive rows x rows loops node
1. 0.869 569,317.965 ↑ 2.1 294 1

Unique (cost=51,468,256.89..51,468,261.55 rows=621 width=56) (actual time=569,316.462..569,317.965 rows=294 loops=1)

2. 6.061 569,317.096 ↓ 9.7 6,003 1

Sort (cost=51,468,256.89..51,468,258.44 rows=621 width=56) (actual time=569,316.460..569,317.096 rows=6,003 loops=1)

  • Sort Key: g.latitude, g.longitude
  • Sort Method: quicksort Memory: 1037kB
3. 358,754.406 569,311.035 ↓ 9.7 6,003 1

Nested Loop (cost=12.17..51,468,228.08 rows=621 width=56) (actual time=168.117..569,311.035 rows=6,003 loops=1)

  • Join Filter: (a.network && g.network)
  • Rows Removed by Join Filter: 3025007415
4. 938.017 938.017 ↑ 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.104..938.017 rows=3,614,114 loops=1)

5. 209,616.370 209,618.612 ↑ 1.1 837 3,614,114

Materialize (cost=12.17..926.23 rows=948 width=32) (actual time=0.000..0.058 rows=837 loops=3,614,114)

6. 1.930 2.242 ↑ 1.1 837 1

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

  • Recheck Cond: (autonomous_system_number = 4837)
  • Heap Blocks: exact=250
7. 0.312 0.312 ↑ 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.312..0.312 rows=837 loops=1)

  • Index Cond: (autonomous_system_number = 4837)