explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CNVE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 188.655 ↑ 1.0 1 1

Nested Loop (cost=1,008.88..69,374.84 rows=1 width=1,182) (actual time=188.649..188.655 rows=1 loops=1)

2. 10.753 190.005 ↑ 1.0 1 1

Gather (cost=1,000.00..69,357.86 rows=1 width=443) (actual time=188.595..190.005 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 179.252 179.252 ↓ 0.0 0 3

Parallel Seq Scan on emergency_dispatch__c ed (cost=0.00..68,357.76 rows=1 width=443) (actual time=129.203..179.252 rows=0 loops=3)

  • Filter: ((service_request__r__externalid__c)::text = '2827529'::text)
  • Rows Removed by Filter: 154754
4. 0.017 0.040 ↑ 1.0 1 1

Bitmap Heap Scan on service_request1__c sr (cost=8.88..16.91 rows=1 width=55) (actual time=0.040..0.040 rows=1 loops=1)

  • Recheck Cond: (((ed.service_request__c)::text = (sfid)::text) OR ((externalid__c)::text = (ed.service_request__r__externalid__c)::text))
  • Filter: (((account_name__c)::text = '001i000000kZfCVAA0'::text) AND ((((COALESCE(sfid, ''::character varying))::text <> ''::text) AND ((ed.service_request__c)::text = (sfid)::text)) OR (((COALESCE(sfid, ''::character varying))::text = ''::text) AND (...)
  • Heap Blocks: exact=4
5. 0.004 0.023 ↓ 0.0 0 1

BitmapOr (cost=8.88..8.88 rows=2 width=0) (actual time=0.023..0.023 rows=0 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on service_request1__c_idx_sfid (cost=0.00..4.44 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((ed.service_request__c)::text = (sfid)::text)
7. 0.017 0.017 ↓ 4.0 4 1

Bitmap Index Scan on hc_idx_service_request1__c_externalid__c (cost=0.00..4.44 rows=1 width=0) (actual time=0.017..0.017 rows=4 loops=1)

  • Index Cond: ((externalid__c)::text = (ed.service_request__r__externalid__c)::text)