🕷️ Crawler Inspector
URL Lookup
URL:
Lookup by URL
Direct Parameter Lookup
Host ID:
Partition ID:
Unparsed Hash:
Lookup by Parameters
Raw Queries and Responses
1. Shard Calculation
Query:
curl -X POST \ 'http://laksa087.int.ahrefs:8124/' \ -H 'Content-Type: text/plain' \ -H 'X-ClickHouse-Database: crawler3' \ -H 'Authorization: Basic YXBpOg==' \ -d 'SELECT getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\') AS unparsed, getAhrefsRootHashFromUnparsed(unparsed) AS root_hash, root_hash % 200 AS shard, intDiv(root_hash, 200) % 100 AS int_partition_id FORMAT JSONEachRow'
Response:
{"unparsed":"com,vox!www,\/world\/2019\/10\/2\/20894979\/north-korea-trump-nuclear-talks-deal s443","root_hash":"4678412784710576080","shard":80,"int_partition_id":80}
Calculated Shard:
80 (from laksa087)
2. Crawled Status Check
Query:
curl -X POST \ 'http://laksa080.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, meta_canonical AS meta_canonical, ml_categories_json AS ml_categories_json, ml_types_json AS ml_types_json, ml_intent_types_json AS ml_intent_types_json, meta_language AS meta_language, attrs_author AS attrs_author, ifNull(toUnixTimestamp(attrs_publish_time), 0) AS attrs_publish_time, ifNull(toUnixTimestamp(attrs_original_publish_time), 0) AS attrs_original_publish_time, ifNull(attrs_is_republished, 0) AS attrs_is_republished, ifNull(attrs_nr_words, 0) AS attrs_nr_words, ifNull(attrs_boilerpipe_nr_words, 0) AS attrs_boilerpipe_nr_words, ifNull(body_ext_links_number, 0) AS body_ext_links_number, ifNull(body_int_links_number, 0) AS body_int_links_number, ifNull(meta_nofollow, 0) AS meta_nofollow, ifNull(meta_noarchive, 0) AS meta_noarchive, ifNull(props_was_rendered, 0) AS props_was_rendered, ifNull(src_redirect, \'\') AS src_redirect, ifNull(download_time_msec, 0) AS download_time_msec, ifNull(download_ttfb_msec, 0) AS download_ttfb_msec, ifNull(download_size, 0) AS download_size FROM crawler3.page_info_local FINAL PREWHERE int_partition_id = 80 AND (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\'))) FORMAT JSONEachRow'
Response:
3. Robots.txt Check
Query:
curl -sS --get \ 'http://fish071.int.ahrefs:12055/access' \ --data-urlencode 'max_retries=0' \ --data-urlencode 'pid=1780476950:1604897:page-crawl-status-tool@yepsand' \ --data-urlencode 'kind=check' \ --data-urlencode 'url=https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal'
Response:
"Disallowed"
4. Spam/Ban Check
Query:
curl -X POST \ 'http://laksa080.int.ahrefs:8124/' \ -H 'Content-Type: text/plain' \ -H 'X-ClickHouse-Database: crawler3' \ -H 'Authorization: Basic YXBpOg==' \ -d 'SELECT fh_dont_index, ml_spam_score FROM robots.target_settings_local FINAL WHERE src_root_hash = getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')) AND startsWith(getAhrefsDropPortFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')), src_unparsed_prefix) ORDER BY length(src_unparsed_prefix) DESC LIMIT 1 FORMAT JSONEachRow'
Response:
5. Seen Status Check
Query:
curl -X POST \ 'http://laksa080.int.ahrefs:8124/' \ -H 'Content-Type: text/plain' \ -H 'X-ClickHouse-Database: crawler3' \ -H 'Authorization: Basic YXBpOg==' \ -d '(SELECT getAhrefsURLFromUnparsed(dst_unparsed) AS found_url, dst_unparsed AS unparsed, dst_root_hash AS root_hash FROM crawler3.urls_local FINAL PREWHERE int_partition_id = 80 AND (dst_root_hash, dst_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')))) UNION ALL (SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, src_unparsed AS unparsed, src_root_hash AS root_hash FROM web_queue.crawl5_local FINAL PREWHERE crawl_yyyymm >= toYYYYMM(today() - INTERVAL 2 MONTHS) AND int_partition_id = 80 AND (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.vox.com/world/2019/10/2/20894979/north-korea-trump-nuclear-talks-deal\')))) FORMAT JSONEachRow'
Response:
Seen check error: Recv failure: Connection reset by peer