| Sort (cost=16.36..16.36 rows=1 width=168) |
| Sort Key: tbl_ledger_auxiliary_opening_balances.sort, tbl_ledger_auxiliary_opening_balances.id |
| -> Nested Loop (cost=0.29..16.34 rows=1 width=168) |
| Join Filter: (tbl_ledger_auxiliary_opening_balances.auxiliary_item_id = tbl_ledger_auxiliary_items.id) |
| -> Index Scan using idx_tbl_ledger_auxiliary_opening_balances_unique_item on tbl_ledger_auxiliary_opening_balances (cost=0.15..8.17 rows=1 width=168) |
| Index Cond: ((ledger_id = 1) AND (ledger_account_caption_id = 170)) |
| -> Index Scan using idx_tbl_ledger_auxiliary_items_ledger_serial_no on tbl_ledger_auxiliary_items (cost=0.14..8.16 rows=1 width=4) |
| Index Cond: (ledger_id = 1) |
| Filter: (type = ANY ('{1,2}'::integer[])) |