explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6kCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 3.546 ↑ 1.0 10 1

Limit (cost=0.42..69.37 rows=10 width=123) (actual time=3.532..3.546 rows=10 loops=1)

2. 0.092 3.539 ↑ 7.2 10 1

WindowAgg (cost=0.42..496.83 rows=72 width=123) (actual time=3.530..3.539 rows=10 loops=1)

3. 0.295 3.447 ↑ 1.3 54 1

Nested Loop Left Join (cost=0.42..495.93 rows=72 width=102) (actual time=2.587..3.447 rows=54 loops=1)

  • Join Filter: (((amp.account__c)::text = (p.account__c)::text) AND ((amp.property__c)::text = (p.sfid)::text))
  • Rows Removed by Join Filter: 590
4. 0.560 0.560 ↑ 1.3 54 1

Index Scan using property_idx_account on property__c p (cost=0.42..287.70 rows=72 width=111) (actual time=0.056..0.560 rows=54 loops=1)

  • Index Cond: ((account__c)::text = '001i000000kZfCVAA0'::text)
5. 0.080 2.592 ↓ 1.8 11 54

Materialize (cost=0.00..200.69 rows=6 width=48) (actual time=0.006..0.048 rows=11 loops=54)

6. 2.512 2.512 ↓ 1.8 11 1

Seq Scan on acount_management_playbook__c amp (cost=0.00..200.66 rows=6 width=48) (actual time=0.327..2.512 rows=11 loops=1)

  • Filter: ((account__c)::text = '001i000000kZfCVAA0'::text)
  • Rows Removed by Filter: 5642