Generate ClickHouse stats ↗

Documentation Index#

Fetch the complete documentation index at: https://docs.langchain.com/llms.txt Use this file to discover all available pages before exploring further.

As part of troubleshooting your self-hosted instance of LangSmith, the LangChain team may ask you to generate Clickhouse statistics that will help us understand memory and CPU consumption and connection concurrency.

This command will generate a CSV that can be shared with the LangChain team.

Prerequisites#

Ensure you have the following tools/items ready.

1. kubectl

   • https://kubernetes.io/docs/tasks/tools/

2. Clickhouse database credentials

   • Host
   • Port
   • Username

• If using the bundled version, this is default
  • Password
• If using the bundled version, this is password
  • Database name
• If using the bundled version, this is default

3. Connectivity to the Clickhouse database from the machine you will be running the get_clickhouse_stats script on.

   • If you are using the bundled version, you may need to port forward the clickhouse service to your local machine.
   • Run kubectl port-forward svc/langsmith-clickhouse 8123:8123 to port forward the clickhouse service to your local machine.

4. The script to generate ClickHouse stats

   • You can download the script from here

Running the clickhouse stats generation script#

Run the following command to run the stats generation script:

sh get_clickhouse_stats.sh <clickhouse_url> --output path/to/file.csv

For example, if you are using the bundled version with port-forwarding, the command would look like:

sh get_clickhouse_stats.sh "clickhouse://default:password@localhost:8123/default" --output clickhouse_stats.csv

and after running this command you should see a file, clickhouse_stats.csv, has been created with Clickhouse statistics.

Edit this page on GitHub or file an issue.

Connect these docs to Claude, VSCode, and more via MCP for real-time answers.