#support

Discussion on Clickhouse Query Timestamp Interpretation

TLDR Sumanth asked for clarification about timestamp interpretation in a Clickhouse query and its relation to service delay. Srikanth explained it as the start time, but Sumanth expressed doubts.

1mo

Join the chat

Oct 19, 2023 (1 month ago)

Photo of md5-07768ef83001945fa11999d47869ac32

Sumanth

07:33 AM

Need a quick confirmation
consider the following output from executing a clickhouse query on clickhouse-client shell

┌─────────────────────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 ?

07:35

Sumanth

07:35 AM

Srikanth

Photo of md5-ce04a9988e2fd758a659dc55be6f2543

Srikanth

07: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.

Sumanth

07:44 AM

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'))

07:45

Sumanth

07:45 AM

timestamp is from the signoz_traces.distributed_signoz_index_v2 table
hence the question

07:45

Sumanth

07:45 AM

what does it indicate ?

Srikanth

07:52 AM

It indicate start time of span

Sumanth

07:58 AM

as in when the trace had reached the service ?

07:58

Sumanth

07:58 AM

if so, i think thats wrong

Srikanth

07:59 AM

What do you mean by trace had reached the service?

07:59

Srikanth

07:59 AM

A span starts at some point and ends when the operation is completed. The timestamp here indicated when it started.

Sumanth

08:03 AM

Srikanth 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

Srikanth

08:04 AM

You can post screenshots here. I am not in a position to join call.

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 1023 threads (61% resolved)

Join Our Community

Similar Threads

Services UI Goes Blank Due to Retention Issue with S3 Bucket

oluchi reports issue with services UI going blank after a while. Conversation explores possible reasons, such as S3 connection problems and disk space, but no resolution is reached.

7mo

Issues with SigNoz Setup and Data Persistence in AKS

Vaibhavi experienced issues setting up SigNoz in AKS, and faced data persistence issues after installation. Srikanth provided guidance on ClickHouse version compatibility and resource requirements, helping Vaibhavi troubleshoot and resolve the issue.

8mo

Incorrect Alert Firing Issue in Threshold Condition

Harshith.R.S is experiencing an issue with alerts firing when the value is above the threshold. The issue remains unresolved after trying different query modifications suggested by Amol.

9mo

Dashboard Load Issues and Possible Solutions

Al experiences dashboard loading issues since updating to `0.18.1`. Srikanth believes the issue is not version related and suggests examining queries, memory resources, and server distribution for improvements.

7mo

Clickhouse Query Timeout in SigNoz Dashboard

Daniel experienced query timeouts in SigNoz dashboard. vishal-signoz confirmed it's a non-configurable 60s limit, but created a GitHub issue for adding the feature.

8mo