https://signoz.io logo
Powered by
#support
Title
# support
s

Sumanth Balaji

10/19/2023, 7:33 AM
Need a quick confirmation consider the following output from executing a clickhouse query on clickhouse-client shell
Copy code
┌─────────────────────timestamp─┬─traceID──────────────────────────┬─serviceName──────────┬─name──────────────────────────────────┬─durationNano─┐
│ 2023-10-18 06:31:22.013556377 │ 5d12acb2b83f6f3d68c998377c873d5f │ Prod-PostNlpNotifier │ GET                                   │     46539987 │
│ 2023-10-18 06:31:22.060526394 │ 5d12acb2b83f6f3d68c998377c873d5f │ Prod-PostNlpNotifier │ PUT                                   │     76430081 │
│ 2023-10-18 06:31:22.013369223 │ 5d12acb2b83f6f3d68c998377c873d5f │ Prod-PostNlpNotifier │ webhook-post-nlp-notifier-alt process │    123598772 │
There are the entries for traceID 5d12acb2b83f6f3d68c998377c873d5f from serviceName Prod-PostNlpNotifier Question is: 1. The value for timestamp. What does that indicate? does that indicate when the trace first encountered prod-postnlpnotifier? a. Does that mean to get the timestamp for when the trace is exiting the service is to do timestamp+durationNano ?
@Srikanth Chekuri
s

Srikanth Chekuri

10/19/2023, 7:39 AM
How did you get the timestamp? If the timestamp is the start span start time, then yes timestamp+durationNano is the exit time.
s

Sumanth Balaji

10/19/2023, 7:44 AM
Copy code
SELECT
    timestamp,
    traceID,
    serviceName,
    durationNano
FROM signoz_traces.distributed_signoz_index_v2
WHERE (traceID IN ('5d12acb2b83f6f3d68c998377c873d5f')) AND (serviceName IN ('Prod-ingestion-wh-consumer', 'Prod-PostNlpNotifier'))
timestamp is from the signoz_traces.distributed_signoz_index_v2 table hence the question
what does it indicate ?
s

Srikanth Chekuri

10/19/2023, 7:52 AM
It indicate start time of span
s

Sumanth Balaji

10/19/2023, 7:58 AM
as in when the trace had reached the service ?
if so, i think thats wrong
s

Srikanth Chekuri

10/19/2023, 7:59 AM
What do you mean by trace had reached the service?
A span starts at some point and ends when the operation is completed. The timestamp here indicated when it started.
s

Sumanth Balaji

10/19/2023, 8:03 AM
@Srikanth Chekuri possible to have a quick huddle? because i think the trace timeseries view seems to say different story would be 10mins max, only 1 question
s

Srikanth Chekuri

10/19/2023, 8:04 AM
You can post screenshots here. I am not in a position to join call.
Powered by