| Unique (cost=23.27..23.28 rows=1 width=4) |
| -> Sort (cost=23.27..23.27 rows=1 width=4) |
| Sort Key: c.deduct_points_from |
| -> Nested Loop (cost=15.37..23.26 rows=1 width=4) |
| -> Hash Join (cost=15.09..20.08 rows=1 width=4) |
| Hash Cond: (crd.id = crr.remind_date_id) |
| -> Seq Scan on tbl_case_remind_dates crd (cost=0.00..4.17 rows=217 width=8) |
| -> Hash (cost=15.08..15.08 rows=1 width=4) |
| -> Seq Scan on tbl_case_remind_receivers crr (cost=0.00..15.08 rows=1 width=4) |
| Filter: (user_id = 1000) |
| -> Index Scan using tbl_cases_pkey on tbl_cases c (cost=0.28..3.18 rows=1 width=8) |
| Index Cond: (id = crd.case_id) |