| Aggregate (cost=55.58..55.59 rows=1 width=8) |
| -> Append (cost=12.87..55.47 rows=42 width=0) |
| -> Subquery Scan on "*SELECT* 1" (cost=12.87..24.20 rows=41 width=0) |
| -> Hash Anti Join (cost=12.87..23.79 rows=41 width=274) |
| Hash Cond: ((c.ledger_id = child.ledger_id) AND (c.id = child.parent_id)) |
| -> Seq Scan on tbl_ledger_account_captions c (cost=0.00..10.21 rows=44 width=8) |
| Filter: ((NOT is_delete) AND (NOT COALESCE(is_auxiliary_customer, false)) AND (NOT COALESCE(is_auxiliary_supplier, false)) AND (ledger_id = 1)) |
| -> Hash (cost=10.21..10.21 rows=177 width=8) |
| -> Seq Scan on tbl_ledger_account_captions child (cost=0.00..10.21 rows=177 width=8) |
| Filter: ((NOT is_delete) AND (ledger_id = 1)) |
| -> Subquery Scan on "*SELECT* 2" (cost=0.14..31.27 rows=1 width=0) |
| -> Nested Loop Anti Join (cost=0.14..31.26 rows=1 width=274) |
| Join Filter: ((child_1.ledger_id = c_1.ledger_id) AND (child_1.parent_id = c_1.id)) |
| -> Nested Loop (cost=0.14..18.39 rows=1 width=8) |
| Join Filter: ((c_1.is_auxiliary_customer AND (a.type = 1)) OR (c_1.is_auxiliary_supplier AND (a.type = 2))) |
| -> Seq Scan on tbl_ledger_account_captions c_1 (cost=0.00..10.21 rows=1 width=10) |
| Filter: ((NOT is_delete) AND (is_auxiliary_customer OR is_auxiliary_supplier) AND (ledger_id = 1)) |
| -> Index Scan using idx_tbl_ledger_auxiliary_items_ledger_serial_no on tbl_ledger_auxiliary_items a (cost=0.14..8.17 rows=1 width=10) |
| Index Cond: (ledger_id = 1) |
| Filter: ((NOT is_delete) AND ((type = 1) OR (type = 2))) |
| -> Seq Scan on tbl_ledger_account_captions child_1 (cost=0.00..10.21 rows=177 width=8) |
| Filter: ((NOT is_delete) AND (ledger_id = 1)) |