explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1xu8

Settings
# exclusive inclusive rows x rows loops node
1. 114.699 247.196 ↑ 1.0 1 1

Hash Right Join (cost=574.39..15,659.02 rows=1 width=274) (actual time=247.195..247.196 rows=1 loops=1)

  • Output: configuration_lifecycles.name, configuration_lifecycles.guid, configuration_lifecycles.object_id, configuration_lifecycles.config_guid, configuration_lifecycles.configuration_lifecycle_type_name, configuration_lifecycles.configuration_lifecycle_type_object_id, configuration_lifecycles.root_segment_name, configuration_lifecycles.root_segment, configuration_lifecycles.source_guid
  • Hash Cond: ((customizations.guid)::text = (configuration_lifecycles.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=9576
2. 130.354 130.354 ↑ 1.0 407,427 1

Seq Scan on cfg_002.customizations (cost=0.00..13,556.08 rows=407,608 width=80) (actual time=0.016..130.354 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
3. 0.002 2.143 ↑ 1.0 1 1

Hash (cost=574.38..574.38 rows=1 width=274) (actual time=2.143..2.143 rows=1 loops=1)

  • Output: configuration_lifecycles.name, configuration_lifecycles.guid, configuration_lifecycles.object_id, configuration_lifecycles.config_guid, configuration_lifecycles.configuration_lifecycle_type_name, configuration_lifecycles.configuration_lifecycle_type_object_id, configuration_lifecycles.root_segment_name, configuration_lifecycles.root_segment, configuration_lifecycles.source_guid
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=96
4. 0.110 2.141 ↑ 1.0 1 1

Bitmap Heap Scan on cfg_002.configuration_lifecycles (cost=353.18..574.38 rows=1 width=274) (actual time=2.140..2.141 rows=1 loops=1)

  • Output: configuration_lifecycles.name, configuration_lifecycles.guid, configuration_lifecycles.object_id, configuration_lifecycles.config_guid, configuration_lifecycles.configuration_lifecycle_type_name, configuration_lifecycles.configuration_lifecycle_type_object_id, configuration_lifecycles.root_segment_name, configuration_lifecycles.root_segment, configuration_lifecycles.source_guid
  • Recheck Cond: ((configuration_lifecycles.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Filter: ((NOT (hashed SubPlan 1)) AND ((configuration_lifecycles.name)::text = 'B8-Upload'::text))
  • Rows Removed by Filter: 50
  • Heap Blocks: exact=12
  • Buffers: shared hit=96
5. 0.068 0.068 ↑ 1.3 51 1

Bitmap Index Scan on idx_lc_cfg_guid (cost=0.00..4.91 rows=67 width=0) (actual time=0.068..0.068 rows=51 loops=1)

  • Index Cond: ((configuration_lifecycles.config_guid)::text = '44716a8f-b498-41c4-8bac-a6068b0fef49'::text)
  • Buffers: shared hit=4
6.          

SubPlan (forBitmap Heap Scan)

7. 0.004 1.963 ↓ 0.0 0 1

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

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

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

  • Buffers: shared hit=80
9. 0.212 0.212 ↓ 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.212..0.212 rows=1,077 loops=1)

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

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

  • Buffers: shared hit=69
11. 1.152 1.152 ↑ 1.0 9,663 1

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

  • Index Cond: ((customizations_1.state)::text = 'customized_deleted'::text)
  • Buffers: shared hit=50
12. 0.572 0.572 ↑ 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.572..0.572 rows=5,776 loops=1)

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