| HashAggregate (cost=6.18..6.45 rows=18 width=68) |
| Group Key: i.ledger_account_caption_id |
| -> Hash Join (cost=2.04..5.95 rows=30 width=12) |
| Hash Cond: (i.ledger_ticket_id = t.id) |
| -> Seq Scan on tbl_ledger_ticket_items i (cost=0.00..3.82 rows=30 width=16) |
| Filter: (ledger_account_caption_id = ANY ('{68,83,88,92,3}'::integer[])) |
| -> Hash (cost=1.57..1.57 rows=38 width=4) |
| -> Seq Scan on tbl_ledger_tickets t (cost=0.00..1.57 rows=38 width=4) |
| Filter: ((ledger_id = 1) AND (status = 1)) |