| Aggregate (cost=14.62..14.63 rows=1 width=8) |
| -> Sort (cost=14.61..14.61 rows=1 width=252) |
| Sort Key: r.created_at DESC |
| -> Group (cost=14.59..14.60 rows=1 width=252) |
| Group Key: r.id |
| -> Sort (cost=14.59..14.59 rows=1 width=12) |
| Sort Key: r.id |
| -> Nested Loop Left Join (cost=9.40..14.58 rows=1 width=12) |
| Join Filter: (crvr.punch_away_id = r.id) |
| -> Hash Right Join (cost=9.40..13.51 rows=1 width=12) |
| Hash Cond: (rvr.punch_away_id = r.id) |
| -> Seq Scan on tbl_punch_away_verify_rels rvr (cost=0.00..3.53 rows=153 width=4) |
| -> Hash (cost=9.39..9.39 rows=1 width=12) |
| -> Hash Join (cost=1.75..9.39 rows=1 width=12) |
| Hash Cond: (r.id = rccr.punch_away_id) |
| -> Seq Scan on tbl_punch_aways r (cost=0.00..6.91 rows=191 width=16) |
| -> Hash (cost=1.74..1.74 rows=1 width=4) |
| -> Seq Scan on tbl_punch_away_carbon_copy_rels rccr (cost=0.00..1.74 rows=1 width=4) |
| Filter: (user_id = 1000) |
| -> Seq Scan on tbl_punch_away_cancel_verify_rels crvr (cost=0.00..1.03 rows=3 width=4) |