explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5LgJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 13.198 ↓ 20.0 20 1

Limit (cost=879.36..879.36 rows=1 width=249) (actual time=13.194..13.198 rows=20 loops=1)

2. 0.021 13.194 ↓ 20.0 20 1

Sort (cost=879.36..879.36 rows=1 width=249) (actual time=13.193..13.194 rows=20 loops=1)

  • Sort Key: pr.createddate DESC, pr.id DESC
  • Sort Method: quicksort Memory: 30kB
3. 0.056 13.173 ↓ 21.0 21 1

WindowAgg (cost=879.25..879.35 rows=1 width=249) (actual time=13.143..13.173 rows=21 loops=1)

4. 1.251 13.117 ↓ 21.0 21 1

GroupAggregate (cost=879.25..879.33 rows=1 width=144) (actual time=11.565..13.117 rows=21 loops=1)

  • Group Key: pr.id
5. 2.689 11.866 ↓ 1,332.6 9,328 1

Sort (cost=879.25..879.27 rows=7 width=155) (actual time=11.495..11.866 rows=9,328 loops=1)

  • Sort Key: pr.id DESC
  • Sort Method: quicksort Memory: 2810kB
6. 4.068 9.177 ↓ 1,332.6 9,328 1

Nested Loop Left Join (cost=6.41..879.15 rows=7 width=155) (actual time=0.066..9.177 rows=9,328 loops=1)

7. 0.006 0.405 ↓ 21.0 21 1

Nested Loop Left Join (cost=0.84..297.94 rows=1 width=155) (actual time=0.038..0.405 rows=21 loops=1)

8. 0.252 0.252 ↓ 21.0 21 1

Index Scan using property_idx_account on property__c pr (cost=0.42..289.50 rows=1 width=155) (actual time=0.026..0.252 rows=21 loops=1)

  • Index Cond: ((account__c)::text = '001i000001EGDsvAAH'::text)
  • Filter: (((active__c)::text = 'Yes'::text) AND ((floor(bed_count__c) = ANY ('{0,1,2,3,4,5,6}'::double precision[])) OR (bed_count__c IS NULL)) AND ((floor(bath_count__c) = ANY ('{0,1,2,3,4,5,6}'::double precision (...)
  • Rows Removed by Filter: 71
9. 0.147 0.147 ↑ 1.0 1 21

Index Only Scan using hc_amenity__c_idx_property__c on amenity__c am (cost=0.42..8.44 rows=1 width=19) (actual time=0.006..0.007 rows=1 loops=21)

  • Index Cond: (property__c = (pr.sfid)::text)
  • Heap Fetches: 0
10. 4.074 4.704 ↓ 3.0 444 21

Bitmap Heap Scan on unit__c u (cost=5.57..579.73 rows=148 width=38) (actual time=0.047..0.224 rows=444 loops=21)

  • Recheck Cond: ((pr.sfid)::text = (property__c)::text)
  • Heap Blocks: exact=4366
11. 0.630 0.630 ↓ 3.0 444 21

Bitmap Index Scan on hc_idx_unit__c_property__c (cost=0.00..5.54 rows=148 width=0) (actual time=0.030..0.030 rows=444 loops=21)

  • Index Cond: ((pr.sfid)::text = (property__c)::text)