explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oO5e

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.073 ↓ 0.0 0 1

Limit (cost=238.77..238.78 rows=1 width=242) (actual time=0.073..0.073 rows=0 loops=1)

2. 0.011 0.071 ↓ 0.0 0 1

Sort (cost=238.77..238.78 rows=1 width=242) (actual time=0.071..0.071 rows=0 loops=1)

  • Sort Key: c.name
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.060 ↓ 0.0 0 1

WindowAgg (cost=202.42..238.76 rows=1 width=242) (actual time=0.060..0.060 rows=0 loops=1)

4. 0.002 0.058 ↓ 0.0 0 1

Nested Loop (cost=202.42..238.75 rows=1 width=107) (actual time=0.057..0.058 rows=0 loops=1)

5. 0.002 0.056 ↓ 0.0 0 1

Bitmap Heap Scan on lease_data__c l (cost=166.38..170.40 rows=1 width=124) (actual time=0.056..0.056 rows=0 loops=1)

  • Recheck Cond: (((property__c)::text = 'a00i000000jXLeRAAW'::text) AND ((account__c)::text = '001i000000kZfCVAA0'::text))
  • Filter: (((status__c)::text = ANY ('{Current,Resident}'::text[])) AND ((type__c)::text = 'Lease'::text))
6. 0.001 0.054 ↓ 0.0 0 1

BitmapAnd (cost=166.38..166.38 rows=1 width=0) (actual time=0.054..0.054 rows=0 loops=1)

7. 0.053 0.053 ↓ 0.0 0 1

Bitmap Index Scan on hc_idx_lease_data__c_property__c (cost=0.00..16.86 rows=590 width=0) (actual time=0.053..0.053 rows=0 loops=1)

  • Index Cond: ((property__c)::text = 'a00i000000jXLeRAAW'::text)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on hc_idx_lease_data__c_account__c (cost=0.00..149.28 rows=5,446 width=0) (never executed)

  • Index Cond: ((account__c)::text = '001i000000kZfCVAA0'::text)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on contact c (cost=36.04..68.34 rows=1 width=126) (never executed)

  • Recheck Cond: (((sfid)::text = (l.lease_holder_1__c)::text) OR ((externalid__c)::text = (l.lease_holder_1__r__externalid__c)::text) OR ((sfid)::text = (l.lease_holder_2__c)::text) OR ((externalid__c)::text = (l.lease_holder_2__r__ (...)
  • Filter: (((COALESCE(firstname, ''::character varying))::text <> ''::text) AND ((accountid)::text = '001i000000kZfCVAA0'::text) AND (((sfid)::text = (l.lease_holder_1__c)::text) OR (((COALESCE(l.lease_holder_1__c, ''::character var (...)
10. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=36.04..36.04 rows=8 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contact_idx_sfid (cost=0.00..4.57 rows=1 width=0) (never executed)

  • Index Cond: ((sfid)::text = (l.lease_holder_1__c)::text)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on hc_idx_contact_externalid__c (cost=0.00..4.44 rows=1 width=0) (never executed)

  • Index Cond: ((externalid__c)::text = (l.lease_holder_1__r__externalid__c)::text)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contact_idx_sfid (cost=0.00..4.57 rows=1 width=0) (never executed)

  • Index Cond: ((sfid)::text = (l.lease_holder_2__c)::text)
14. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on hc_idx_contact_externalid__c (cost=0.00..4.44 rows=1 width=0) (never executed)

  • Index Cond: ((externalid__c)::text = (l.lease_holder_2__r__externalid__c)::text)
15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contact_idx_sfid (cost=0.00..4.57 rows=1 width=0) (never executed)

  • Index Cond: ((sfid)::text = (l.lease_holder_3__c)::text)
16. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on hc_idx_contact_externalid__c (cost=0.00..4.44 rows=1 width=0) (never executed)

  • Index Cond: ((externalid__c)::text = (l.lease_holder_3__r__externalid__c)::text)
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contact_idx_sfid (cost=0.00..4.57 rows=1 width=0) (never executed)

  • Index Cond: ((sfid)::text = (l.lease_holder_4__c)::text)
18. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on hc_idx_contact_externalid__c (cost=0.00..4.44 rows=1 width=0) (never executed)

  • Index Cond: ((externalid__c)::text = (l.lease_holder_4__r__externalid__c)::text)
Planning time : 5.515 ms
Execution time : 0.429 ms