explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jVo0

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 174.494 ↑ 1.0 101 1

Limit (cost=21,470.99..21,471.25 rows=101 width=386) (actual time=174.480..174.494 rows=101 loops=1)

2. 8.500 174.481 ↑ 22.4 101 1

Sort (cost=21,470.99..21,476.64 rows=2,259 width=386) (actual time=174.476..174.481 rows=101 loops=1)

  • Sort Key: networkobj0_.display
  • Sort Method: top-N heapsort Memory: 51kB
3. 5.526 165.981 ↓ 7.1 16,096 1

Nested Loop (cost=5,956.12..21,384.49 rows=2,259 width=386) (actual time=65.337..165.981 rows=16,096 loops=1)

4. 0.489 65.229 ↓ 4.0 807 1

HashAggregate (cost=5,944.11..5,946.11 rows=200 width=4) (actual time=64.928..65.229 rows=807 loops=1)

  • Group Key: max(deviceconf1_.id)
5. 0.411 64.740 ↑ 1.1 807 1

HashAggregate (cost=5,923.93..5,932.90 rows=897 width=8) (actual time=64.630..64.740 rows=807 loops=1)

  • Group Key: deviceconf1_.mgmt_id
6. 0.366 64.329 ↓ 1.0 911 1

Hash Join (cost=2,970.94..5,919.44 rows=897 width=8) (actual time=61.636..64.329 rows=911 loops=1)

  • Hash Cond: (device2_.management_id = deviceconf1_.mgmt_id)
7. 62.679 63.350 ↑ 1.0 810 1

Bitmap Heap Scan on managements device2_ (cost=2,922.65..5,848.01 rows=810 width=4) (actual time=61.007..63.350 rows=810 loops=1)

  • Recheck Cond: ((management_type = ANY ('{Checkpoint,Cisco,Netscreen,Fortinet,PaloAltoNetworks,Stonesoft,Mcafee}'::text[])) OR (management_type = 'VMware'::text))
  • Filter: ((NOT to_be_deleted) AND (cp_type <> 'cp_mds'::text) AND (cp_type !~~ 'csm%'::text)AND ((virtual_type IS NULL) OR (virtual_type <> 'device'::text) OR ((virtual_type = 'device'::text) AND ((cp_type = 'Panorama'::text) OR (cp_type = 'fmg'::text) OR (cp_type = 'stonesoft_smc'::text)))) AND ((management_type = ANY ('{Checkpoint,Cisco,Netscreen,Fortinet,PaloAltoNetworks,Stonesoft,Mcafee}'::text[])) OR ((management_type = 'VMware'::text) AND (cp_type <> 'nsx_edge'::text))))
  • Rows Removed by Filter: 125
  • Heap Blocks: exact=174
8. 0.002 0.671 ↓ 0.0 0 1

BitmapOr (cost=2,922.65..2,922.65 rows=935 width=0) (actual time=0.671..0.671 rows=0 loops=1)

9. 0.669 0.669 ↑ 1.0 935 1

Bitmap Index Scan on managements_mgmt_type_index (cost=0.00..2,913.84 rows=935 width=0) (actual time=0.669..0.669 rows=935 loops=1)

  • Index Cond: (management_type = ANY ('{Checkpoint,Cisco,Netscreen,Fortinet,PaloAltoNetworks,Stonesoft,Mcafee}'::text[]))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on managements_mgmt_type_index (cost=0.00..8.41 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (management_type = 'VMware'::text)
11. 0.613 0.613 ↓ 1.0 1,041 1

Hash (cost=35.35..35.35 rows=1,035 width=8) (actual time=0.613..0.613 rows=1,041 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
  • -> Seq Scan on nst_configuration deviceconf1_ (cost=0.00..35.35 rows=1035 width=8) (actualtime=0.020..0.397 rows=1041 loops=1)
12. 74.244 95.226 ↓ 4.0 20 807

Bitmap Heap Scan on nst_netobjs networkobj0_ (cost=12.01..77.14 rows=5 width=386) (actual time=0.049..0.118 rows=20 loops=807)

  • Recheck Cond: (version_id = (max(deviceconf1_.id)))
  • Filter: ((NOT is_implicit) AND (ip_type <> ALL ('{IPV6,IPV4_IPV6}'::text[])) AND ((type_on_device <> ALL ('{netlink,Vnic,VirtualMachine,VirtualApp,ResourcePool,Datacenter,DistributedVirtualPortgroup,ClusterComputeResource,VirtualWire,VirtualNetwork,ALL_EDGES,APPLIED_TO_ANY,DISTRIBUTED_FIREWALL,Edge,HostSystem}'::text[])) OR (type_on_device IS NULL)) AND (lower(class) =ANY ('{gateway_ckp,host_ckp,connectra,interspect,gateway_cluster,cluster_member,sofaware_gateway,sofaware_gateway_profile,vsx_box,vs_cluster_member,vs_cluster_netobj,vsx_cluster_member,vsx_cluster_netobj,vs_netobj,mygw_EVR,vsx_netobj,embedded_device,host_plain,interface,network,network_object_group,group_with_exception,gsn_handover_group,address_range}'::text[])))
  • Rows Removed by Filter: 100
  • Heap Blocks: exact=5249
13. 20.982 20.982 ↑ 1.8 119 807

Bitmap Index Scan on nst_netobjs_version_id_idx (cost=0.00..12.01 rows=218 width=0) (actual time=0.026..0.026 rows=119 loops=807)

  • Index Cond: (version_id = (max(deviceconf1_.id)))
Planning time : 3.508 ms
Execution time : 174.791 ms