Implement 'status' CLI for monitoring

[Otaiki1]

Context

Operators need quick insight into indexer performance.

Goal

Add a command to show current lag, event throughput, and DB stats.

Contributor guide

1. Directory: indexer/
2. Display: Current ledger vs Horizon ledger, Processed events count, DB pool status.
3. Support JSON output for scripts.
4. Add watch mode (--watch).

References

• monitoring/status section.

[ayush99336]

@ayush99336 has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

Greetings! I have experience with Backend development and CLI tools and can handle this monitoring task. I’ve reviewed the requirements for the status command in the indexer directory, and I’m ready to implement the ledger lag tracking, event throughput, and DB pool stats with support for JSON output and watch mode. I estimate about 2 hours to complete the implementation and ensure it integrates well with the existing monitoring section.

I’d like to start work on this as soon as you assign it to me. Thank you, looking forward to working with you!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ayush99336 to this issue.