explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TXqU

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 36.418 ↓ 2.0 2 1

Bitmap Heap Scan on ip_nbr (cost=19.46..23.48 rows=1 width=79) (actual time=36.417..36.418 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=1
2. 0.009 36.390 ↓ 0.0 0 1

BitmapAnd (cost=19.46..19.46 rows=1 width=0) (actual time=36.390..36.390 rows=0 loops=1)

3. 0.003 18.716 ↓ 0.0 0 1

BitmapOr (cost=9.61..9.61 rows=104 width=0) (actual time=18.716..18.716 rows=0 loops=1)

4. 7.282 7.282 ↑ 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.282..7.282 rows=7 loops=1)

  • Index Cond: (node_ip_addr = '10.14.221.167'::inet)
5. 11.431 11.431 ↑ 15.2 4 1

Bitmap Index Scan on idx_ip_nbr_nbr_ip_addr_gist (cost=0.00..4.87 rows=61 width=0) (actual time=11.431..11.431 rows=4 loops=1)

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

BitmapOr (cost=9.61..9.61 rows=104 width=0) (actual time=17.665..17.665 rows=0 loops=1)

7. 7.035 7.035 ↑ 1.2 36 1

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

  • Index Cond: (node_ip_addr = '10.9.47.115'::inet)
8. 10.626 10.626 ↓ 1.6 98 1

Bitmap Index Scan on idx_ip_nbr_nbr_ip_addr_gist (cost=0.00..4.87 rows=61 width=0) (actual time=10.626..10.626 rows=98 loops=1)

  • Index Cond: (nbr_ip_addr = '10.9.47.115'::inet)
Planning time : 0.135 ms
Execution time : 36.499 ms