QUERY PLAN
Aggregate (cost=13.34..13.35 rows=1 width=48)
-> HashAggregate (cost=12.67..12.81 rows=14 width=252)
Group Key: r.id
-> Hash Left Join (cost=8.63..12.64 rows=14 width=6)
Hash Cond: (r.id = crvr.punch_away_id)
-> Hash Right Join (cost=7.56..11.51 rows=14 width=6)
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=7.39..7.39 rows=14 width=10)
-> Seq Scan on tbl_punch_aways r (cost=0.00..7.39 rows=14 width=10)
Filter: (created_by = 1000)
-> Hash (cost=1.03..1.03 rows=3 width=4)
-> Seq Scan on tbl_punch_away_cancel_verify_rels crvr (cost=0.00..1.03 rows=3 width=4)