gistfile1.txt

EXPLAIN ANALYZE
SELECT
	"id",
	"start",
	"end",
	"start_miliseconds_since_midnight" AS "startMilisecondsSinceMidnight",
	"end_miliseconds_since_midnight" AS "endMilisecondsSinceMidnight",
	"monday",
	"tuesday",
	"wednesday",
	"thursday",
	"friday",
	"saturday",
	"sunday",
	"status",
	"skip_dates",
	"created_at" AS "createdAt",
	"updated_at" AS "updatedAt"
FROM
	"schedules" AS "schedules"
WHERE ("schedules"."start" <= '2020-02-20 00:23:37.509 +00:00'
	OR("schedules"."wednesday" = TRUE
		AND "schedules"."start_miliseconds_since_midnight" <= 1417509
		AND "schedules"."end_miliseconds_since_midnight" >= 1417509))
AND "schedules"."status" = 'ACTIVE';




EXPLAIN ANALYZE
SELECT
	"id",
	"start",
	"end",
	"start_miliseconds_since_midnight" AS "startMilisecondsSinceMidnight",
	"end_miliseconds_since_midnight" AS "endMilisecondsSinceMidnight",
	"monday",
	"tuesday",
	"wednesday",
	"thursday",
	"friday",
	"saturday",
	"sunday",
	"status",
	"skip_dates",
	"created_at" AS "createdAt",
	"updated_at" AS "updatedAt"
FROM
	"schedules" AS "schedules"
WHERE ("schedules"."start" <= '2020-02-20 00:30:37.513 +00:00'
	OR("schedules"."wednesday" = TRUE
		AND "schedules"."start_miliseconds_since_midnight" <= 1837513
		AND "schedules"."end_miliseconds_since_midnight" >= 1837513))
AND "schedules"."status" = 'SCHEDULED';