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) |