Aggregate (cost=257.06..257.07 rows=1 width=8) |
-> Nested Loop (cost=249.02..257.05 rows=1 width=0) |
-> Group (cost=248.73..248.74 rows=1 width=4) |
Group Key: r.id |
-> Sort (cost=248.73..248.74 rows=1 width=4) |
Sort Key: r.id |
-> Seq Scan on tbl_reimbursements r (cost=0.00..248.72 rows=1 width=4) |
Filter: ((status = 0) AND (created_by = 1001)) |
-> Index Only Scan using tbl_reimbursements_pkey on tbl_reimbursements (cost=0.28..8.30 rows=1 width=4) |
Index Cond: (id = r.id) |