explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KWpH

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

Sort (cost=27.05..27.06 rows=3 width=104) (actual rows= loops=)

  • Sort Key: (date(created_at))
2. 0.000 0.000 ↓ 0.0

Seq Scan on events (cost=0.00..27.03 rows=3 width=104) (actual rows= loops=)

  • Filter: (((home_id = '1'::bigint) OR (home_id IS NULL)) AND (account_id = '2'::bigint) AND (level = ANY ('{1,2,3}'::integer[])) AND (date(created_at) >= '2020-05-31'::date) AND (date(created_at) <= '2020-07-05'::date))