QUERY PLAN
Aggregate (cost=186.64..186.65 rows=1 width=8)
-> Nested Loop (cost=178.60..186.64 rows=1 width=0)
-> Group (cost=178.32..178.33 rows=1 width=4)
Group Key: r.id
-> Sort (cost=178.32..178.33 rows=1 width=4)
Sort Key: r.id
-> Nested Loop (cost=0.28..178.31 rows=1 width=4)
-> Seq Scan on tbl_reimbursement_settle_rels rsr (cost=0.00..125.29 rows=6 width=4)
Filter: (user_id = 5016)
-> 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)