| Limit (cost=91.33..91.43 rows=40 width=162) |
| -> Sort (cost=91.33..91.43 rows=40 width=162) |
| Sort Key: e.wrote_date DESC, e.id DESC |
| -> Nested Loop Left Join (cost=3.23..90.26 rows=40 width=162) |
| Join Filter: (g.object_id = e.id) |
| Filter: ((g.success_count IS NULL) OR (g.success_count = 0)) |
| -> Seq Scan on tbl_erp_payment_tickets e (cost=0.00..86.08 rows=40 width=48) |
| Filter: ((wrote_date >= '2026-03-01'::date) AND (wrote_date <= '2026-07-31'::date) AND (amount > '0'::numeric) AND (status = 2)) |
| -> Materialize (cost=3.23..3.28 rows=1 width=24) |
| -> Subquery Scan on g (cost=3.23..3.28 rows=1 width=24) |
| -> GroupAggregate (cost=3.23..3.27 rows=1 width=36) |
| Group Key: v.object_type, v.object_id, (COALESCE((v.event_type)::integer, 0)), (COALESCE(v.event_id, 0)) |
| -> Sort (cost=3.23..3.23 rows=1 width=22) |
| Sort Key: v.object_id |
| -> Seq Scan on tbl_voucher_gen_items v (cost=0.00..3.22 rows=1 width=22) |
| Filter: ((ledger_id = 1) AND (object_type = 20012) AND (COALESCE(event_id, 0) = 0) AND (COALESCE((event_type)::integer, 0) = 0)) |