explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a9nD

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.721 ↓ 7.0 7 1

Limit (cost=44.25..44.25 rows=1 width=67) (actual time=0.718..0.721 rows=7 loops=1)

2. 0.040 0.717 ↓ 7.0 7 1

Sort (cost=44.25..44.25 rows=1 width=67) (actual time=0.716..0.717 rows=7 loops=1)

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

WindowAgg (cost=32.18..44.24 rows=1 width=67) (actual time=0.672..0.677 rows=7 loops=1)

4. 0.011 0.648 ↓ 7.0 7 1

Nested Loop (cost=32.18..44.23 rows=1 width=59) (actual time=0.476..0.648 rows=7 loops=1)

5. 0.116 0.448 ↓ 7.0 7 1

Bitmap Heap Scan on service_request_type__c srt (cost=31.76..35.78 rows=1 width=78) (actual time=0.433..0.448 rows=7 loops=1)

  • Recheck Cond: (((grouping__c)::text = 'a0Gi000000OOuMSEA1'::text) AND ((account__c)::text = '001i000000ESO3CAAX'::text))
  • Filter: myshowings_support__c
  • Rows Removed by Filter: 35
  • Heap Blocks: exact=35
6. 0.010 0.332 ↓ 0.0 0 1

BitmapAnd (cost=31.76..31.76 rows=1 width=0) (actual time=0.332..0.332 rows=0 loops=1)

7. 0.095 0.095 ↓ 1.2 42 1

Bitmap Index Scan on ah_idx_service_request_type__c_grouping__c (cost=0.00..4.68 rows=35 width=0) (actual time=0.095..0.095 rows=42 loops=1)

  • Index Cond: ((grouping__c)::text = 'a0Gi000000OOuMSEA1'::text)
8. 0.227 0.227 ↑ 1.1 775 1

Bitmap Index Scan on ah_idx_service_request_type__c_account__c (cost=0.00..26.83 rows=855 width=0) (actual time=0.227..0.227 rows=775 loops=1)

  • Index Cond: ((account__c)::text = '001i000000ESO3CAAX'::text)
9. 0.189 0.189 ↑ 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.027..0.027 rows=1 loops=7)

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