Investigate charm profiles and span profiles

[michaeldmitry]

Enhancement Proposal

Reference: https://grafana.com/docs/pyroscope/latest/configure-client/trace-span-profiles/python-span-profiles/

Span profiles are a powerful feature that we should consider exploring to see how they can be leveraged in our charms.