explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RNoR

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 77.993 ↓ 7.0 7 1

Limit (cost=13,120.62..13,120.63 rows=1 width=67) (actual time=77.991..77.993 rows=7 loops=1)

2. 0.076 77.990 ↓ 7.0 7 1

Sort (cost=13,120.62..13,120.63 rows=1 width=67) (actual time=77.989..77.990 rows=7 loops=1)

  • Sort Key: srt.name
  • Sort Method: quicksort Memory: 25kB
3. 0.030 77.914 ↓ 7.0 7 1

WindowAgg (cost=0.42..13,120.61 rows=1 width=67) (actual time=77.908..77.914 rows=7 loops=1)

4. 0.016 77.884 ↓ 7.0 7 1

Nested Loop (cost=0.42..13,120.60 rows=1 width=59) (actual time=42.780..77.884 rows=7 loops=1)

5. 77.672 77.672 ↓ 7.0 7 1

Seq Scan on service_request_type__c srt (cost=0.00..13,112.15 rows=1 width=78) (actual time=42.700..77.672 rows=7 loops=1)

  • Filter: (myshowings_support__c AND ((account__c)::text = '001i000000ESO3CAAX'::text) AND ((grouping__c)::text = 'a0Gi000000OOuMSEA1'::text))
  • Rows Removed by Filter: 104203
6. 0.196 0.196 ↑ 1.0 1 7

Index Scan using property__c_idx_sfid on property__c p (cost=0.42..8.44 rows=1 width=19) (actual time=0.028..0.028 rows=1 loops=7)

  • Index Cond: ((sfid)::text = 'a000H00000rsZRmQAM'::text)
  • Filter: ((account__c)::text = '001i000000ESO3CAAX'::text)
Planning time : 2.491 ms
Execution time : 78.366 ms