QUERY PLAN
HashAggregate (cost=6.32..6.65 rows=22 width=68)
Group Key: i.ledger_account_caption_id
-> Hash Join (cost=2.04..5.48 rows=112 width=12)
Hash Cond: (i.ledger_ticket_id = t.id)
-> Seq Scan on tbl_ledger_ticket_items i (cost=0.00..3.12 rows=112 width=16)
-> 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))