explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4AL

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.045 ↑ 5,193.0 1 1

Bitmap Heap Scan on ip2location_asn (cost=152.53..9,005.99 rows=5,193 width=59) (actual time=0.045..0.045 rows=1 loops=1)

  • Recheck Cond: ((cidr)::inet >> '92.123.12.44'::inet)
  • Heap Blocks: exact=1
2. 0.037 0.037 ↑ 5,193.0 1 1

Bitmap Index Scan on cidr_spgist (cost=0.00..151.23 rows=5,193 width=0) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((cidr)::inet >> '92.123.12.44'::inet)
Planning time : 0.096 ms
Execution time : 0.083 ms