explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WvkQ

Settings
# exclusive inclusive rows x rows loops node
1. 110.443 255.901 ↓ 2.0 2 1

Hash Right Join (cost=766.20..15,850.83 rows=1 width=148) (actual time=255.898..255.901 rows=2 loops=1)

  • Hash Cond: ((customizations.guid)::text = (configuration_activity_chains.guid)::text)
  • Filter: ((((customizations.config_guid)::text = '85eaa488-d2e7-4f33-8c89-7360e4eb31ec'::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)))
2. 130.567 130.567 ↑ 1.0 407,427 1

Seq Scan on customizations (cost=0.00..13,556.08 rows=407,608 width=80) (actual time=0.034..130.567 rows=407,427 loops=1)

3. 0.008 14.891 ↓ 2.0 2 1

Hash (cost=766.19..766.19 rows=1 width=148) (actual time=14.891..14.891 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
4. 5.309 14.883 ↓ 2.0 2 1

Bitmap Heap Scan on configuration_activity_chains (cost=353.64..766.19 rows=1 width=148) (actual time=11.136..14.883 rows=2 loops=1)

  • Recheck Cond: ((config_guid)::text = '85eaa488-d2e7-4f33-8c89-7360e4eb31ec'::text)
  • Filter: ((NOT (hashed SubPlan 1)) AND ((configuration_lifecycle_segment_object_id)::text = '6de7ff7c-c6a1-4329-8eeb-8e131693a04b'::text))
  • Rows Removed by Filter: 142
  • Heap Blocks: exact=10
5. 2.139 2.139 ↓ 1.1 144 1

Bitmap Index Scan on idx_activity_chain_cfg_guid (cost=0.00..5.37 rows=127 width=0) (actual time=2.139..2.139 rows=144 loops=1)

  • Index Cond: ((config_guid)::text = '85eaa488-d2e7-4f33-8c89-7360e4eb31ec'::text)
6.          

SubPlan (forBitmap Heap Scan)

7. 0.001 7.435 ↓ 0.0 0 1

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

  • Recheck Cond: (((config_guid)::text = '85eaa488-d2e7-4f33-8c89-7360e4eb31ec'::text) AND (((state)::text = 'customized_deleted'::text) OR ((state)::text = 'deleted'::text)))
8. 0.014 7.434 ↓ 0.0 0 1

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

9. 5.643 5.643 ↓ 4.7 938 1

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

  • Index Cond: ((config_guid)::text = '85eaa488-d2e7-4f33-8c89-7360e4eb31ec'::text)
10. 0.003 1.777 ↓ 0.0 0 1

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

11. 1.198 1.198 ↑ 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.198..1.198 rows=9,663 loops=1)

  • Index Cond: ((state)::text = 'customized_deleted'::text)
12. 0.576 0.576 ↑ 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.576..0.576 rows=5,776 loops=1)

  • Index Cond: ((state)::text = 'deleted'::text)