explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XSXm

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 15,935.981 ↑ 1.0 100 1

Limit (cost=1,187,889.09..1,187,889.34 rows=100 width=2,862) (actual time=15,935.918..15,935.981 rows=100 loops=1)

2. 15.766 15,935.955 ↑ 1.9 100 1

Sort (cost=1,187,889.09..1,187,889.57 rows=190 width=2,862) (actual time=15,935.916..15,935.955 rows=100 loops=1)

  • Sort Key: (COALESCE((property.services & 64), 0)) DESC, (date_trunc('day'::text, property.create_time)) DESC, property.ranking DESC
  • Sort Method: top-N heapsort Memory: 170kB
3. 15,920.189 15,920.189 ↓ 7.9 1,507 1

Seq Scan on property (cost=0.00..1,187,881.90 rows=190 width=2,862) (actual time=94.340..15,920.189 rows=1,507 loops=1)

  • Filter: ((NOT hidden) AND (floorspace >= 86) AND (floorspace <= 128) AND (id <> 2723195) AND (status = 1) AND ((city)::text = 'Budapest'::text) AND (CASE WHEN ((currency)::text = 'EUR'::text) THEN (COALESCE(price, '0'::bigint) * 308) ELSE COALESCE(price, '0'::bigint) END >= '57000000'::bigint) AND (CASE WHEN ((currency)::text = 'EUR'::text) THEN (COALESCE(price, '0'::bigint) * 308) ELSE COALESCE(price, '0'::bigint) END <= '85000000'::bigint) AND (estatetype = ANY ('{1,2,12,13,14,15,3,4,5,18}'::integer[])))
  • Rows Removed by Filter: 82939