Aggregate (cost=154.00..154.01 rows=1 width=8) |
-> Nested Loop (cost=145.96..154.00 rows=1 width=0) |
-> Group (cost=145.68..145.68 rows=1 width=4) |
Group Key: r.id |
-> Sort (cost=145.68..145.68 rows=1 width=4) |
Sort Key: r.id |
-> Nested Loop (cost=0.28..145.67 rows=1 width=4) |
-> Seq Scan on tbl_reimbursement_settle_rels rsr (cost=0.00..137.05 rows=1 width=4) |
Filter: (user_id = 1000) |
-> Index Scan using tbl_reimbursements_pkey on tbl_reimbursements r (cost=0.28..8.30 rows=1 width=4) |
Index Cond: (id = rsr.reimbursement_id) |
Filter: (status = 2) |
-> Index Only Scan using tbl_reimbursements_pkey on tbl_reimbursements (cost=0.28..8.30 rows=1 width=4) |
Index Cond: (id = r.id) |