explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wTAb

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 635.096 ↑ 1.0 1 1

Subquery Scan on configuration_external_dependency_view (cost=46,469.73..46,469.76 rows=1 width=357) (actual time=635.095..635.096 rows=1 loops=1)

  • Output: configuration_external_dependency_view.guid, configuration_external_dependency_view.object_id, configuration_external_dependency_view.prerequisite_artifact_name, configuration_external_dependency_view.prerequisite_activity_name, configuration_external_dependency_view.successor_artifact_name, configuration_external_dependency_view.successor_activity_name, configuration_external_dependency_view.configuration_country_name, configuration_external_dependency_view.state, configuration_external_dependency_view.template, configuration_external_dependency_view.content_dependency, configuration_external_dependency_view.lineage, configuration_external_dependency_view.prerequisite_artifact_object_id, configuration_external_dependency_view.successor_artifact_object_id, configuration_external_dependency_view.prerequisite_activity_object_id, configuration_external_dependency_view.successor_activity_object_id, configuration_external_dependency_view.configuration_country_alpha2
  • Filter: ((NOT (hashed SubPlan 1)) AND (NOT (hashed SubPlan 2)) AND (NOT (hashed SubPlan 3)))
  • Buffers: shared hit=28760
2. 0.036 630.591 ↑ 1.0 1 1

Sort (cost=45,424.94..45,424.94 rows=1 width=868) (actual time=630.591..630.591 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_countries.name, prerequisite_activities.name, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid, successor_activities.name, configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, customizations_2.state, customizations_2.config_guid
  • Sort Key: configuration_artifacts_1.name
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=28520
3. 0.008 630.555 ↑ 1.0 1 1

Nested Loop (cost=15,231.57..45,424.93 rows=1 width=868) (actual time=611.940..630.555 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_countries.name, prerequisite_activities.name, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid, successor_activities.name, configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, customizations_2.state, customizations_2.config_guid
  • Buffers: shared hit=28515
4. 0.004 630.539 ↑ 1.0 1 1

Nested Loop (cost=15,231.43..45,416.75 rows=1 width=856) (actual time=611.925..630.539 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, prerequisite_activities.name, successor_activities.name, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid, configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, customizations_2.state, customizations_2.config_guid
  • Buffers: shared hit=28513
5. 0.011 630.506 ↑ 1.0 1 1

Nested Loop (cost=15,231.01..45,408.31 rows=1 width=838) (actual time=611.893..630.506 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, prerequisite_activities.name, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid, configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, customizations_2.state, customizations_2.config_guid
  • Buffers: shared hit=28509
6. 0.006 630.447 ↑ 1.0 1 1

Nested Loop (cost=15,230.59..45,399.86 rows=1 width=820) (actual time=611.835..630.447 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid, configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, customizations_2.state, customizations_2.config_guid
  • Buffers: shared hit=28505
7. 112.771 208.454 ↑ 1.0 1 1

Hash Right Join (cost=8.45..15,093.08 rows=1 width=198) (actual time=189.844..208.454 rows=1 loops=1)

  • Output: configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, configuration_artifacts_1.object_id, customizations_2.state, customizations_2.config_guid
  • Hash Cond: ((customizations_2.guid)::text = (configuration_artifacts_1.guid)::text)
  • Filter: ((((customizations_2.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) OR (customizations_2.config_guid IS NULL)) AND ((customizations_2.state IS NULL) OR ((customizations_2.state)::text = 'customized_added'::text) OR ((customizations_2.state)::text = 'added'::text)))
  • Buffers: shared hit=9484
8. 95.637 95.637 ↑ 1.0 407,427 1

Seq Scan on cfg_002.customizations customizations_2 (cost=0.00..13,556.08 rows=407,608 width=80) (actual time=0.004..95.637 rows=407,427 loops=1)

  • Output: customizations_2.id, customizations_2.guid, customizations_2.config_guid, customizations_2.parent_config_guid, customizations_2.type, customizations_2.state, customizations_2.created_at, customizations_2.updated_at, customizations_2.reference_guid, customizations_2.secondary_guid, customizations_2.tertiary_guid, customizations_2.configuration_country_alpha2
  • Buffers: shared hit=9480
9. 0.002 0.046 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=155) (actual time=0.046..0.046 rows=1 loops=1)

  • Output: configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, configuration_artifacts_1.object_id
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=4
10. 0.044 0.044 ↑ 1.0 1 1

Index Scan using idx_artifact_obj_id on cfg_002.configuration_artifacts configuration_artifacts_1 (cost=0.42..8.44 rows=1 width=155) (actual time=0.043..0.044 rows=1 loops=1)

  • Output: configuration_artifacts_1.name, configuration_artifacts_1.type, configuration_artifacts_1.guid, configuration_artifacts_1.config_guid, configuration_artifacts_1.object_id
  • Index Cond: ((configuration_artifacts_1.object_id)::text = '0408b56e-f15f-4ca8-81af-1ee7f363d7e0'::text)
  • Filter: ((configuration_artifacts_1.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=4
11. 114.265 421.987 ↑ 1.0 1 1

Hash Right Join (cost=15,222.14..30,306.77 rows=1 width=659) (actual time=421.986..421.987 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid, customizations_1.state, customizations_1.config_guid
  • Hash Cond: ((customizations_1.guid)::text = (configuration_artifacts.guid)::text)
  • Filter: ((((customizations_1.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) OR (customizations_1.config_guid IS NULL)) AND ((customizations_1.state IS NULL) OR ((customizations_1.state)::text = 'customized_added'::text) OR ((customizations_1.state)::text = 'added'::text)))
  • Buffers: shared hit=19021
12. 97.409 97.409 ↑ 1.0 407,427 1

Seq Scan on cfg_002.customizations customizations_1 (cost=0.00..13,556.08 rows=407,608 width=80) (actual time=0.003..97.409 rows=407,427 loops=1)

  • Output: customizations_1.id, customizations_1.guid, customizations_1.config_guid, customizations_1.parent_config_guid, customizations_1.type, customizations_1.state, customizations_1.created_at, customizations_1.updated_at, customizations_1.reference_guid, customizations_1.secondary_guid, customizations_1.tertiary_guid, customizations_1.configuration_country_alpha2
  • Buffers: shared hit=9480
13. 0.004 210.313 ↑ 1.0 1 1

Hash (cost=15,222.13..15,222.13 rows=1 width=616) (actual time=210.313..210.313 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=9541
14. 0.015 210.309 ↑ 1.0 1 1

Nested Loop (cost=129.47..15,222.13 rows=1 width=616) (actual time=104.723..210.309 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.guid, configuration_artifacts.config_guid
  • Buffers: shared hit=9541
15. 112.977 210.225 ↑ 1.0 1 1

Hash Right Join (cost=129.05..15,213.68 rows=1 width=498) (actual time=104.642..210.225 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template, customizations.reference_guid, customizations.state, customizations.guid, customizations.config_guid
  • Hash Cond: ((customizations.guid)::text = (configuration_external_dependencies.guid)::text)
  • Filter: ((((customizations.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) OR (customizations.config_guid IS NULL)) AND ((customizations.state IS NULL) OR ((customizations.state)::text = 'customized_added'::text) OR ((customizations.state)::text = 'added'::text)))
  • Buffers: shared hit=9537
16. 96.388 96.388 ↑ 1.0 407,427 1

Seq Scan on cfg_002.customizations (cost=0.00..13,556.08 rows=407,608 width=117) (actual time=0.003..96.388 rows=407,427 loops=1)

  • Output: customizations.id, customizations.guid, customizations.config_guid, customizations.parent_config_guid, customizations.type, customizations.state, customizations.created_at, customizations.updated_at, customizations.reference_guid, customizations.secondary_guid, customizations.tertiary_guid, customizations.configuration_country_alpha2
  • Buffers: shared hit=9480
17. 0.004 0.860 ↑ 1.0 1 1

Hash (cost=129.04..129.04 rows=1 width=381) (actual time=0.860..0.860 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=57
18. 0.056 0.856 ↑ 1.0 1 1

Bitmap Heap Scan on cfg_002.configuration_external_dependencies (cost=125.00..129.04 rows=1 width=381) (actual time=0.856..0.856 rows=1 loops=1)

  • Output: configuration_external_dependencies.guid, configuration_external_dependencies.id, configuration_external_dependencies.object_id, configuration_external_dependencies.source_guid, configuration_external_dependencies.source_object_id, configuration_external_dependencies.config_guid, configuration_external_dependencies.prerequisite_artifact_object_id, configuration_external_dependencies.prerequisite_activity_object_id, configuration_external_dependencies.successor_artifact_object_id, configuration_external_dependencies.successor_activity_object_id, configuration_external_dependencies.condition, configuration_external_dependencies.content_dependency, configuration_external_dependencies.lineage, configuration_external_dependencies.configuration_country_alpha2, configuration_external_dependencies.created_at, configuration_external_dependencies.updated_at, configuration_external_dependencies.template
  • Recheck Cond: (((configuration_external_dependencies.successor_artifact_object_id)::text = '0408b56e-f15f-4ca8-81af-1ee7f363d7e0'::text) AND ((configuration_external_dependencies.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text))
  • Filter: ((((configuration_external_dependencies.configuration_country_alpha2)::text = 'CN'::text) OR (configuration_external_dependencies.configuration_country_alpha2 IS NULL)) AND ((configuration_external_dependencies.successor_activity_object_id)::text = '07648b44-32b7-4069-ad47-5c8468e988ea'::text) AND ((configuration_external_dependencies.configuration_country_alpha2)::text = ANY ('{AR,AT,BR,BG,CN,FR,IT,PL,RO,ES,TW,UA,GB,US}'::text[])))
  • Rows Removed by Filter: 13
  • Heap Blocks: exact=6
  • Buffers: shared hit=57
19. 0.005 0.800 ↓ 0.0 0 1

BitmapAnd (cost=125.00..125.00 rows=1 width=0) (actual time=0.800..0.800 rows=0 loops=1)

  • Buffers: shared hit=51
20. 0.074 0.074 ↑ 22.6 14 1

Bitmap Index Scan on idx_dependency_suc_artifact (cost=0.00..14.93 rows=316 width=0) (actual time=0.074..0.074 rows=14 loops=1)

  • Index Cond: ((configuration_external_dependencies.successor_artifact_object_id)::text = '0408b56e-f15f-4ca8-81af-1ee7f363d7e0'::text)
  • Buffers: shared hit=4
21. 0.721 0.721 ↓ 2.1 5,920 1

Bitmap Index Scan on idx_dependency_cfg_guid (cost=0.00..109.82 rows=2,835 width=0) (actual time=0.721..0.721 rows=5,920 loops=1)

  • Index Cond: ((configuration_external_dependencies.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=47
22. 0.069 0.069 ↑ 1.0 1 1

Index Scan using idx_artifact_obj_id on cfg_002.configuration_artifacts (cost=0.42..8.44 rows=1 width=155) (actual time=0.068..0.069 rows=1 loops=1)

  • Output: configuration_artifacts.id, configuration_artifacts.guid, configuration_artifacts.config_guid, configuration_artifacts.dia_tmf, configuration_artifacts.staff_title, configuration_artifacts.irb_ec_type, configuration_artifacts.meeting_dates_enabled, configuration_artifacts.manage_document_expiry, configuration_artifacts.days_until_expiry_notification, configuration_artifacts.pre_ip_release_review, configuration_artifacts.compound_document, configuration_artifacts.enable_discontinue, configuration_artifacts.available, configuration_artifacts.created_at, configuration_artifacts.updated_at, configuration_artifacts.name, configuration_artifacts.type, configuration_artifacts.level, configuration_artifacts.object_id, configuration_artifacts.configuration_lifecycle_name, configuration_artifacts.configuration_lifecycle_type_object_id, configuration_artifacts.creation_option, configuration_artifacts.template, configuration_artifacts.configuration_category_object_id, configuration_artifacts.subcommittee_scenario_object_id, configuration_artifacts.package_scenario_object_id, configuration_artifacts.share_with_sites, configuration_artifacts.source_guid, configuration_artifacts.source_object_id, configuration_artifacts.for_study_site, configuration_artifacts.contract_document_type, configuration_artifacts.enable_terminate, configuration_artifacts.enable_on_hold, configuration_artifacts.budget_scenario_object_id, configuration_artifacts.display_order_position, configuration_artifacts.enable_artifact_language, configuration_artifacts.enable_draft_document, configuration_artifacts.enable_agency_name, configuration_artifacts.enable_organization, configuration_artifacts.tmf_identifier_v2, configuration_artifacts.wet_ink, configuration_artifacts.require_version_label, configuration_artifacts.require_expiry, configuration_artifacts.description, configuration_artifacts.enable_add_version
  • Index Cond: ((configuration_artifacts.object_id)::text = (configuration_external_dependencies.prerequisite_artifact_object_id)::text)
  • Filter: ((configuration_artifacts.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=4
23. 0.048 0.048 ↑ 1.0 1 1

Index Scan using idx_activities_obj_id on cfg_002.configuration_activities prerequisite_activities (cost=0.42..8.44 rows=1 width=55) (actual time=0.048..0.048 rows=1 loops=1)

  • Output: prerequisite_activities.id, prerequisite_activities.guid, prerequisite_activities.config_guid, prerequisite_activities.name, prerequisite_activities.decision_label, prerequisite_activities.action, prerequisite_activities.upload_enabled, prerequisite_activities.planning_enabled, prerequisite_activities.point_of_no_return, prerequisite_activities.created_at, prerequisite_activities.updated_at, prerequisite_activities.object_id, prerequisite_activities.configuration_role_object_id, prerequisite_activities.configuration_lifecycle_object_id, prerequisite_activities.source_guid, prerequisite_activities.source_object_id, prerequisite_activities.is_submit_activity, prerequisite_activities.is_approval_activity
  • Index Cond: ((prerequisite_activities.object_id)::text = (configuration_external_dependencies.prerequisite_activity_object_id)::text)
  • Buffers: shared hit=4
24. 0.029 0.029 ↑ 1.0 1 1

Index Scan using idx_activities_obj_id on cfg_002.configuration_activities successor_activities (cost=0.42..8.44 rows=1 width=55) (actual time=0.029..0.029 rows=1 loops=1)

  • Output: successor_activities.id, successor_activities.guid, successor_activities.config_guid, successor_activities.name, successor_activities.decision_label, successor_activities.action, successor_activities.upload_enabled, successor_activities.planning_enabled, successor_activities.point_of_no_return, successor_activities.created_at, successor_activities.updated_at, successor_activities.object_id, successor_activities.configuration_role_object_id, successor_activities.configuration_lifecycle_object_id, successor_activities.source_guid, successor_activities.source_object_id, successor_activities.is_submit_activity, successor_activities.is_approval_activity
  • Index Cond: ((successor_activities.object_id)::text = '07648b44-32b7-4069-ad47-5c8468e988ea'::text)
  • Buffers: shared hit=4
25. 0.008 0.008 ↑ 1.0 1 1

Index Scan using idx_countries_alpha2 on cfg_002.configuration_countries (cost=0.14..8.16 rows=1 width=15) (actual time=0.007..0.008 rows=1 loops=1)

  • Output: configuration_countries.id, configuration_countries.region, configuration_countries.name, configuration_countries.alpha2, configuration_countries.alpha3, configuration_countries.created_at, configuration_countries.updated_at
  • Index Cond: ((configuration_countries.alpha2)::text = (configuration_external_dependencies.configuration_country_alpha2)::text)
  • Buffers: shared hit=2
26.          

SubPlan (forSubquery Scan)

27. 0.002 1.545 ↓ 0.0 0 1

Bitmap Heap Scan on cfg_002.customizations customizations_3 (cost=316.80..348.25 rows=8 width=37) (actual time=1.545..1.545 rows=0 loops=1)

  • Output: customizations_3.guid
  • Recheck Cond: (((customizations_3.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) AND (((customizations_3.state)::text = 'customized_deleted'::text) OR ((customizations_3.state)::text = 'deleted'::text)))
  • Buffers: shared hit=80
28. 0.021 1.543 ↓ 0.0 0 1

BitmapAnd (cost=316.80..316.80 rows=8 width=0) (actual time=1.543..1.543 rows=0 loops=1)

  • Buffers: shared hit=80
29. 0.128 0.128 ↓ 5.4 1,077 1

Bitmap Index Scan on idx_customizations_cfg_guid (cost=0.00..9.91 rows=198 width=0) (actual time=0.128..0.128 rows=1,077 loops=1)

  • Index Cond: ((customizations_3.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=11
30. 0.002 1.394 ↓ 0.0 0 1

BitmapOr (cost=306.64..306.64 rows=15,706 width=0) (actual time=1.394..1.394 rows=0 loops=1)

  • Buffers: shared hit=69
31. 0.906 0.906 ↑ 1.0 9,663 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..189.38 rows=9,728 width=0) (actual time=0.906..0.906 rows=9,663 loops=1)

  • Index Cond: ((customizations_3.state)::text = 'customized_deleted'::text)
  • Buffers: shared hit=50
32. 0.486 0.486 ↑ 1.0 5,776 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..117.26 rows=5,978 width=0) (actual time=0.486..0.486 rows=5,776 loops=1)

  • Index Cond: ((customizations_3.state)::text = 'deleted'::text)
  • Buffers: shared hit=19
33. 0.001 1.459 ↓ 0.0 0 1

Bitmap Heap Scan on cfg_002.customizations customizations_4 (cost=316.80..348.25 rows=8 width=37) (actual time=1.459..1.459 rows=0 loops=1)

  • Output: customizations_4.guid
  • Recheck Cond: (((customizations_4.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) AND (((customizations_4.state)::text = 'customized_deleted'::text) OR ((customizations_4.state)::text = 'deleted'::text)))
  • Buffers: shared hit=80
34. 0.019 1.458 ↓ 0.0 0 1

BitmapAnd (cost=316.80..316.80 rows=8 width=0) (actual time=1.458..1.458 rows=0 loops=1)

  • Buffers: shared hit=80
35. 0.119 0.119 ↓ 5.4 1,077 1

Bitmap Index Scan on idx_customizations_cfg_guid (cost=0.00..9.91 rows=198 width=0) (actual time=0.119..0.119 rows=1,077 loops=1)

  • Index Cond: ((customizations_4.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=11
36. 0.002 1.320 ↓ 0.0 0 1

BitmapOr (cost=306.64..306.64 rows=15,706 width=0) (actual time=1.320..1.320 rows=0 loops=1)

  • Buffers: shared hit=69
37. 0.845 0.845 ↑ 1.0 9,663 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..189.38 rows=9,728 width=0) (actual time=0.845..0.845 rows=9,663 loops=1)

  • Index Cond: ((customizations_4.state)::text = 'customized_deleted'::text)
  • Buffers: shared hit=50
38. 0.473 0.473 ↑ 1.0 5,776 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..117.26 rows=5,978 width=0) (actual time=0.473..0.473 rows=5,776 loops=1)

  • Index Cond: ((customizations_4.state)::text = 'deleted'::text)
  • Buffers: shared hit=19
39. 0.003 1.456 ↓ 0.0 0 1

Bitmap Heap Scan on cfg_002.customizations customizations_5 (cost=316.80..348.25 rows=8 width=37) (actual time=1.456..1.456 rows=0 loops=1)

  • Output: customizations_5.guid
  • Recheck Cond: (((customizations_5.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text) AND (((customizations_5.state)::text = 'customized_deleted'::text) OR ((customizations_5.state)::text = 'deleted'::text)))
  • Buffers: shared hit=80
40. 0.019 1.453 ↓ 0.0 0 1

BitmapAnd (cost=316.80..316.80 rows=8 width=0) (actual time=1.453..1.453 rows=0 loops=1)

  • Buffers: shared hit=80
41. 0.108 0.108 ↓ 5.4 1,077 1

Bitmap Index Scan on idx_customizations_cfg_guid (cost=0.00..9.91 rows=198 width=0) (actual time=0.108..0.108 rows=1,077 loops=1)

  • Index Cond: ((customizations_5.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=11
42. 0.001 1.326 ↓ 0.0 0 1

BitmapOr (cost=306.64..306.64 rows=15,706 width=0) (actual time=1.326..1.326 rows=0 loops=1)

  • Buffers: shared hit=69
43. 0.849 0.849 ↑ 1.0 9,663 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..189.38 rows=9,728 width=0) (actual time=0.849..0.849 rows=9,663 loops=1)

  • Index Cond: ((customizations_5.state)::text = 'customized_deleted'::text)
  • Buffers: shared hit=50
44. 0.476 0.476 ↑ 1.0 5,776 1

Bitmap Index Scan on idx_customizations_state (cost=0.00..117.26 rows=5,978 width=0) (actual time=0.476..0.476 rows=5,776 loops=1)

  • Index Cond: ((customizations_5.state)::text = 'deleted'::text)
  • Buffers: shared hit=19