| Unique (cost=19.80..19.80 rows=1 width=4) |
| -> Sort (cost=19.80..19.80 rows=1 width=4) |
| Sort Key: c.deduct_points_from |
| -> Nested Loop (cost=12.22..19.79 rows=1 width=4) |
| -> Hash Join (cost=11.94..16.35 rows=1 width=4) |
| Hash Cond: (crd.id = crr.remind_date_id) |
| -> Seq Scan on tbl_case_remind_dates crd (cost=0.00..3.75 rows=175 width=8) |
| -> Hash (cost=11.93..11.93 rows=1 width=4) |
| -> Seq Scan on tbl_case_remind_receivers crr (cost=0.00..11.93 rows=1 width=4) |
| Filter: (user_id = 1000) |
| -> Index Scan using tbl_cases_pkey on tbl_cases c (cost=0.28..3.43 rows=1 width=8) |
| Index Cond: (id = crd.case_id) |