Voltaire decentralized on-chain governance

Cardano is heading fast towards implementing decentralized on-chain governance. In a recent workshop the smart contracts and transactions for this implementation have been verified and tested. A few transactions also hit mainnet and can be queried there.

The underlying Cardano Improvement Process (CIP) submission is 1694. This is also the key that transaction metadata will be annotated with.

Let's query for such transactions on our Cardano-on-BigQuery:

SELECT epoch_no, key, COUNT(*) FROM `blockchain-analytics-392322.cardano_mainnet.tx_metadata` 
WHERE epoch_no >= 565
  AND key = 1694
GROUP BY epoch_no, key
ORDER BY epoch_no, key;

-- result:
-- epoch_no  key  f0_
--   565    1694   7

The query on BigQuery is finishing very fast and consumes very little credits due to clustering by epoch_no and key.

Or alternatively, on PostgreSQL (db-sync):

SELECT b.epoch_no, tm.key, COUNT(*)
FROM public.tx_metadata tm
JOIN public.tx tx ON tx.id = tm.tx_id
JOIN public.block b ON b.id = tx.block_id
WHERE tm.key = 1694
  AND b.epoch_no >= 565
GROUP BY b.epoch_no, tm.key
ORDER BY b.epoch_no, tm.key;

-- result: 
-- "epoch_no"  "key"  "count"
--     565     1694      7