QUERY PLAN
Aggregate (cost=801.96..801.97 rows=1 width=8)
-> Sort (cost=801.93..801.94 rows=2 width=1766)
Sort Key: "*SELECT* 1".start_at DESC, "*SELECT* 1".ticket_id DESC
-> Result (cost=0.56..801.92 rows=2 width=1766)
-> Append (cost=0.56..801.90 rows=2 width=60)
-> Subquery Scan on "*SELECT* 1" (cost=0.56..125.23 rows=1 width=60)
-> Nested Loop Left Join (cost=0.56..125.22 rows=1 width=280)
-> Nested Loop (cost=0.29..116.91 rows=1 width=28)
-> Seq Scan on tbl_pre_sales p (cost=0.00..104.60 rows=1 width=24)
Filter: ((start_at IS NOT NULL) AND (end_at IS NOT NULL) AND (engineer_id IS NOT NULL) AND ((NOT is_draft) OR (is_draft IS NULL)) AND (end_at > start_at) AND (start_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (start_at <= '2026-12-31 23:59:59+08'::timestamp with time zone) AND (engineer_id = 1001))
-> Index Scan using tbl_cases_pkey on tbl_cases c (cost=0.29..8.30 rows=1 width=12)
Index Cond: (id = p.case_id)
Filter: (project_id = 4173)
-> Index Scan using tbl_clients_pkey on tbl_clients cl (cost=0.28..8.29 rows=1 width=8)
Index Cond: (id = COALESCE(p.client_id, c.client_id))
-> Subquery Scan on "*SELECT* 2" (cost=0.56..676.67 rows=1 width=60)
-> Nested Loop Left Join (cost=0.56..676.66 rows=1 width=280)
-> Nested Loop (cost=0.29..668.36 rows=1 width=28)
-> Seq Scan on tbl_implement_records i (cost=0.00..392.99 rows=44 width=20)
Filter: ((arrived_at IS NOT NULL) AND (left_at IS NOT NULL) AND ((NOT is_draft) OR (is_draft IS NULL)) AND (left_at > arrived_at) AND (arrived_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (arrived_at <= '2026-12-31 23:59:59+08'::timestamp with time zone))
-> Index Scan using tbl_cases_pkey on tbl_cases c_1 (cost=0.29..6.13 rows=1 width=16)
Index Cond: (id = i.case_id)
Filter: ((last_engineer IS NOT NULL) AND (project_id = 4173) AND (last_engineer = 1001))
-> Index Scan using tbl_clients_pkey on tbl_clients cl_1 (cost=0.28..8.29 rows=1 width=8)
Index Cond: (id = COALESCE(i.client_id, c_1.client_id))