in the below query total time is showing 23sec but the sum of all the spans duration count is not 23 sec, is there any missing spans, if there is any missing spans it should display the missing spans in the UI right ? or am i missing something

The "missing span" has a different meaning i.e, the span is created but never reached the SigNoz database. The big gap you see indicates there is no instrumented code in the program which is spending the most time.

ok Thanks @Srikanth Chekuri