[Feature Request]: Support show activity transaction list

[zhangxu19830126]

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

Ability to use statements to easily query the current system transaction information

Describe the feature you'd like

The support lists all the current transactions of the system, containing information in the following fields:

1. id
2. snapshot ts
3. creation time
4. current sql execution
5. whether it is waiting for a lock
6. whether it is running
7. create cn

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

[volgariver6]

dup with #11321 , close this one please.