explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qrz

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,081.73..40,654.18 rows=8 width=56) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..0.10 rows=8 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=5,081.73..5,081.74 rows=1 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Limit (cost=4,958.98..5,081.70 rows=1 width=3,605) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4,958.98..6,308.90 rows=11 width=3,605) (actual rows= loops=)

  • Join Filter: false
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4,958.98..6,308.79 rows=11 width=32) (actual rows= loops=)

  • Join Filter: false
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4,958.98..6,308.68 rows=11 width=32) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4,958.57..6,293.18 rows=10 width=97) (actual rows= loops=)

  • Join Filter: (main.std_landuse = cmbtm.lu_code)
9. 0.000 0.000 ↓ 0.0

Append (cost=4,958.57..6,237.04 rows=10 width=102) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on property_master_search_v4_partitioned_4_19 main (cost=4,958.57..6,236.99 rows=10 width=102) (actual rows= loops=)

  • Recheck Cond: ((center && '0106000020E61000000100000001030000000100000005000000000000C07B6F58C09B24D830555D3E40000000C07B6F58C08A7016874A4A3E40010000704C6758C08A7016874A4A3E40010000704C6758C09B24D830555D3E40000000C07B6F58C09B24D830555D3E40'::geometry) AND (gid = ANY ('{322770,322776}'::integer[])))
  • Filter: ((pid = 4) AND ("left"(geohash, 3) = "*VALUES*".column1) AND _st_intersects(center, '0106000020E61000000100000001030000000100000005000000000000C07B6F58C09B24D830555D3E40000000C07B6F58C08A7016874A4A3E40010000704C6758C08A7016874A4A3E40010000704C6758C09B24D830555D3E40000000C07B6F58C09B24D830555D3E40'::geometry))
11. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4,958.57..4,958.57 rows=933 width=0) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on property_master_search_v4_partitioned_4_19_center_idx (cost=0.00..781.35 rows=33,431 width=0) (actual rows= loops=)

  • Index Cond: (center && '0106000020E61000000100000001030000000100000005000000000000C07B6F58C09B24D830555D3E40000000C07B6F58C08A7016874A4A3E40010000704C6758C08A7016874A4A3E40010000704C6758C09B24D830555D3E40000000C07B6F58C09B24D830555D3E40'::geometry)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on property_master_search_v4_partitioned_4_19_gid_idx (cost=0.00..4,176.97 rows=206,100 width=0) (actual rows= loops=)

  • Index Cond: (gid = ANY ('{322770,322776}'::integer[]))
14. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..7.90 rows=327 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on reference_commercial_building_type_mapping cmbtm (cost=0.00..6.27 rows=327 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Append (cost=0.41..1.54 rows=1 width=66) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Only Scan using "reso_listings_latest_abor__mls__locationId_key" on reso_listings_latest_abor l (cost=0.41..1.54 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((_mls = 'abor'::text) AND ("_locationId" = main.remineid))
18. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • One-Time Filter: false
19. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • One-Time Filter: false