Querying ABCI events

In order to write an application that understands Penumbra chain state, configure access to a pindexer database. More advanced use cases may require a custom implementation of the underlying cometindex (opens in a new tab) logic that powers pindexer.

Below are some examples to orient a developer to the structure of a pindexer database, which is intended to be more ergonomic for application development than the default CometBFT ABCI event schema.

Example: Total Supply Indexing

For example, after running pindexer, here's a query to get the total amount of the native staking token up to the current height:

SELECT (staked_um + unstaked_um + auction + dex)::NUMERIC / 10^6 as total
FROM (
  SELECT SUM(um) as staked_um
  FROM (
    SELECT * 
    FROM supply_validators
  ) validators
  LEFT JOIN LATERAL (
    SELECT um  
    FROM supply_total_staked
    WHERE validator_id = id 
    ORDER BY height DESC 
    LIMIT 1
  ) ON TRUE
) staked
LEFT JOIN LATERAL (
  SELECT um as unstaked_um, auction, dex 
  FROM supply_total_unstaked
  ORDER BY height DESC
  LIMIT 1
) on TRUE