It depends on the solution, Loki for instance has support for it: https://grafana.com/blog/2019/08/13/lokis-path-to-ga-live-ta...

With that said unless you tune your query it's very easy to get overwhelmed once you scale a bit and start getting larger log volumes.

Not really, but then this isn't used for single service apps. It'd be difficult to tail anyway when your app grows beyond a few services.

Not really, that’s exactly what Papertrail does.

Clickhouse has experimental feature enabling a Watch https://clickhouse.com/docs/en/sql-reference/statements/watc...

Yes, but YMMV...

https://cloud.google.com/logging/docs/view/streaming-live-ta...