explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JXKr

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 132.951 ↓ 2.0 2 1

Bitmap Heap Scan on ip_nbr (cost=66.35..70.37 rows=1 width=71) (actual time=132.948..132.951 rows=2 loops=1)

  • Recheck Cond: (((node_ip_addr = '10.14.221.167'::inet) OR (nbr_ip_addr = '10.14.221.167'::inet)) AND ((node_ip_addr = '10.9.47.115'::inet) OR (nbr_ip_addr = '10.9.47.115'::inet)))
  • Heap Blocks: exact=2
2. 0.008 132.938 ↓ 0.0 0 1

BitmapAnd (cost=66.35..66.35 rows=1 width=0) (actual time=132.938..132.938 rows=0 loops=1)

3. 0.003 69.019 ↓ 0.0 0 1

BitmapOr (cost=33.05..33.05 rows=1,095 width=0) (actual time=69.019..69.019 rows=0 loops=1)

4. 44.326 44.326 ↑ 38.5 10 1

Bitmap Index Scan on idx_ip_nbr_node_ip_addr_gist (cost=0.00..11.30 rows=385 width=0) (actual time=44.326..44.326 rows=10 loops=1)

  • Index Cond: (node_ip_addr = '10.14.221.167'::inet)
5. 24.690 24.690 ↑ 236.7 3 1

Bitmap Index Scan on idx_ip_nbr_nbr_ip_addr_gist (cost=0.00..21.74 rows=710 width=0) (actual time=24.690..24.690 rows=3 loops=1)

  • Index Cond: (nbr_ip_addr = '10.14.221.167'::inet)
6. 0.003 63.911 ↓ 0.0 0 1

BitmapOr (cost=33.05..33.05 rows=1,095 width=0) (actual time=63.911..63.911 rows=0 loops=1)

7. 39.211 39.211 ↑ 10.7 36 1

Bitmap Index Scan on idx_ip_nbr_node_ip_addr_gist (cost=0.00..11.30 rows=385 width=0) (actual time=39.211..39.211 rows=36 loops=1)

  • Index Cond: (node_ip_addr = '10.9.47.115'::inet)
8. 24.697 24.697 ↑ 4.3 166 1

Bitmap Index Scan on idx_ip_nbr_nbr_ip_addr_gist (cost=0.00..21.74 rows=710 width=0) (actual time=24.697..24.697 rows=166 loops=1)

  • Index Cond: (nbr_ip_addr = '10.9.47.115'::inet)
Planning time : 0.150 ms
Execution time : 133.044 ms