explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vnGVE

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 7.382 ↓ 0.0 0 1

Nested Loop (cost=2,442.16..390,070.77 rows=1 width=8) (actual time=7.382..7.382 rows=0 loops=1)

2. 3.430 3.494 ↑ 59.0 3 1

Bitmap Heap Scan on nst_netobjs objects (cost=2,441.87..388,092.80 rows=177 width=8) (actual time=0.262..3.494 rows=3 loops=1)

  • Recheck Cond: (version_id = ANY ('{591840,591843,413678}'::integer[]))
  • Filter: ((getipafternetmask(host(ip), netmask) >>= getipafternetmask('138.190.252.192'::text, '255.255.255.224'::text)) OR (class = 'any_object'::text))
  • Rows Removed by Filter: 69
  • Heap Blocks: exact=7
3. 0.064 0.064 ↑ 1,296.5 72 1

Bitmap Index Scan on nst_netobjs_version_id_idx (cost=0.00..2,441.82 rows=93,349 width=0) (actual time=0.064..0.064 rows=72 loops=1)

  • Index Cond: (version_id = ANY ('{591840,591843,413678}'::integer[]))
4. 3.882 3.882 ↓ 0.0 0 3

Index Scan using nst_nat_rule_dst_orig_networks_obj_id_idx on nst_nat_rule_orig_dst_networks virtual_ips (cost=0.29..11.15 rows=2 width=16) (actual time=1.294..1.294 rows=0 loops=3)

  • Index Cond: (obj_id = objects.id)