explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Yl4

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 10.064 ↑ 1.0 1 1

Limit (cost=1,887.34..1,887.40 rows=1 width=138) (actual time=10.063..10.064 rows=1 loops=1)

2. 0.007 10.062 ↑ 1.0 1 1

Result (cost=1,887.34..1,887.40 rows=1 width=138) (actual time=10.062..10.062 rows=1 loops=1)

3. 0.009 10.055 ↑ 1.0 1 1

Sort (cost=1,887.34..1,887.35 rows=1 width=106) (actual time=10.054..10.055 rows=1 loops=1)

  • Sort Key: (CASE WHEN ((pa.roles__c IS NULL) OR ((pa.roles__c)::text = ''::text)) THEN 0 WHEN ((pa.roles__c)::text = 'Primary Agent'::text) THEN 1 WHEN ((pa.roles__c)::text = 'Secondary Agent'::text) THEN 2 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 25kB
4. 0.009 10.046 ↑ 1.0 1 1

WindowAgg (cost=1,887.30..1,887.33 rows=1 width=106) (actual time=10.045..10.046 rows=1 loops=1)

5. 0.001 10.037 ↑ 1.0 1 1

Group (cost=1,887.30..1,887.31 rows=1 width=62) (actual time=10.037..10.037 rows=1 loops=1)

  • Group Key: pa.roles__c, c.id
6. 0.009 10.036 ↑ 1.0 1 1

Sort (cost=1,887.30..1,887.30 rows=1 width=62) (actual time=10.036..10.036 rows=1 loops=1)

  • Sort Key: pa.roles__c, c.id
  • Sort Method: quicksort Memory: 25kB
7. 7.453 10.027 ↑ 1.0 1 1

Nested Loop (cost=0.98..1,887.29 rows=1 width=62) (actual time=7.896..10.027 rows=1 loops=1)

  • Join Filter: (((da.contact_rec_id__c)::text = (c.sfid)::text) OR ((da.contact__externalid__c)::text = (c.externalid__c)::text))
  • Rows Removed by Join Filter: 34609
8. 0.002 0.050 ↑ 1.0 1 1

Nested Loop (cost=0.98..33.06 rows=1 width=70) (actual time=0.047..0.050 rows=1 loops=1)

9. 0.023 0.023 ↑ 1.0 1 1

Index Scan using hc_idx_property_agent__c_contact__c on property_agent__c pa (cost=0.42..24.47 rows=1 width=28) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((contact__c)::text = '0030H00004wNDeVQAW'::text)
  • Filter: ((property__c)::text = 'a00i000000fzJBpAAM'::text)
  • Rows Removed by Filter: 3
10. 0.025 0.025 ↑ 1.0 1 1

Index Scan using contact_idx_sfid on contact c (cost=0.56..8.59 rows=1 width=61) (actual time=0.023..0.025 rows=1 loops=1)

  • Index Cond: ((sfid)::text = '0030H00004wNDeVQAW'::text)
  • Filter: ((NOT inactive__c) AND ((accountid)::text = '001i000000kZfCVAA0'::text) AND (concat_ws(' '::text, firstname, lastname) <> ''::text))
11. 2.524 2.524 ↓ 1.0 34,610 1

Seq Scan on default_availability__c da (cost=0.00..1,335.09 rows=34,609 width=20) (actual time=0.004..2.524 rows=34,610 loops=1)

Planning time : 0.736 ms
Execution time : 10.205 ms