| Limit (cost=18.46..18.51 rows=20 width=140) |
| -> Sort (cost=18.46..18.60 rows=54 width=140) |
| Sort Key: r.created_at DESC |
| -> HashAggregate (cost=16.49..17.03 rows=54 width=140) |
| Group Key: r.id |
| -> Hash Left Join (cost=9.98..16.35 rows=54 width=140) |
| Hash Cond: (r.id = crvr.punch_leave_id) |
| -> Hash Right Join (cost=8.69..14.80 rows=54 width=140) |
| Hash Cond: (rccr.punch_leave_id = r.id) |
| Filter: ((r.created_by = 1011) OR (rccr.user_id = 1011) OR (rvr.user_id = 1011)) |
| -> Seq Scan on tbl_punch_leave_carbon_copy_rels rccr (cost=0.00..2.59 rows=159 width=8) |
| -> Hash (cost=7.16..7.16 rows=122 width=144) |
| -> Hash Right Join (cost=4.61..7.16 rows=122 width=144) |
| Hash Cond: (rvr.punch_leave_id = r.id) |
| -> Seq Scan on tbl_punch_leave_verify_rels rvr (cost=0.00..2.22 rows=122 width=8) |
| -> Hash (cost=3.16..3.16 rows=116 width=140) |
| -> Seq Scan on tbl_punch_leaves r (cost=0.00..3.16 rows=116 width=140) |
| -> Hash (cost=1.13..1.13 rows=13 width=4) |
| -> Seq Scan on tbl_punch_leave_cancel_verify_rels crvr (cost=0.00..1.13 rows=13 width=4) |