explain.depesz.com

PostgreSQL's explain analyze made readable

Result: De3m : vpe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=110.82..115.57 rows=1 width=1,608) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=110.76..114.64 rows=1 width=1,627) (actual rows= loops=)

  • Merge Cond: ((site.sfid)::text = (energypointlife__c.siteid__c)::text)
3. 0.000 0.000 ↓ 0.0

Sort (cost=8.13..8.13 rows=1 width=1,608) (actual rows= loops=)

  • Sort Key: site.sfid
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.11..8.12 rows=1 width=1,608) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using hc_idx_account_siren__c on account ej (cost=0.06..4.06 rows=1 width=19) (actual rows= loops=)

  • Index Cond: ((siren__c)::text = '056801046'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using hc_idx_account_parentid on account site (cost=0.06..4.06 rows=1 width=1,608) (actual rows= loops=)

  • Index Cond: ((parentid)::text = (ej.sfid)::text)
7. 0.000 0.000 ↓ 0.0

Unique (cost=102.63..104.22 rows=654 width=46) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=102.63..103.43 rows=1,587 width=46) (actual rows= loops=)

  • Sort Key: energypointlife__c.siteid__c, energypointlife__c.lastmodifieddate DESC
9. 0.000 0.000 ↓ 0.0

Seq Scan on energypointlife__c (cost=0.00..85.76 rows=1,587 width=46) (actual rows= loops=)

  • Filter: (isdeleted IS FALSE)
10. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_energypoint__c_sfid on energypoint__c pe (cost=0.06..0.49 rows=1 width=19) (actual rows= loops=)

  • Index Cond: ((sfid)::text = (energypointlife__c.energypointid__c)::text)
  • Filter: ((name)::text = '09711562845457'::text)