| Group (cost=497.91..498.29 rows=76 width=4) |
| Group Key: u.id |
| -> Sort (cost=497.91..498.10 rows=76 width=4) |
| Sort Key: u.id |
| -> Hash Join (cost=15.15..495.53 rows=76 width=4) |
| Hash Cond: (p.user_id = u.id) |
| -> Bitmap Heap Scan on tbl_punch p (cost=5.92..486.06 rows=92 width=4) |
| Recheck Cond: ((day_at >= '2025-09-01'::date) AND (day_at <= '2025-09-19'::date)) |
| Filter: ((in_at IS NOT NULL) OR (out_at IS NOT NULL)) |
| -> Bitmap Index Scan on tbl_punch_pkey (cost=0.00..5.90 rows=161 width=0) |
| Index Cond: ((day_at >= '2025-09-01'::date) AND (day_at <= '2025-09-19'::date)) |
| -> Hash (cost=7.76..7.76 rows=117 width=4) |
| -> Seq Scan on tbl_users u (cost=0.00..7.76 rows=117 width=4) |
| Filter: (user_status = '-1'::type_global_user_status) |