Back

SQL Explained

Executed SQL
EXPLAIN SELECT ••• "bdex_campaign"."id" FROM "bdex_campaign" WHERE ("bdex_campaign"."starts_at" > '2017-04-21 20:06:54.458888' AND "bdex_campaign"."editorial_state" IN (70, 160)) ORDER BY "bdex_campaign"."starts_at" ASC, "bdex_campaign"."ordering" ASC
Time
4.22 ms
Database
default
QUERY PLAN
Sort (cost=758.39..758.40 rows=1 width=16)
Sort Key: starts_at, ordering
-> Seq Scan on bdex_campaign (cost=0.00..758.38 rows=1 width=16)
Filter: ((starts_at > '2017-04-21 20:06:54.458888+08'::timestamp with time zone) AND (editorial_state = ANY ('{70,160}'::integer[])))