explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v3MT

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

Limit (cost=4,885,185.91..4,885,187.08 rows=10 width=82) (actual rows= loops=)

  • Functions: 19
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=4,885,185.91..4,885,187.08 rows=10 width=82) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=4,884,185.88..4,884,185.90 rows=5 width=82) (actual rows= loops=)

  • Sort Key: p.property_address
4. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=4,838,705.92..4,884,185.83 rows=5 width=82) (actual rows= loops=)

  • Hash Cond: (m.property_id = p.property_id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on model m (cost=0.00..44,991.47 rows=186,071 width=51) (actual rows= loops=)

  • Filter: ((min_price > 1000) AND (max_price < 3000) AND (bed >= '2'::double precision))
6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=4,838,705.79..4,838,705.79 rows=11 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Index Scan using ix_property_is_active on property p (cost=0.42..4,838,705.79 rows=11 width=32) (actual rows= loops=)

  • Index Cond: (is_active = true)
  • Filter: (((customer_id = 26,547) OR ((employer_id = 26,547) AND (parent_id = 26,547))) AND st_dwithin(location, '01010000200200000000000000000000000000000000000000'::geometry, '1000'::double precision))