# TXN\_Participation table in the indexer

**URL:** <https://forum.algorand.co/t/txn-participation-table-in-the-indexer/6936>\
**Category:** General\
**Tags:** indexer\
**Created:** [May 20, 2022, 12:51pm UTC](https://forum.algorand.co/t/txn-participation-table-in-the-indexer/6936 "2022-05-20T12:51:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Algo4](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@Algo4](https://forum.algorand.co/u/Algo4)\
**Post date:** [May 20, 2022, 12:51pm UTC](https://forum.algorand.co/t/txn-participation-table-in-the-indexer/6936/1 "2022-05-20T12:51:59Z")

</div>

Hi everyone

We are fairly new to the Algorand blockchain and started to work with the indexer and a Postgres database. However, we saw that there is the table txn\_participation. After some internet research, we did not find much information about this table. We also checked whether the general transaction reference [here](https://developer.algorand.org/docs/get-details/transactions/transactions/) says something about it, but we found nothing in there as well.

Looking at the name, we assume that it may have something to do with the participation in the consensus protocol.

Is this correct, or does this table represent something completely different?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![fabrice](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@fabrice](https://forum.algorand.co/u/fabrice)\
**Post date:** [June 2, 2022, 6:50pm UTC](https://forum.algorand.co/t/txn-participation-table-in-the-indexer/6936/2 "2022-06-02T18:50:15Z")

</div>

From [indexer/write\_txn\_participation.go at 11937cbb7c8ebf79b186dd91d7926c2738216ee2 · algorand/indexer · GitHub](https://github.com/algorand/indexer/blob/11937cbb7c8ebf79b186dd91d7926c2738216ee2/idb/postgres/internal/writer/write_txn_participation.go), my understanding is that it is a table that indicates all addresses that are “participating”/“appearing” in a transaction in a given round and transaction index.

This is not related to actual participation in consensus.

---

<div class="post-metadata">

**Author:** ![Algo4](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@Algo4](https://forum.algorand.co/u/Algo4)\
**Post date:** [June 3, 2022, 7:35am UTC](https://forum.algorand.co/t/txn-participation-table-in-the-indexer/6936/3 "2022-06-03T07:35:39Z")

</div>

Ah, now I see it. Thank you for your answer.