call index/table represents ABI-translated (regular) transactions, which is the equivalent of the
event index for logs.
We will have the same for internal transactions hopefully soon, probably called
Outgoing transactions from your validator usually are benign validator reports. Whenever another validator is late or sends unexpected data, your node will automatically send a report transaction to the validator-set contract. You should also be able to see these in your node logs
Reported benign validator ... something
ALL transactions always result in at least one trace. For complex smart-contract interactions, it’s a complete call stack, but for a simple value transfer it’s just a single trace with the transferred volume. Therefore the trace/internal transaction table has information on everything that changed the blockchain state in some way.
Regarding the PostgreSQL database: There are indices on timestamp, block_number and from/to, so if you can limit your query, do so as early as possible, because the table is HUGE