ℹ️ Skipped - page is already crawled
| Filter | Status | Condition | Details |
|---|---|---|---|
| HTTP status | PASS | download_http_code = 200 | HTTP 200 |
| Age cutoff | PASS | download_stamp > now() - 6 MONTH | 0.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 |
| Property | Value | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| URL | https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topk | |||||||||
| Last Crawled | 2026-05-26 09:56:29 (7 days ago) | |||||||||
| First Indexed | 2025-02-21 06:22:06 (1 year ago) | |||||||||
| HTTP Status Code | 200 | |||||||||
| Content | ||||||||||
| Meta Title | topK | ClickHouse Docs | |||||||||
| Meta Description | Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). | |||||||||
| Meta Canonical | null | |||||||||
| Boilerpipe Text | heavy column, fetched on demand | |||||||||
| Markdown | heavy column, fetched on demand | |||||||||
| Readable Markdown | heavy column, fetched on demand | |||||||||
| ML Classification | ||||||||||
| ML Categories |
Raw JSON{
"/Computers_and_Electronics": 961,
"/Computers_and_Electronics/Software": 598,
"/Computers_and_Electronics/Software/Software_Utilities": 493
} | |||||||||
| ML Page Types |
Raw JSON{
"/Document": 946,
"/Document/Manual": 927
} | |||||||||
| ML Intent Types |
Raw JSON{
"Informational": 997
} | |||||||||
| Content Metadata | ||||||||||
| Language | en | |||||||||
| Author | null | |||||||||
| Publish Time | not set | |||||||||
| Original Publish Time | 2025-02-21 06:22:06 (1 year ago) | |||||||||
| Republished | No | |||||||||
| Word Count (Total) | 957 | |||||||||
| Word Count (Content) | 241 | |||||||||
| Links | ||||||||||
| External Links | 15 | |||||||||
| Internal Links | 216 | |||||||||
| Technical SEO | ||||||||||
| Meta Nofollow | No | |||||||||
| Meta Noarchive | No | |||||||||
| JS Rendered | Yes | |||||||||
| Redirect Target | null | |||||||||
| Performance | ||||||||||
| Download Time (ms) | 226 | |||||||||
| TTFB (ms) | 223 | |||||||||
| Download Size (bytes) | 13,461 | |||||||||
| Location | ||||||||||
| Host ID | 89 (laksa089) | |||||||||
| Partition ID | 57 | |||||||||
| Root Hash | 12633450985039531489 | |||||||||
| Unparsed URL | com,clickhouse!/docs/sql-reference/aggregate-functions/reference/topk s443 | |||||||||