| Unique (cost=8881314725.61..8881314728.11 rows=200 width=16) |
| -> Sort (cost=8881314725.61..8881314726.11 rows=200 width=16) |
| Sort Key: (date(tt.dt)) DESC, (CASE WHEN (count(c.id) <> 0) THEN true ELSE false END), (CASE WHEN (count(tbl_schedules.id) <> 0) THEN true ELSE false END), (CASE WHEN (count(w.id) <> 0) THEN true ELSE false END) |
| -> HashAggregate (cost=8881314713.46..8881314717.96 rows=200 width=16) |
| Group Key: tt.dt |
| -> Nested Loop Left Join (cost=106.02..8608914227.75 rows=21792038857 width=20) |
| Join Filter: ((((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone >= w.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone <= w.end_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= w.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= w.start_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= w.end_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= w.end_at))) |
| -> Nested Loop Left Join (cost=20.00..6831808.29 rows=16856827 width=16) |
| Join Filter: ((((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone >= c.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone <= c.end_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= c.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= c.start_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= c.end_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= c.end_at))) |
| -> Nested Loop Left Join (cost=20.00..177308.81 rows=284571 width=12) |
| Join Filter: ((((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone >= CASE WHEN (tbl_schedules.start_at IS NULL) THEN CASE WHEN (tbl_schedules.end_at < now()) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE tbl_schedules.end_at END ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE now() END END ELSE tbl_schedules.start_at END) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone <= CASE WHEN (tbl_schedules.end_at IS NULL) THEN CASE WHEN (tbl_schedules.start_at > now()) THEN tbl_schedules.start_at ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END END ELSE CASE WHEN ((tbl_schedules.start_at IS NULL) AND (tbl_schedules.end_at < now())) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END ELSE tbl_schedules.end_at END END)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= CASE WHEN (tbl_schedules.start_at IS NULL) THEN CASE WHEN (tbl_schedules.end_at < now()) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE tbl_schedules.end_at END ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE now() END END ELSE tbl_schedules.start_at END) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= CASE WHEN (tbl_schedules.start_at IS NULL) THEN CASE WHEN (tbl_schedules.end_at < now()) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE tbl_schedules.end_at END ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.created_at ELSE now() END END ELSE tbl_schedules.start_at END)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= CASE WHEN (tbl_schedules.end_at IS NULL) THEN CASE WHEN (tbl_schedules.start_at > now()) THEN tbl_schedules.start_at ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END END ELSE CASE WHEN ((tbl_schedules.start_at IS NULL) AND (tbl_schedules.end_at < now())) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END ELSE tbl_schedules.end_at END END) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= CASE WHEN (tbl_schedules.end_at IS NULL) THEN CASE WHEN (tbl_schedules.start_at > now()) THEN tbl_schedules.start_at ELSE CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END END ELSE CASE WHEN ((tbl_schedules.start_at IS NULL) AND (tbl_schedules.end_at < now())) THEN CASE WHEN tbl_schedules.is_complete THEN tbl_schedules.complete_at ELSE now() END ELSE tbl_schedules.end_at END END))) |
| -> Function Scan on generate_series tt (cost=0.02..10.02 rows=1000 width=8) |
| -> Materialize (cost=19.98..441.18 rows=956 width=37) |
| -> Bitmap Heap Scan on tbl_schedules (cost=19.98..436.40 rows=956 width=37) |
| Recheck Cond: (created_by = 5295) |
| Filter: ((start_at IS NOT NULL) OR (end_at IS NOT NULL)) |
| -> Bitmap Index Scan on tbl_schedules_created_by_idx (cost=0.00..19.74 rows=994 width=0) |
| Index Cond: (created_by = 5295) |
| -> Materialize (cost=0.00..518.57 rows=199 width=20) |
| -> Seq Scan on tbl_calendars c (cost=0.00..517.58 rows=199 width=20) |
| Filter: ((start_at IS NOT NULL) AND (end_at IS NOT NULL) AND (created_by = 5295)) |
| -> Materialize (cost=86.02..1470.15 rows=4343 width=24) |
| -> Bitmap Heap Scan on tbl_work_logs w (cost=86.02..1448.44 rows=4343 width=24) |
| Recheck Cond: (created_by = 5295) |
| Filter: ((start_at IS NOT NULL) AND (end_at IS NOT NULL) AND (NOT is_draft)) |
| -> Bitmap Index Scan on tbl_work_logs_created_by_idx (cost=0.00..84.94 rows=4353 width=0) |
| Index Cond: (created_by = 5295) |