explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xq2r

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 7.641 ↑ 6.1 7 1

Bitmap Heap Scan on ip_nbr (cost=4.75..172.45 rows=43 width=79) (actual time=7.617..7.641 rows=7 loops=1)

  • Recheck Cond: (node_ip_addr = '10.14.221.167'::inet)
  • Heap Blocks: exact=7
  • Buffers: shared hit=843
2. 7.605 7.605 ↑ 6.1 7 1

Bitmap Index Scan on idx_ip_nbr_node_ip_addr_gist (cost=0.00..4.73 rows=43 width=0) (actual time=7.605..7.605 rows=7 loops=1)

  • Index Cond: (node_ip_addr = '10.14.221.167'::inet)
  • Buffers: shared hit=836
Planning time : 0.100 ms
Execution time : 7.690 ms