explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C5uK

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.540 ↓ 0.0 0 1

Sort (cost=299.98..299.98 rows=1 width=271) (actual time=0.540..0.540 rows=0 loops=1)

  • Sort Key: p.name
  • Sort Method: quicksort Memory: 25kB
2. 0.002 0.530 ↓ 0.0 0 1

Nested Loop (cost=0.70..299.97 rows=1 width=271) (actual time=0.530..0.530 rows=0 loops=1)

3. 0.528 0.528 ↓ 0.0 0 1

Index Scan using property_idx_account on property__c p (cost=0.42..291.66 rows=1 width=232) (actual time=0.528..0.528 rows=0 loops=1)

  • Index Cond: ((account__c)::text = '001i000000kZfCVAA0'::text)
  • Filter: ((id <> 548741) AND ((active__c)::text = 'Yes'::text) AND (('3959'::double precision * acos(((('0.909274790118279'::double precision * cos(radians((lat__c)::double precision))) * cos((radians((lon__c)::double precision) - '1.636509641 (...)
  • Rows Removed by Filter: 54
4. 0.000 0.000 ↓ 0.0 0

Index Scan using hc_idx_acount_management_playbook__c_property__c on acount_management_playbook__c amp (cost=0.28..8.30 rows=1 width=19) (never executed)

  • Index Cond: ((property__c)::text = (p.sfid)::text)
  • Filter: ((amp_status__c)::text = ANY ('{Active,"Cancel Notice Submitted"}'::text[]))