https://signoz.io logo
Join Slack
Powered by
Need a quick confirmation consider the following o...
# support
s
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
How did you get the timestamp? If the timestamp is the start span start time, then yes timestamp+durationNano is the exit time.
s
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
It indicate start time of span
s
as in when the trace had reached the service ?
if so, i think thats wrong
s
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
@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
You can post screenshots here. I am not in a position to join call.
Open in Slack
PreviousNext
Powered by