pg_accumulator

pig build pkg pg_accumulator;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_accumulator;		# install via package name, for the active PG version

pig install pg_accumulator -v 18;   # install for PG 18
pig install pg_accumulator -v 17;   # install for PG 17
pig install pg_accumulator -v 16;   # install for PG 16
pig install pg_accumulator -v 15;   # install for PG 15
pig install pg_accumulator -v 14;   # install for PG 14

CREATE EXTENSION pg_accumulator CASCADE; -- requires plpgsql

CREATE EXTENSION pg_accumulator;

SELECT accum.register_create(
  name := 'inventory',
  dimensions := '{"warehouse": "int", "product": "int"}',
  resources := '{"quantity": "numeric", "amount": "numeric"}',
  kind := 'balance'
);

SELECT accum.register_post('inventory', '{
  "period": "2026-04-01",
  "document": "receipt:1",
  "dimensions": {"warehouse": 1, "product": 42},
  "resources": {"quantity": 10, "amount": 250}
}');

SELECT * FROM accum.inventory_balance(
  dimensions := '{"warehouse": 1, "product": 42}'
);

SELECT * FROM accum.inventory_turnover(
  from_date := '2026-04-01',
  to_date := '2026-04-30',
  dimensions := '{"warehouse": 1}',
  group_by := '["product"]'
);

SELECT accum.register_unpost('inventory', 'receipt:1');
SELECT accum.register_verify('inventory');