explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qjqV

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 6,225.688 ↓ 1.1 39 1

Limit (cost=1,187,882.10..1,187,882.19 rows=37 width=2,862) (actual time=6,225.661..6,225.688 rows=39 loops=1)

2. 0.612 6,225.681 ↓ 1.1 39 1

Sort (cost=1,187,882.10..1,187,882.19 rows=37 width=2,862) (actual time=6,225.660..6,225.681 rows=39 loops=1)

  • Sort Key: (COALESCE((property.services & 64), 0)) DESC, (date_trunc('day'::text, property.create_time)) DESC, property.ranking DESC
  • Sort Method: quicksort Memory: 73kB
3. 6,225.069 6,225.069 ↓ 1.1 39 1

Seq Scan on property (cost=0.00..1,187,881.14 rows=37 width=2,862) (actual time=2,572.464..6,225.069 rows=39 loops=1)

  • Filter: ((NOT hidden) AND (floorspace >= 48) AND (floorspace <= 72) AND (id <> 2776485) AND (status = 1) AND ((city)::text = 'Pécs'::text) AND (CASE WHEN ((currency)::text = 'EUR'::text) THEN (COALESCE(price, '0'::bigint) * 308) ELSE COALESCE(price, '0'::bigint) END >= '8000000'::bigint) AND (CASE WHEN ((currency)::text = 'EUR'::text) THEN (COALESCE(price, '0'::bigint) * 308) ELSE COALESCE(price, '0'::bigint) END <= '11000000'::bigint) AND (estatetype = ANY ('{1,2,12,13,14,15,3,4,5,18}'::integer[])))
  • Rows Removed by Filter: 84407