@Prashant Shahi @Shrikanth ND Is there any query or metrics to check the number of pods in pending/faliure in k8s. Actually k8s pods phase. one metrics is there but that one os not giving pods phases.

Hey @sudhanshu dev, You can use

k8s.pod.phase

metrics in combination with

HAVING

of query builder. Current phase of the pod: • 1 - Pending • 2 - Running • 3 - Succeeded • 4 - Failed • 5 - Unknown The query below in the screenshot is used to list all succeeded pods. Replace

3

with

1

and

4

for pending and failed pods respectively.

cool

are you trying to use CH query for that?

Just for knowledge

Under

signoz_metrics

database, you should find tables with time series and samples metrics data.