Input

field	value
Query:	SELECT 'Dnspod url v2.0' AS technology_name ,domain ,global_rank ,url_matchable AS url ,created AS first_seen ,last_seen ,CASE WHEN indicator_matchable[2] = 'plain' THEN 'lower(' || indicator_matchable[3] || '.' || indicator_matchable[4] || ') contains ''' || indicator_matchable[1] || '''' ELSE indicator_matchable[3] || '.' || indicator_matchable[4] || ' is regex match of ''' || indicator_matchable[1] || '''' END AS indicator FROM indicator_detection_domain_rollup WHERE (indicator_matchable[1] = 'dnspod url v2.0' AND indicator_matchable[2] = 'plain' AND indicator_matchable[3] = 'http_request' AND indicator_matchable[4] = 'response_headers') ORDER BY global_rank ASC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=3485.21..3486.06 rows=20 width=117)
-> Result (cost=3485.21..3521.68 rows=858 width=117)
-> Sort (cost=3485.21..3487.36 rows=858 width=168)
Sort Key: global_rank
-> Bitmap Heap Scan on indicator_detection_domain_rollup (cost=61.64..3462.38 rows=858 width=168)
Recheck Cond: ((indicator_matchable[1] = 'dnspod url v2.0'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))
-> Bitmap Index Scan on indicator_detection_domain_rollup_indicator_matchable_arr_idx (cost=0.00..61.43 rows=858 width=0)
Index Cond: ((indicator_matchable[1] = 'dnspod url v2.0'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 21 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Dnspod url v2.0	xywy.com	15501.0	xywy.com	2024-06-24 04:25:01.934071-07:00	2024-12-14 00:14:01.861593-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	17k.com	35424.0	17k.com	2024-01-25 07:13:29.811427-08:00	2024-01-25 00:38:03.656778-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	ynshangji.com	128241.0	ynshangji.com	2024-06-17 16:38:34.025749-07:00	2024-08-21 06:02:38.248306-07:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	baigouwanggong.com	133994.0	baigouwanggong.com	2024-06-15 15:23:14.161817-07:00	2024-12-12 04:09:46.257246-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	zxk8.cn	156678.0	zxk8.cn	2024-06-16 15:31:04.902669-07:00	2024-12-06 03:55:16.577705-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	aili.com	199891.0	aili.com	2024-06-26 22:43:12.041333-07:00	2024-12-10 04:10:51.157669-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	chukou.la	227827.0	chukou.la	2024-06-15 15:30:53.596745-07:00	2024-12-05 03:36:09.670089-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	coloros.com	241889.0	coloros.com	2023-10-15 04:38:43.071278-07:00	2024-12-08 04:07:36.726491-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	qwsy.com	246566.0	qwsy.com	2024-08-24 20:16:08.904673-07:00	2024-10-07 06:27:42.653341-07:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	mmecaw.com	248744.0	mmecaw.com	2024-06-16 12:53:37.910315-07:00	2024-12-11 06:07:43.117198-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	zhaoshang100.com	287012.0	zhaoshang100.com	2024-06-17 21:23:25.160801-07:00	2024-07-06 17:53:34.749621-07:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	kiees.com	289675.0	kiees.com	2024-08-20 20:01:16.370756-07:00	2024-12-08 05:27:52.237051-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	youshang.com	358419.0	youshang.com	2023-10-15 04:47:02.563859-07:00	2024-12-23 06:13:40.257605-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	ruyig.com	363004.0	ruyig.com	2024-08-23 18:28:37.856661-07:00	2024-12-13 06:20:06.971943-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	bb06.com	371386.0	bb06.com	2024-06-15 17:33:44.280547-07:00	2024-12-12 09:13:11.745528-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	baobei360.com	391963.0	baobei360.com	2024-08-23 13:54:43.805524-07:00	2024-12-13 07:06:36.742248-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	tangdou.com	402276.0	tangdou.com	2024-08-23 15:54:10.280385-07:00	2024-10-03 08:35:56.117504-07:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	vgooo.com	602564.0	vgooo.com	2024-08-20 16:17:35.826319-07:00	2024-12-12 14:49:42.023466-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	keepc.com	652140.0	keepc.com	2024-08-30 16:02:51.430806-07:00	2024-10-03 16:20:04.026679-07:00	lower(http_request.response_headers) contains 'dnspod url v2.0'
Dnspod url v2.0	isweek.cn	673906.0	isweek.cn	2024-08-20 23:13:37.561453-07:00	2024-12-13 12:36:39.676853-08:00	lower(http_request.response_headers) contains 'dnspod url v2.0'