explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yWi

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

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

2. 10.085 184.259 ↑ 1.0 1 1

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

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

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

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

Bitmap Heap Scan on service_request1__c sr (cost=8.88..16.91 rows=1 width=55) (actual time=0.055..0.055 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.007 0.037 ↓ 0.0 0 1

BitmapOr (cost=8.88..8.88 rows=2 width=0) (actual time=0.037..0.037 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.028 0.028 ↓ 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.028..0.028 rows=4 loops=1)

  • Index Cond: ((externalid__c)::text = (ed.service_request__r__externalid__c)::text)
Planning time : 0.911 ms
Execution time : 184.518 ms