explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qcdu

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

Limit (cost=2,686.63..2,686.63 rows=1 width=67) (actual time=5.467..5.471 rows=7 loops=1)

2. 0.048 5.467 ↓ 7.0 7 1

Sort (cost=2,686.63..2,686.63 rows=1 width=67) (actual time=5.466..5.467 rows=7 loops=1)

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

WindowAgg (cost=27.25..2,686.62 rows=1 width=67) (actual time=5.413..5.419 rows=7 loops=1)

4. 0.012 5.387 ↓ 7.0 7 1

Nested Loop (cost=27.25..2,686.61 rows=1 width=59) (actual time=4.908..5.387 rows=7 loops=1)

5. 4.799 5.151 ↓ 7.0 7 1

Bitmap Heap Scan on service_request_type__c srt (cost=26.83..2,678.16 rows=1 width=78) (actual time=4.851..5.151 rows=7 loops=1)

  • Recheck Cond: ((account__c)::text = '001i000000ESO3CAAX'::text)
  • Filter: (myshowings_support__c AND ((grouping__c)::text = 'a0Gi000000OOuMSEA1'::text))
  • Rows Removed by Filter: 768
  • Heap Blocks: exact=359
6. 0.352 0.352 ↑ 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.352..0.352 rows=775 loops=1)

  • Index Cond: ((account__c)::text = '001i000000ESO3CAAX'::text)
7. 0.224 0.224 ↑ 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.031..0.032 rows=1 loops=7)

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