| Unique (cost=8112023884.51..8112023887.01 rows=200 width=16) |
| -> Sort (cost=8112023884.51..8112023885.01 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=8112023872.37..8112023876.87 rows=200 width=16) |
| Group Key: tt.dt |
| -> Nested Loop Left Join (cost=99.63..7863230436.99 rows=19903474830 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=19.59..6630425.80 rows=16368340 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=19.59..168794.64 rows=270878 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.58..436.90 rows=910 width=37) |
| -> Bitmap Heap Scan on tbl_schedules (cost=19.58..432.35 rows=910 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.35 rows=942 width=0) |
| Index Cond: (created_by = 5295) |
| -> Materialize (cost=0.00..514.16 rows=203 width=20) |
| -> Seq Scan on tbl_calendars c (cost=0.00..513.15 rows=203 width=20) |
| Filter: ((start_at IS NOT NULL) AND (end_at IS NOT NULL) AND (created_by = 5295)) |
| -> Materialize (cost=80.03..1425.66 rows=4085 width=24) |
| -> Bitmap Heap Scan on tbl_work_logs w (cost=80.03..1405.23 rows=4085 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..79.01 rows=4096 width=0) |
| Index Cond: (created_by = 5295) |