| Limit (cost=9.00..9.01 rows=3 width=461) |
| -> Sort (cost=9.00..9.01 rows=3 width=461) |
| Sort Key: t.ticket_date, t.serial_no, i.sort, i.id |
| -> Nested Loop Left Join (cost=2.06..8.98 rows=3 width=461) |
| -> Nested Loop Left Join (cost=1.92..6.81 rows=3 width=93) |
| Filter: ((c.ledger_id = 1) OR (c.ledger_id IS NULL)) |
| -> Hash Join (cost=1.77..5.21 rows=3 width=69) |
| Hash Cond: (i.ledger_ticket_id = t.id) |
| -> Seq Scan on tbl_ledger_ticket_items i (cost=0.00..3.12 rows=112 width=59) |
| -> Hash (cost=1.76..1.76 rows=1 width=14) |
| -> Seq Scan on tbl_ledger_tickets t (cost=0.00..1.76 rows=1 width=14) |
| Filter: ((ticket_date >= '2026-06-01'::date) AND (ticket_date <= '2026-06-30'::date) AND (ledger_id = 1) AND (status = 1)) |
| -> Index Scan using tbl_ledger_account_captions_pkey on tbl_ledger_account_captions c (cost=0.14..0.52 rows=1 width=32) |
| Index Cond: (i.ledger_account_caption_id = id) |
| -> Index Scan using tbl_ledger_auxiliary_items_pkey on tbl_ledger_auxiliary_items a (cost=0.14..0.56 rows=1 width=308) |
| Index Cond: (i.auxiliary_item_id = id) |