🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa123)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa089.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations\')), getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/clickhouse.com\/videos\/lost-in-the-haystack-optimizing-high-cardinality-aggregations","crawl_time":1772534948,"first_indexed_time":1717876793,"http_code":200,"src_unparsed":"com,clickhouse!\/videos\/lost-in-the-haystack-optimizing-high-cardinality-aggregations s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"Lost in the Haystack - Optimizing High Cardinality Aggregations","meta_descriptions":[""],"attrs_boilerpipe_text":"Download full logo\nDownload logomark\nEnglish\nJapanese\nProducts\nProducts\nClickHouse Cloud\nThe best way to use ClickHouse.\nAvailable on AWS, GCP, and Azure.\nBring Your Own Cloud\nA fully managed ClickHouse service,\ndeployed in your own AWS and GCP account.\nPostgres managed by ClickHouse\nUnified data stack for transactions\nand analytics.\nManaged ClickStack\nManaged observability with high-performance\nqueries and long-term retention.\nLangfuse Cloud\nLLM observability and evaluations\nfor reliable AI applications and agents.\nOpen source\nClickHouse\nFast open-source OLAP database for\nreal-time analytics.\nClickStack\nOpen-source observability stack for logs,\nmetrics, traces, and session replays.\nAgentic Data Stack\nBuild AI-powered applications\nwith ClickHouse.\nSolutions\nUse cases\nReal-time analytics\nObservability\nData warehousing\nMachine learning and GenAI\nAll use cases\nAll use cases \n->\n->\nIndustries\nCybersecurity\nGaming and entertainment\nE-commerce and retail\nAutomotive\nEnergy\nAll industries\nAll industries \n->\n->\nDocs\nResources\nUser stories\nBlog\nEvents\nNews\nLearning and certification\nComparisons\nBenchmark hub\nBigQuery\nPostgreSQL\nRedshift\nSnowflake\nElastic Observability\nSplunk\nOpenSearch\nFor observability\nVideos\nDemos\nPricing\nContact us\nEnglish\nJapanese\n46.1k\nSign in\nVideos\nMeetups\nPrevious video\nScaling ClickHouse to petabytes of logs at OpenAI\nNext video\nClickHouse v24.5 Community Call\nColton Allen,\nSentry.io\nThis presentation was given at the ClickHouse Community Meetup in San Francisco -\nhttps:\/\/www.meetup.com\/clickhouse-silicon-valley-meetup-group\/events\/296334923\/\nIf you are interested in attending a future event, please join a Meetup Group near you at\nhttps:\/\/www.meetup.com\/pro\/clickhouse\nTo get started with ClickHouse, visit\nhttps:\/\/clickhouse.com\/\nto download or start a free ClickHouse Cloud Trial\nRecent videos\nMeetups\nClickhouse Meetups NYC Moment\nPresented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup.\nMeetups\nClickhouse Meetups NYC Gliss.sh\nPresented by  Ryan Adami @ Gliss.sh at our New York Meetup.\nMeetups\nClickhouse Meetups NYC Clay\nPresented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup.\nFollow us\nX\nBluesky\nSlack\nGitHub\nTelegram\nMeetup\nRss","attrs_markdown":"[![ClickHouse logo](https:\/\/clickhouse.com\/_next\/static\/media\/logo-full.ac8102d5.svg)](https:\/\/clickhouse.com\/)\n\nCopy logo as SVG\n\n[Download full logo](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logo.zip)[Download logomark](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logomark.zip)\n\nOpen search\n\nOpen region selector\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\nOpen menu\n\n- [Products](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Products**\n  \n  - [![ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [![ClickHouse BYOC](https:\/\/clickhouse.com\/images\/nav\/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS and GCP account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [![Postgres ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https:\/\/clickhouse.com\/cloud\/postgres)\n  - [![Managed ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [![Langfuse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https:\/\/langfuse.com\/?utm_source=clickhouse_topnav)\n  \n  **Open source**\n  \n  - [![ClickHouse](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https:\/\/clickhouse.com\/clickhouse)\n  - [![ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https:\/\/clickhouse.com\/clickstack)\n  - [![Agentic Data Stack](https:\/\/clickhouse.com\/images\/nav\/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https:\/\/clickhouse.com\/ai)\n- [Solutions](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Use cases**\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Observability](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [Data warehousing](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Machine learning and GenAI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases \\-\\>\\-\\>](https:\/\/clickhouse.com\/use-cases)\n  \n  **Industries**\n  \n  - [Cybersecurity](https:\/\/clickhouse.com\/industries\/cybersecurity)\n  - [Gaming and entertainment](https:\/\/clickhouse.com\/industries\/gaming)\n  - [E-commerce and retail](https:\/\/clickhouse.com\/industries\/retail)\n  - [Automotive](https:\/\/clickhouse.com\/industries\/automotive)\n  - [Energy](https:\/\/clickhouse.com\/industries\/energy)\n  - [All industries](https:\/\/clickhouse.com\/industries)\n  \n  [All industries \\-\\>\\-\\>](https:\/\/clickhouse.com\/industries)\n- [Docs](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [News](https:\/\/clickhouse.com\/company\/news)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparisons](https:\/\/clickhouse.com\/videos\/lost-in-the-haystack-optimizing-high-cardinality-aggregations)\n    - [Benchmark hub](https:\/\/clickhouse.com\/benchmarks)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n    - [Elastic Observability](https:\/\/clickhouse.com\/comparison\/elastic-for-observability)\n    - [Splunk](https:\/\/clickhouse.com\/comparison\/splunk-for-observability)\n    - [OpenSearch For observability](https:\/\/clickhouse.com\/comparison\/opensearch-for-observability)\n  - [Videos](https:\/\/clickhouse.com\/videos)\n  - [Demos](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact us](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\nOpen search\n\nOpen region selector\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\n[46\\.1k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=nav-get-started)\n\n- [Videos](https:\/\/clickhouse.com\/videos)\n- \/\n- [Meetups](https:\/\/clickhouse.com\/videos?category=meetups)\n# Lost in the Haystack - Optimizing High Cardinality Aggregations\n\n[**Previous video**Scaling ClickHouse to petabytes of logs at OpenAI](https:\/\/clickhouse.com\/videos\/openai)\n\n[**Next video**ClickHouse v24.5 Community Call](https:\/\/clickhouse.com\/videos\/community-call-24-05)\n\n## Colton Allen, Sentry.io\nThis presentation was given at the ClickHouse Community Meetup in San Francisco - <https:\/\/www.meetup.com\/clickhouse-silicon-valley-meetup-group\/events\/296334923\/>\n\nIf you are interested in attending a future event, please join a Meetup Group near you at <https:\/\/www.meetup.com\/pro\/clickhouse>\n\nTo get started with ClickHouse, visit <https:\/\/clickhouse.com\/> to download or start a free ClickHouse Cloud Trial\n\n## Recent videos\n[View all Videos](https:\/\/clickhouse.com\/videos)\n\n[![YouTube Video: geit7C3RuwQ](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2Fgeit7C3RuwQ%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Moment Presented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupny20263)\n\n[![YouTube Video: fScr9GXB1t8](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FfScr9GXB1t8%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Gliss.sh Presented by Ryan Adami @ Gliss.sh at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupnyjan20262)\n\n[![YouTube Video: LeomE29B1cY](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FLeomE29B1cY%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Clay Presented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupnyjan20261)\n\nFollow us\n\n[![X](https:\/\/clickhouse.com\/socials\/x.svg)X](https:\/\/x.com\/ClickhouseDB \"X\")[![Bluesky](https:\/\/clickhouse.com\/socials\/bluesky.svg)Bluesky](https:\/\/bsky.app\/profile\/clickhouse.com \"Bluesky\")[![Slack](https:\/\/clickhouse.com\/socials\/slack.svg)Slack](https:\/\/clickhouse.com\/slack \"Slack\")\n\n[![GitHub](https:\/\/clickhouse.com\/socials\/github.svg)GitHub](https:\/\/github.com\/ClickHouse\/ClickHouse \"GitHub\")[![Telegram](https:\/\/clickhouse.com\/socials\/telegram.svg)Telegram](https:\/\/telegram.me\/clickhouse_en \"Telegram\")[![Meetup](https:\/\/clickhouse.com\/socials\/meetup.svg)Meetup](https:\/\/www.meetup.com\/pro\/clickhouse \"Meetup\")\n\n[![Rss](https:\/\/clickhouse.com\/socials\/rss.svg)Rss](https:\/\/clickhouse.com\/rss.xml \"Rss\")\n\n- - Product\n  - [ClickHouse Cloud](https:\/\/clickhouse.com\/cloud)\n  - [Bring Your Own Cloud](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [Postgres managed by ClickHouse](https:\/\/clickhouse.com\/cloud\/postgres)\n  - [Managed ClickStack](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [ClickStack](https:\/\/clickhouse.com\/clickstack)\n  - [Agentic Data Stack](https:\/\/clickhouse.com\/ai)\n  - [ClickHouse Government](https:\/\/clickhouse.com\/government)\n  - [ClickHouse Keeper](https:\/\/clickhouse.com\/clickhouse\/keeper)\n  - [ClickPipes](https:\/\/clickhouse.com\/cloud\/clickpipes)\n  - [Integrations](https:\/\/clickhouse.com\/integrations)\n  - [chDB](https:\/\/clickhouse.com\/chdb)\n  - [Pricing](https:\/\/clickhouse.com\/pricing)\n- - Resources\n  - [Documentation](https:\/\/clickhouse.com\/docs)\n  - [Trust center](https:\/\/trust.clickhouse.com\/)\n  - [Training](https:\/\/clickhouse.com\/learn)\n  - [Support](https:\/\/clickhouse.com\/support\/program)\n  - [Benchmarks](https:\/\/clickhouse.com\/benchmarks)\n  - [Use cases](https:\/\/clickhouse.com\/use-cases)\n  - [Videos](https:\/\/clickhouse.com\/videos)\n  - [Demos](https:\/\/clickhouse.com\/demos)\n  - [Presentations](https:\/\/presentations.clickhouse.com\/)\n  - [Real-time data warehouse](https:\/\/clickhouse.com\/real-time-data-warehouse)\n  - [Engineering resources](https:\/\/clickhouse.com\/resources\/engineering)\n- - Company\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Our story](https:\/\/clickhouse.com\/company\/our-story)\n  - [Careers](https:\/\/clickhouse.com\/company\/careers)\n  - [Contact us](https:\/\/clickhouse.com\/company\/contact?loc=footer)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [News](https:\/\/clickhouse.com\/company\/news)\n  - [Media](https:\/\/clickhouse.com\/media)\n- - Join our community\n  - [GitHub](https:\/\/github.com\/ClickHouse\/ClickHouse)\n  - [Slack](https:\/\/clickhouse.com\/slack)\n  - [LinkedIn](https:\/\/www.linkedin.com\/company\/clickhouseinc)\n  - [X](https:\/\/x.com\/ClickhouseDB)\n  - [Bluesky](https:\/\/bsky.app\/profile\/clickhouse.com)\n  - [Telegram](https:\/\/telegram.me\/clickhouse_en)\n  - [Meetup](https:\/\/www.meetup.com\/pro\/clickhouse)\n- - Comparisons\n  - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n  - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n  - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n  - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Elastic](https:\/\/clickhouse.com\/comparison\/elastic-for-observability)\n  - [Splunk](https:\/\/clickhouse.com\/comparison\/splunk-for-observability)\n  - [OpenSearch](https:\/\/clickhouse.com\/comparison\/opensearch-for-observability)\n  - Partners\n  - [AWS](https:\/\/clickhouse.com\/partners\/aws)\n  - [Azure](https:\/\/clickhouse.com\/partners\/azure)\n\n![ClickHouse logo](https:\/\/clickhouse.com\/_next\/static\/media\/logo-full.ac8102d5.svg)\n\nStay informed on feature releases, product roadmap, support, and cloud offerings\\!\n\nLoading form...\n\n[Star us on Github](https:\/\/github.com\/ClickHouse\/ClickHouse)\n\n© 2026 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)[Security](https:\/\/trust.clickhouse.com\/)[Legal](https:\/\/clickhouse.com\/legal)[Cookie policy](https:\/\/clickhouse.com\/legal\/cookie-policy)\n\n![Opt-out logo](https:\/\/clickhouse.com\/images\/opt-out-logo.svg)Your privacy choices","attrs_readable_markdown":"[![ClickHouse logo](https:\/\/clickhouse.com\/_next\/static\/media\/logo-full.ac8102d5.svg)](https:\/\/clickhouse.com\/)\n\n[Download full logo](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logo.zip)[Download logomark](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logomark.zip)\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\n- [Products](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Products**\n  \n  - [![ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [![ClickHouse BYOC](https:\/\/clickhouse.com\/images\/nav\/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS and GCP account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [![Postgres ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https:\/\/clickhouse.com\/cloud\/postgres)\n  - [![Managed ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [![Langfuse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https:\/\/langfuse.com\/?utm_source=clickhouse_topnav)\n  \n  **Open source**\n  \n  - [![ClickHouse](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https:\/\/clickhouse.com\/clickhouse)\n  - [![ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https:\/\/clickhouse.com\/clickstack)\n  - [![Agentic Data Stack](https:\/\/clickhouse.com\/images\/nav\/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https:\/\/clickhouse.com\/ai)\n- [Solutions](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Use cases**\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Observability](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [Data warehousing](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Machine learning and GenAI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases \\-\\>\\-\\>](https:\/\/clickhouse.com\/use-cases)\n  \n  **Industries**\n  \n  - [Cybersecurity](https:\/\/clickhouse.com\/industries\/cybersecurity)\n  - [Gaming and entertainment](https:\/\/clickhouse.com\/industries\/gaming)\n  - [E-commerce and retail](https:\/\/clickhouse.com\/industries\/retail)\n  - [Automotive](https:\/\/clickhouse.com\/industries\/automotive)\n  - [Energy](https:\/\/clickhouse.com\/industries\/energy)\n  - [All industries](https:\/\/clickhouse.com\/industries)\n  \n  [All industries \\-\\>\\-\\>](https:\/\/clickhouse.com\/industries)\n- [Docs](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [News](https:\/\/clickhouse.com\/company\/news)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparisons](https:\/\/clickhouse.com\/videos\/lost-in-the-haystack-optimizing-high-cardinality-aggregations)\n    - [Benchmark hub](https:\/\/clickhouse.com\/benchmarks)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n    - [Elastic Observability](https:\/\/clickhouse.com\/comparison\/elastic-for-observability)\n    - [Splunk](https:\/\/clickhouse.com\/comparison\/splunk-for-observability)\n    - [OpenSearch For observability](https:\/\/clickhouse.com\/comparison\/opensearch-for-observability)\n  - [Videos](https:\/\/clickhouse.com\/videos)\n  - [Demos](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact us](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\n[46\\.1k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn)\n\n- [Videos](https:\/\/clickhouse.com\/videos)\n- [Meetups](https:\/\/clickhouse.com\/videos?category=meetups)\n\n[**Previous video**Scaling ClickHouse to petabytes of logs at OpenAI](https:\/\/clickhouse.com\/videos\/openai)\n\n[**Next video**ClickHouse v24.5 Community Call](https:\/\/clickhouse.com\/videos\/community-call-24-05)\n\n## Colton Allen, Sentry.io\nThis presentation was given at the ClickHouse Community Meetup in San Francisco - <https:\/\/www.meetup.com\/clickhouse-silicon-valley-meetup-group\/events\/296334923\/>\n\nIf you are interested in attending a future event, please join a Meetup Group near you at <https:\/\/www.meetup.com\/pro\/clickhouse>\n\nTo get started with ClickHouse, visit <https:\/\/clickhouse.com\/> to download or start a free ClickHouse Cloud Trial\n\n## Recent videos\n[![YouTube Video: geit7C3RuwQ](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2Fgeit7C3RuwQ%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Moment Presented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupny20263)\n\n[![YouTube Video: fScr9GXB1t8](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FfScr9GXB1t8%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Gliss.sh Presented by Ryan Adami @ Gliss.sh at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupnyjan20262)\n\n[![YouTube Video: LeomE29B1cY](https:\/\/clickhouse.com\/_next\/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FLeomE29B1cY%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Clay Presented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup.](https:\/\/clickhouse.com\/videos\/meetupnyjan20261)\n\nFollow us\n\n[![X](https:\/\/clickhouse.com\/socials\/x.svg)X](https:\/\/x.com\/ClickhouseDB \"X\")[![Bluesky](https:\/\/clickhouse.com\/socials\/bluesky.svg)Bluesky](https:\/\/bsky.app\/profile\/clickhouse.com \"Bluesky\")[![Slack](https:\/\/clickhouse.com\/socials\/slack.svg)Slack](https:\/\/clickhouse.com\/slack \"Slack\")\n\n[![GitHub](https:\/\/clickhouse.com\/socials\/github.svg)GitHub](https:\/\/github.com\/ClickHouse\/ClickHouse \"GitHub\")[![Telegram](https:\/\/clickhouse.com\/socials\/telegram.svg)Telegram](https:\/\/telegram.me\/clickhouse_en \"Telegram\")[![Meetup](https:\/\/clickhouse.com\/socials\/meetup.svg)Meetup](https:\/\/www.meetup.com\/pro\/clickhouse \"Meetup\")\n\n[![Rss](https:\/\/clickhouse.com\/socials\/rss.svg)Rss](https:\/\/clickhouse.com\/rss.xml \"Rss\")","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

1 month ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	1.3 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://clickhouse.com/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations
Last Crawled	2026-03-03 10:49:08 (1 month ago)
First Indexed	2024-06-08 19:59:53 (1 year ago)
HTTP Status Code	200
Meta Title	Lost in the Haystack - Optimizing High Cardinality Aggregations
Meta Description	null
Meta Canonical	null
Boilerpipe Text	Download full logo Download logomark English Japanese Products Products ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure. Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS and GCP account. Postgres managed by ClickHouse Unified data stack for transactions and analytics. Managed ClickStack Managed observability with high-performance queries and long-term retention. Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents. Open source ClickHouse Fast open-source OLAP database for real-time analytics. ClickStack Open-source observability stack for logs, metrics, traces, and session replays. Agentic Data Stack Build AI-powered applications with ClickHouse. Solutions Use cases Real-time analytics Observability Data warehousing Machine learning and GenAI All use cases All use cases -> -> Industries Cybersecurity Gaming and entertainment E-commerce and retail Automotive Energy All industries All industries -> -> Docs Resources User stories Blog Events News Learning and certification Comparisons Benchmark hub BigQuery PostgreSQL Redshift Snowflake Elastic Observability Splunk OpenSearch For observability Videos Demos Pricing Contact us English Japanese 46.1k Sign in Videos Meetups Previous video Scaling ClickHouse to petabytes of logs at OpenAI Next video ClickHouse v24.5 Community Call Colton Allen, Sentry.io This presentation was given at the ClickHouse Community Meetup in San Francisco - https://www.meetup.com/clickhouse-silicon-valley-meetup-group/events/296334923/ If you are interested in attending a future event, please join a Meetup Group near you at https://www.meetup.com/pro/clickhouse To get started with ClickHouse, visit https://clickhouse.com/ to download or start a free ClickHouse Cloud Trial Recent videos Meetups Clickhouse Meetups NYC Moment Presented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup. Meetups Clickhouse Meetups NYC Gliss.sh Presented by Ryan Adami @ Gliss.sh at our New York Meetup. Meetups Clickhouse Meetups NYC Clay Presented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup. Follow us X Bluesky Slack GitHub Telegram Meetup Rss
Markdown	[![ClickHouse logo](https://clickhouse.com/_next/static/media/logo-full.ac8102d5.svg)](https://clickhouse.com/) Copy logo as SVG [Download full logo](https://clickhouse.com/brand-assets/clickhouse-logo.zip)[Download logomark](https://clickhouse.com/brand-assets/clickhouse-logomark.zip) Open search Open region selector - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) Open menu - [Products](https://clickhouse.com/videos/[slug]) Products - [![ClickHouse Cloud](https://clickhouse.com/images/nav/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [![ClickHouse BYOC](https://clickhouse.com/images/nav/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS and GCP account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [![Postgres ClickHouse Cloud](https://clickhouse.com/images/nav/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https://clickhouse.com/cloud/postgres) - [![Managed ClickStack](https://clickhouse.com/images/nav/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https://clickhouse.com/cloud/clickstack) - [![Langfuse Cloud](https://clickhouse.com/images/nav/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https://langfuse.com/?utm_source=clickhouse_topnav) Open source - [![ClickHouse](https://clickhouse.com/images/nav/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https://clickhouse.com/clickhouse) - [![ClickStack](https://clickhouse.com/images/nav/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https://clickhouse.com/clickstack) - [![Agentic Data Stack](https://clickhouse.com/images/nav/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https://clickhouse.com/ai) - [Solutions](https://clickhouse.com/videos/[slug]) Use cases - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Observability](https://clickhouse.com/cloud/clickstack) - [Data warehousing](https://clickhouse.com/use-cases/data-warehousing) - [Machine learning and GenAI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [All use cases](https://clickhouse.com/use-cases) [All use cases \-\>\-\>](https://clickhouse.com/use-cases) Industries - [Cybersecurity](https://clickhouse.com/industries/cybersecurity) - [Gaming and entertainment](https://clickhouse.com/industries/gaming) - [E-commerce and retail](https://clickhouse.com/industries/retail) - [Automotive](https://clickhouse.com/industries/automotive) - [Energy](https://clickhouse.com/industries/energy) - [All industries](https://clickhouse.com/industries) [All industries \-\>\-\>](https://clickhouse.com/industries) - [Docs](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/videos/[slug]) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [News](https://clickhouse.com/company/news) - [Learning and certification](https://clickhouse.com/learn) - [Comparisons](https://clickhouse.com/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations) - [Benchmark hub](https://clickhouse.com/benchmarks) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Elastic Observability](https://clickhouse.com/comparison/elastic-for-observability) - [Splunk](https://clickhouse.com/comparison/splunk-for-observability) - [OpenSearch For observability](https://clickhouse.com/comparison/opensearch-for-observability) - [Videos](https://clickhouse.com/videos) - [Demos](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact us](https://clickhouse.com/company/contact?loc=nav) Open search Open region selector - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) [46\.1k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Sign in](https://console.clickhouse.cloud/signIn) [Get started](https://console.clickhouse.cloud/signUp?loc=nav-get-started) - [Videos](https://clickhouse.com/videos) - / - [Meetups](https://clickhouse.com/videos?category=meetups) # Lost in the Haystack - Optimizing High Cardinality Aggregations [Previous videoScaling ClickHouse to petabytes of logs at OpenAI](https://clickhouse.com/videos/openai) [Next videoClickHouse v24.5 Community Call](https://clickhouse.com/videos/community-call-24-05) ## Colton Allen, Sentry.io This presentation was given at the ClickHouse Community Meetup in San Francisco - <https://www.meetup.com/clickhouse-silicon-valley-meetup-group/events/296334923/> If you are interested in attending a future event, please join a Meetup Group near you at <https://www.meetup.com/pro/clickhouse> To get started with ClickHouse, visit <https://clickhouse.com/> to download or start a free ClickHouse Cloud Trial ## Recent videos [View all Videos](https://clickhouse.com/videos) [![YouTube Video: geit7C3RuwQ](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2Fgeit7C3RuwQ%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Moment Presented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup.](https://clickhouse.com/videos/meetupny20263) [![YouTube Video: fScr9GXB1t8](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FfScr9GXB1t8%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Gliss.sh Presented by Ryan Adami @ Gliss.sh at our New York Meetup.](https://clickhouse.com/videos/meetupnyjan20262) [![YouTube Video: LeomE29B1cY](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FLeomE29B1cY%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Clay Presented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup.](https://clickhouse.com/videos/meetupnyjan20261) Follow us [![X](https://clickhouse.com/socials/x.svg)X](https://x.com/ClickhouseDB "X")[![Bluesky](https://clickhouse.com/socials/bluesky.svg)Bluesky](https://bsky.app/profile/clickhouse.com "Bluesky")[![Slack](https://clickhouse.com/socials/slack.svg)Slack](https://clickhouse.com/slack "Slack") [![GitHub](https://clickhouse.com/socials/github.svg)GitHub](https://github.com/ClickHouse/ClickHouse "GitHub")[![Telegram](https://clickhouse.com/socials/telegram.svg)Telegram](https://telegram.me/clickhouse_en "Telegram")[![Meetup](https://clickhouse.com/socials/meetup.svg)Meetup](https://www.meetup.com/pro/clickhouse "Meetup") [![Rss](https://clickhouse.com/socials/rss.svg)Rss](https://clickhouse.com/rss.xml "Rss") - - Product - [ClickHouse Cloud](https://clickhouse.com/cloud) - [Bring Your Own Cloud](https://clickhouse.com/cloud/bring-your-own-cloud) - [Postgres managed by ClickHouse](https://clickhouse.com/cloud/postgres) - [Managed ClickStack](https://clickhouse.com/cloud/clickstack) - [ClickHouse](https://clickhouse.com/clickhouse) - [ClickStack](https://clickhouse.com/clickstack) - [Agentic Data Stack](https://clickhouse.com/ai) - [ClickHouse Government](https://clickhouse.com/government) - [ClickHouse Keeper](https://clickhouse.com/clickhouse/keeper) - [ClickPipes](https://clickhouse.com/cloud/clickpipes) - [Integrations](https://clickhouse.com/integrations) - [chDB](https://clickhouse.com/chdb) - [Pricing](https://clickhouse.com/pricing) - - Resources - [Documentation](https://clickhouse.com/docs) - [Trust center](https://trust.clickhouse.com/) - [Training](https://clickhouse.com/learn) - [Support](https://clickhouse.com/support/program) - [Benchmarks](https://clickhouse.com/benchmarks) - [Use cases](https://clickhouse.com/use-cases) - [Videos](https://clickhouse.com/videos) - [Demos](https://clickhouse.com/demos) - [Presentations](https://presentations.clickhouse.com/) - [Real-time data warehouse](https://clickhouse.com/real-time-data-warehouse) - [Engineering resources](https://clickhouse.com/resources/engineering) - - Company - [Blog](https://clickhouse.com/blog) - [Our story](https://clickhouse.com/company/our-story) - [Careers](https://clickhouse.com/company/careers) - [Contact us](https://clickhouse.com/company/contact?loc=footer) - [Events](https://clickhouse.com/company/events) - [News](https://clickhouse.com/company/news) - [Media](https://clickhouse.com/media) - - Join our community - [GitHub](https://github.com/ClickHouse/ClickHouse) - [Slack](https://clickhouse.com/slack) - [LinkedIn](https://www.linkedin.com/company/clickhouseinc) - [X](https://x.com/ClickhouseDB) - [Bluesky](https://bsky.app/profile/clickhouse.com) - [Telegram](https://telegram.me/clickhouse_en) - [Meetup](https://www.meetup.com/pro/clickhouse) - - Comparisons - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Elastic](https://clickhouse.com/comparison/elastic-for-observability) - [Splunk](https://clickhouse.com/comparison/splunk-for-observability) - [OpenSearch](https://clickhouse.com/comparison/opensearch-for-observability) - Partners - [AWS](https://clickhouse.com/partners/aws) - [Azure](https://clickhouse.com/partners/azure) ![ClickHouse logo](https://clickhouse.com/_next/static/media/logo-full.ac8102d5.svg) Stay informed on feature releases, product roadmap, support, and cloud offerings\! Loading form... [Star us on Github](https://github.com/ClickHouse/ClickHouse) © 2026 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL. [Trademark](https://clickhouse.com/legal/trademark-policy)[Privacy](https://clickhouse.com/legal/privacy-policy)[Security](https://trust.clickhouse.com/)[Legal](https://clickhouse.com/legal)[Cookie policy](https://clickhouse.com/legal/cookie-policy) ![Opt-out logo](https://clickhouse.com/images/opt-out-logo.svg)Your privacy choices
Readable Markdown	[![ClickHouse logo](https://clickhouse.com/_next/static/media/logo-full.ac8102d5.svg)](https://clickhouse.com/) [Download full logo](https://clickhouse.com/brand-assets/clickhouse-logo.zip)[Download logomark](https://clickhouse.com/brand-assets/clickhouse-logomark.zip) - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) - [Products](https://clickhouse.com/videos/[slug]) Products - [![ClickHouse Cloud](https://clickhouse.com/images/nav/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [![ClickHouse BYOC](https://clickhouse.com/images/nav/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS and GCP account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [![Postgres ClickHouse Cloud](https://clickhouse.com/images/nav/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https://clickhouse.com/cloud/postgres) - [![Managed ClickStack](https://clickhouse.com/images/nav/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https://clickhouse.com/cloud/clickstack) - [![Langfuse Cloud](https://clickhouse.com/images/nav/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https://langfuse.com/?utm_source=clickhouse_topnav) Open source - [![ClickHouse](https://clickhouse.com/images/nav/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https://clickhouse.com/clickhouse) - [![ClickStack](https://clickhouse.com/images/nav/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https://clickhouse.com/clickstack) - [![Agentic Data Stack](https://clickhouse.com/images/nav/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https://clickhouse.com/ai) - [Solutions](https://clickhouse.com/videos/[slug]) Use cases - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Observability](https://clickhouse.com/cloud/clickstack) - [Data warehousing](https://clickhouse.com/use-cases/data-warehousing) - [Machine learning and GenAI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [All use cases](https://clickhouse.com/use-cases) [All use cases \-\>\-\>](https://clickhouse.com/use-cases) Industries - [Cybersecurity](https://clickhouse.com/industries/cybersecurity) - [Gaming and entertainment](https://clickhouse.com/industries/gaming) - [E-commerce and retail](https://clickhouse.com/industries/retail) - [Automotive](https://clickhouse.com/industries/automotive) - [Energy](https://clickhouse.com/industries/energy) - [All industries](https://clickhouse.com/industries) [All industries \-\>\-\>](https://clickhouse.com/industries) - [Docs](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/videos/[slug]) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [News](https://clickhouse.com/company/news) - [Learning and certification](https://clickhouse.com/learn) - [Comparisons](https://clickhouse.com/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations) - [Benchmark hub](https://clickhouse.com/benchmarks) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Elastic Observability](https://clickhouse.com/comparison/elastic-for-observability) - [Splunk](https://clickhouse.com/comparison/splunk-for-observability) - [OpenSearch For observability](https://clickhouse.com/comparison/opensearch-for-observability) - [Videos](https://clickhouse.com/videos) - [Demos](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact us](https://clickhouse.com/company/contact?loc=nav) - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) [46\.1k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Sign in](https://console.clickhouse.cloud/signIn) - [Videos](https://clickhouse.com/videos) - [Meetups](https://clickhouse.com/videos?category=meetups) [Previous videoScaling ClickHouse to petabytes of logs at OpenAI](https://clickhouse.com/videos/openai) [Next videoClickHouse v24.5 Community Call](https://clickhouse.com/videos/community-call-24-05) ## Colton Allen, Sentry.io This presentation was given at the ClickHouse Community Meetup in San Francisco - <https://www.meetup.com/clickhouse-silicon-valley-meetup-group/events/296334923/> If you are interested in attending a future event, please join a Meetup Group near you at <https://www.meetup.com/pro/clickhouse> To get started with ClickHouse, visit <https://clickhouse.com/> to download or start a free ClickHouse Cloud Trial ## Recent videos [![YouTube Video: geit7C3RuwQ](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2Fgeit7C3RuwQ%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Moment Presented by Ottavio Hartman- Platform Team Lead @ Moment at our New York Meetup.](https://clickhouse.com/videos/meetupny20263) [![YouTube Video: fScr9GXB1t8](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FfScr9GXB1t8%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Gliss.sh Presented by Ryan Adami @ Gliss.sh at our New York Meetup.](https://clickhouse.com/videos/meetupnyjan20262) [![YouTube Video: LeomE29B1cY](https://clickhouse.com/_next/image?url=https%3A%2F%2Fimg.youtube.com%2Fvi%2FLeomE29B1cY%2Fmaxresdefault.jpg&w=3840&q=75) Meetups Clickhouse Meetups NYC Clay Presented by Paul Noble Tech Lead Audiences @ Clay at our New York Meetup.](https://clickhouse.com/videos/meetupnyjan20261) Follow us [![X](https://clickhouse.com/socials/x.svg)X](https://x.com/ClickhouseDB "X")[![Bluesky](https://clickhouse.com/socials/bluesky.svg)Bluesky](https://bsky.app/profile/clickhouse.com "Bluesky")[![Slack](https://clickhouse.com/socials/slack.svg)Slack](https://clickhouse.com/slack "Slack") [![GitHub](https://clickhouse.com/socials/github.svg)GitHub](https://github.com/ClickHouse/ClickHouse "GitHub")[![Telegram](https://clickhouse.com/socials/telegram.svg)Telegram](https://telegram.me/clickhouse_en "Telegram")[![Meetup](https://clickhouse.com/socials/meetup.svg)Meetup](https://www.meetup.com/pro/clickhouse "Meetup") [![Rss](https://clickhouse.com/socials/rss.svg)Rss](https://clickhouse.com/rss.xml "Rss")
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/videos/lost-in-the-haystack-optimizing-high-cardinality-aggregations s443