explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TMMI

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 6.630 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.84..202.69 rows=5 width=1,062) (actual time=6.622..6.630 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, migration_session.state, CASE WHEN (internal_volume.is_importing IS NULL) THEN false ELSE internal_volume.is_importing END, volume_group_membership.volume_group_id, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, protection_policy.is_replica, internal_volume.is_replication_destination, volume_group.protection_policy_id, volume_group_policy.name, volume_group_policy.is_replica, protection_policy.name, COALESCE((snap_count_info.count)::integer, 0), policy_replication_rule_association.replication_rule_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, internal_volume.type, performance_policy.name, internal_volume.size, COALESCE(smv.logical_used, '0'::bigint),
  • COALESCE(smv.thin_savings, '0'::real), COALESCE(smvf.unique_physical_used, '0'::bigint), COALESCE(smvf.snapshot_savings, '0'::numeric), COALESCE(smvf.snap_clone_logical_used, '0'::bigint), COALESCE(perfmetrics.total_bandwidth, '0'::real), COALESCE(perfmetrics.total_iops, '0'::real), COALESCE(perfmetrics.avg_latency, '0'::real), internal_volume.appliance_id, appliance.name, internal_volume.creation_timestamp, protection_data.source_timestamp, COALESCE((mapped_host_info.count)::integer, 0), volume_group.name
  • Inner Unique: true
  • Join Filter: (mapped_host_info.volume_id = internal_volume.id)
  • protection_policy.name, performance_policy.name, volume_group_policy.name, volume_group_policy.is_replica, policy_replication_rule_association.replication_rule_id, snap_count_info.count
  • protection_policy.name, performance_policy.name, volume_group_policy.name, volume_group_policy.is_replica, policy_replication_rule_association.replication_rule_id
  • protection_policy.name, performance_policy.name, policy_replication_rule_association.replication_rule_id
  • protection_policy.name, policy_replication_rule_association.replication_rule_id
  • policy_replication_rule_association.replication_rule_id
  • internal_volume.nsid, internal_volume.nguid, internal_volume.is_faulted, internal_volume.dummy
  • replication_session.next_sync_timestamp, replication_session.failover_test_in_progress
  • internal_volume_1.nsid, internal_volume_1.nguid, internal_volume_1.is_faulted, internal_volume_1.dummy
2. 0.000 6.622 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.69..194.40 rows=5 width=1,054) (actual time=6.615..6.622 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used, protection_policy.is_replica,
  • Inner Unique: true
  • Join Filter: (snap_count_info.source_id = internal_volume.id)
3. 0.002 6.615 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.42..177.97 rows=5 width=1,046) (actual time=6.608..6.615 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used, protection_policy.is_replica,
  • Inner Unique: true
4. 0.002 6.610 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.29..177.03 rows=5 width=1,040) (actual time=6.603..6.610 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used, protection_policy.is_replica,
  • Inner Unique: true
  • Join Filter: (performance_policy.id = internal_volume.performance_policy_id)
  • Rows Removed by Join Filter: 1
5. 0.003 6.604 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.29..175.81 rows=5 width=1,035) (actual time=6.597..6.604 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used, protection_policy.is_replica,
  • Inner Unique: true
  • Join Filter: (protection_policy.id = internal_volume.protection_policy_id)
  • Rows Removed by Join Filter: 3
6. 0.003 6.586 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.29..174.55 rows=5 width=1,029) (actual time=6.580..6.586 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used,
7. 0.002 3.800 ↑ 5.0 1 1

Nested Loop Left Join (cost=69.04..99.25 rows=5 width=985) (actual time=3.794..3.800 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, smv.logical_used, smv.thin_savings, policy_replication_rule_association.replication_rule_id
  • Inner Unique: true
  • Join Filter: (smv.volume_id = internal_volume.id)
8. 0.017 3.771 ↑ 5.0 1 1

Hash Right Join (cost=68.63..90.74 rows=5 width=973) (actual time=3.765..3.771 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency, policy_replication_rule_association.replication_rule_id
  • Hash Cond: (policy_replication_rule_association.policy_id = internal_volume.protection_policy_id)
9. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on managementmodel.policy_replication_rule_association (cost=0.00..18.80 rows=880 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: policy_replication_rule_association.policy_id, policy_replication_rule_association.replication_rule_id
10. 0.007 3.750 ↑ 5.0 1 1

Hash (cost=68.57..68.57 rows=5 width=941) (actual time=3.750..3.750 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.003 3.743 ↑ 5.0 1 1

Nested Loop Left Join (cost=1.38..68.57 rows=5 width=941) (actual time=3.737..3.743 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name, perfmetrics.total_bandwidth, perfmetrics.total_iops, perfmetrics.avg_latency
12. 0.003 0.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..53.27 rows=1 width=929) (actual time=0.067..0.072 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id, volume_group.protection_policy_id, volume_group.name
  • Inner Unique: true
13. 0.002 0.060 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..44.93 rows=1 width=880) (actual time=0.055..0.060 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, migration_session.state, volume_group_membership.volume_group_id
  • Inner Unique: true
  • Join Filter: ((migration_session.id)::text = (internal_volume.migration_session_id)::text)
14. 0.002 0.057 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..34.03 rows=1 width=606) (actual time=0.053..0.057 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name, volume_group_membership.volume_group_id
  • Inner Unique: true
  • Join Filter: (volume_group_membership.volume_id = internal_volume.id)
15. 0.002 0.043 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..25.72 rows=1 width=569) (actual time=0.039..0.043 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp, appliance.name
  • Inner Unique: true
  • Join Filter: (appliance.id = internal_volume.appliance_id)
  • Rows Removed by Join Filter: 1
16. 0.001 0.035 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..24.65 rows=1 width=546) (actual time=0.031..0.035 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp
  • Join Filter: (internal_volume.id = replication_session.local_resource_id)
17. 0.002 0.031 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.43..16.48 rows=1 width=546) (actual time=0.028..0.031 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.migration_session_id, internal_volume.is_importing, internal_volume.description, internal_volume.size, internal_volume.performance_policy_id, internal_volume.protection_policy_id, internal_volume.is_replication_destination, internal_volume.type, internal_volume.appliance_id, internal_volume.creation_timestamp, internal_volume.datapath_family_id, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.source_timestamp
  • Join Filter: (protection_data.volume_id = internal_volume.id)
18. 0.026 0.026 ↑ 1.0 1 1

Index Scan using internal_volume_pkey on internal.internal_volume (cost=0.28..8.31 rows=1 width=442) (actual time=0.023..0.026 rows=1 loops=1)

  • Output: internal_volume.id, internal_volume.wwn, internal_volume.name, internal_volume.description, internal_volume.type, internal_volume.appliance_id, internal_volume.is_read_only, internal_volume.state, internal_volume.size, internal_volume.platform_volume_id, internal_volume.import_metadata, internal_volume.creation_timestamp, internal_volume.protection_policy_id, internal_volume.performance_policy_id, internal_volume.migration_session_id, internal_volume.datapath_volume_id, internal_volume.is_replication_destination, internal_volume.datapath_family_id, internal_volume.storage_type, internal_volume.sector_size, internal_volume.is_internal, internal_volume.is_importing, internal_volume.node_affinity, internal_volume.platform_volume_guid, internal_volume.is_user_selected_placement,
  • Index Cond: (internal_volume.id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
  • Filter: ((NOT internal_volume.is_internal) AND (internal_volume.type <> 'Snapshot'::managementmodel.storage_resource_type) AND (internal_volume.storage_type = 'Block'::text))
19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using protection_data_volume_id_idx on internal.protection_data (cost=0.14..8.16 rows=1 width=136) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: protection_data.id, protection_data.source_type, protection_data.volume_group_id, protection_data.created_by_rule_id, protection_data.created_by_rule_name, protection_data.creator_type, protection_data.expiration_timestamp, protection_data.source_timestamp, protection_data.family_id, protection_data.source_id, protection_data.parent_id, protection_data.copy_signature, protection_data.virtual_machine_id, protection_data.creation_timestamp, protection_data.is_app_consistent, protection_data.volume_id
  • Index Cond: (protection_data.volume_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using replication_session_local_resource_id_idx on managementmodel.replication_session (cost=0.14..8.16 rows=1 width=32) (actual time=0.002..0.003 rows=0 loops=1)

  • Output: replication_session.id, replication_session.state, replication_session.role, replication_session.resource_type, replication_session.local_resource_id, replication_session.remote_resource_id, replication_session.remote_system_id, replication_session.local_common_base_id, replication_session.remote_common_base_id, replication_session.average_transfer_rate, replication_session.current_transfer_rate, replication_session.progress_percentage, replication_session.previous_state, replication_session.last_sync_timestamp, replication_session.estimated_completion_timestamp, replication_session.is_non_disruptive, replication_session.is_internal, replication_session.migration_session_id, replication_session.replication_rule_id, replication_session.last_sync_duration,
  • Index Cond: (replication_session.local_resource_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
  • Filter: (replication_session.migration_session_id IS NULL)
21. 0.006 0.006 ↑ 1.5 2 1

Seq Scan on managementmodel.appliance (cost=0.00..1.03 rows=3 width=26) (actual time=0.005..0.006 rows=2 loops=1)

  • Output: appliance.id, appliance.serial_number, appliance.name, appliance.type, appliance.part_number, appliance.model, appliance.service_tag, appliance.express_service_code, appliance.mode
22. 0.012 0.012 ↑ 1.0 1 1

Index Scan using volume_group_membership_volume_id_idx on managementmodel.volume_group_membership (cost=0.28..8.30 rows=1 width=74) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: volume_group_membership.volume_group_id, volume_group_membership.membership_tag, volume_group_membership.volume_id, volume_group_membership.member_ref_id
  • Index Cond: (volume_group_membership.volume_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
23. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on managementmodel.migration_session (cost=0.00..10.40 rows=40 width=548) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: migration_session.id, migration_session.internal_state, migration_session.state, migration_session.resource_type, migration_session.source_appliance_id, migration_session.destination_appliance_id, migration_session.automatic_cutover, migration_session.created_timestamp, migration_session.name, migration_session.operation_status, migration_session.family_id, migration_session.max_cutover_time, migration_session.avg_cutover_time
24. 0.009 0.009 ↑ 1.0 1 1

Index Scan using volume_group_pkey on managementmodel.volume_group (cost=0.27..8.29 rows=1 width=86) (actual time=0.009..0.009 rows=1 loops=1)

  • Output: volume_group.id, volume_group.name, volume_group.description, volume_group.type, volume_group.creation_timestamp, volume_group.is_protectable, volume_group.protection_policy_id, volume_group.is_write_order_consistent, volume_group.placement_rule, volume_group.is_replication_destination, volume_group.migration_session_id, volume_group.is_internal, volume_group.is_importing, volume_group.offline_member_count
  • Index Cond: (volume_group.id = volume_group_membership.volume_group_id)
25. 3.668 3.668 ↑ 5.0 1 1

Function Scan on metrics.get_latest_pmv_for_volume_from_local_dedupe perfmetrics (cost=0.25..15.25 rows=5 width=44) (actual time=3.667..3.668 rows=1 loops=1)

  • Output: perfmetrics.volume_id, perfmetrics."timestamp", perfmetrics.avg_latency, perfmetrics.total_iops, perfmetrics.total_bandwidth
  • Function Call: metrics.get_latest_pmv_for_volume_from_local_dedupe(internal_volume.id)
  • Filter: ((perfmetrics.volume_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text) AND (perfmetrics.volume_id = internal_volume.id))
26. 0.002 0.027 ↑ 1.0 1 1

Materialize (cost=0.41..8.44 rows=1 width=49) (actual time=0.027..0.027 rows=1 loops=1)

  • Output: smv.logical_used, smv.thin_savings, smv.volume_id
27. 0.025 0.025 ↑ 1.0 1 1

Index Scan using latest_space_metrics_by_volume_pkey on metrics.latest_space_metrics_by_volume smv (cost=0.41..8.43 rows=1 width=49) (actual time=0.025..0.025 rows=1 loops=1)

  • Output: smv.logical_used, smv.thin_savings, smv.volume_id
  • Index Cond: (smv.volume_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
28. 2.783 2.783 ↓ 0.0 0 1

Function Scan on metrics.get_latest_smvf_for_volume_from_local_dedupe smvf (cost=0.25..15.25 rows=1 width=84) (actual time=2.783..2.783 rows=0 loops=1)

  • Output: smvf.appliance_id, smvf.datapath_snap_group_id, smvf.shared_logical_used, smvf.unique_physical_used, smvf.snapshot_savings, smvf.snap_clone_logical_used
  • Function Call: metrics.get_latest_smvf_for_volume_from_local_dedupe(internal_volume.id)
  • Filter: ((smvf.datapath_snap_group_id = internal_volume.datapath_family_id) AND ((smvf.appliance_id)::text = internal_volume.appliance_id))
29. 0.005 0.015 ↑ 1.0 3 1

Materialize (cost=0.00..1.04 rows=3 width=19) (actual time=0.011..0.015 rows=3 loops=1)

  • Output: protection_policy.is_replica, protection_policy.name, protection_policy.id
30. 0.010 0.010 ↑ 1.0 3 1

Seq Scan on managementmodel.policy protection_policy (cost=0.00..1.03 rows=3 width=19) (actual time=0.008..0.010 rows=3 loops=1)

  • Output: protection_policy.is_replica, protection_policy.name, protection_policy.id
31. 0.002 0.004 ↑ 1.5 2 1

Materialize (cost=0.00..1.04 rows=3 width=18) (actual time=0.003..0.004 rows=2 loops=1)

  • Output: performance_policy.name, performance_policy.id
32. 0.002 0.002 ↑ 1.5 2 1

Seq Scan on managementmodel.policy performance_policy (cost=0.00..1.03 rows=3 width=18) (actual time=0.002..0.002 rows=2 loops=1)

  • Output: performance_policy.name, performance_policy.id
33. 0.003 0.003 ↓ 0.0 0 1

Index Scan using policy_pkey on managementmodel.policy volume_group_policy (cost=0.13..0.18 rows=1 width=19) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: volume_group_policy.id, volume_group_policy.name, volume_group_policy.description, volume_group_policy.type, volume_group_policy.copy_signature, volume_group_policy.modify_time, volume_group_policy.is_replica
  • Index Cond: (volume_group_policy.id = volume_group.protection_policy_id)
34. 0.001 0.006 ↓ 0.0 0 1

Materialize (cost=0.27..16.35 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: snap_count_info.count, snap_count_info.source_id
35. 0.001 0.005 ↓ 0.0 0 1

Subquery Scan on snap_count_info (cost=0.27..16.34 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: snap_count_info.count, snap_count_info.source_id
36. 0.001 0.004 ↓ 0.0 0 1

GroupAggregate (cost=0.27..16.33 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: protection_data_1.source_id, count(*)
  • Group Key: protection_data_1.source_id
37. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.27..16.32 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: protection_data_1.source_id
  • Join Filter: (internal_volume_1.id = protection_data_1.volume_id)
38. 0.003 0.003 ↓ 0.0 0 1

Index Scan using volume_snapshot_name_per_family_index on internal.internal_volume internal_volume_1 (cost=0.12..8.14 rows=1 width=37) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: internal_volume_1.id, internal_volume_1.wwn, internal_volume_1.name, internal_volume_1.description, internal_volume_1.type, internal_volume_1.appliance_id, internal_volume_1.is_read_only, internal_volume_1.state, internal_volume_1.size, internal_volume_1.platform_volume_id, internal_volume_1.import_metadata, internal_volume_1.creation_timestamp, internal_volume_1.protection_policy_id, internal_volume_1.performance_policy_id, internal_volume_1.migration_session_id, internal_volume_1.datapath_volume_id, internal_volume_1.is_replication_destination, internal_volume_1.datapath_family_id, internal_volume_1.storage_type, internal_volume_1.sector_size, internal_volume_1.is_internal, internal_volume_1.is_importing, internal_volume_1.node_affinity, internal_volume_1.platform_volume_guid, internal_volume_1.is_user_selected_placement,
  • Filter: ((NOT internal_volume_1.is_internal) AND (internal_volume_1.storage_type = 'Block'::text))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using protection_data_source_id_idx on internal.protection_data protection_data_1 (cost=0.14..8.16 rows=1 width=64) (never executed)

  • Output: protection_data_1.id, protection_data_1.source_type, protection_data_1.volume_group_id, protection_data_1.created_by_rule_id, protection_data_1.created_by_rule_name, protection_data_1.creator_type, protection_data_1.expiration_timestamp, protection_data_1.source_timestamp, protection_data_1.family_id, protection_data_1.source_id, protection_data_1.parent_id, protection_data_1.copy_signature, protection_data_1.virtual_machine_id, protection_data_1.creation_timestamp, protection_data_1.is_app_consistent, protection_data_1.volume_id
  • Index Cond: (protection_data_1.source_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
  • Filter: (protection_data_1.creator_type <> 'System'::managementmodel.creator_type_enum)
40. 0.000 0.004 ↓ 0.0 0 1

Materialize (cost=0.15..8.20 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: mapped_host_info.count, mapped_host_info.volume_id
41. 0.001 0.004 ↓ 0.0 0 1

Subquery Scan on mapped_host_info (cost=0.15..8.20 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: mapped_host_info.count, mapped_host_info.volume_id
42. 0.000 0.003 ↓ 0.0 0 1

GroupAggregate (cost=0.15..8.19 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: host_volume_mapping.volume_id, count(*)
  • Group Key: host_volume_mapping.volume_id
43. 0.003 0.003 ↓ 0.0 0 1

Index Scan using host_volume_mapping_volume_id_idx on managementmodel.host_volume_mapping (cost=0.15..8.17 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: host_volume_mapping.volume_id, host_volume_mapping.volume_map_id, host_volume_mapping.appliance_id, host_volume_mapping.host_type, host_volume_mapping.map_type, host_volume_mapping.logical_unit_number, host_volume_mapping.host_group_id, host_volume_mapping.host_id, host_volume_mapping.id, host_volume_mapping.platform_lunmap_guid, host_volume_mapping.is_internal
  • Index Cond: (host_volume_mapping.volume_id = '929f50a2-2840-44c9-933c-d340b132ea8e'::text)
  • Filter: ((host_volume_mapping.host_group_id IS NOT NULL) OR (upper(host_volume_mapping.host_type) <> 'RESTRICTED'::text))