[release-v2.6] [DOC] Update metrics query docs with examples, more details #9437

Job	Run time
Benchmark	2m 23s
Lint	2m 23s
Build	1m 43s
Run integration tests (test-e2e)	2m 22s
Run integration tests (test-integration-poller)	2m 22s
Run Unit Tests (test-with-cover-pkg)	2m 23s
Vendor check	1m 24s
Run integration tests (test-e2e-deployments)	2m 22s
Build technical documentation	22s
Run Unit Tests (test-with-cover-tempodb)	2m 23s
Run integration tests (test-e2e-serverless)	2m 23s
Run Unit Tests (test-with-cover-tempodb-wal)	2m 21s
Check jsonnet & tempo-mixin	49s
Run Unit Tests (test-with-cover-others)	2m 22s
	28m 2s

Provide feedback