Timezone errors in self-hosted Langfuse

Langfuse requires all infrastructure components (ClickHouse and Postgres) to run in the UTC timezone. Non-UTC timezones are not supported and will cause queries to return incorrect or empty results.

If you are seeing missing traces or observations, verify that both databases are running in UTC.

Postgres

Check the effective timezone for the Postgres connection:

SHOW timezone;

This should return UTC. If it returns a different timezone, set the timezone parameter to UTC for the Postgres connections used by Langfuse, then restart Langfuse so that it opens new database connections.

ClickHouse

Check the ClickHouse server timezone:

SELECT timezone()

This should return UTC. If it returns a different timezone, update your ClickHouse server configuration to remove any custom timezone setting and restart the server.

If you would like us to consider supporting other timezones, please vote on this GitHub Discussion.