Input

field	value
Query:	SELECT 'Cdn77-turbo' 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] = 'cdn77-turbo' 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] = 'cdn77-turbo'::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] = 'cdn77-turbo'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 58 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Cdn77-turbo	phpmyadmin.net	1904.0	www.phpmyadmin.net	2023-10-16 02:25:52.872100-07:00	2024-12-13 00:23:01.088961-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	sport1.de	10886.0	www.sport1.de	2023-10-15 12:58:57.849523-07:00	2024-12-14 00:09:43.864439-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	spacetelescope.org	14362.0	cdn.spacetelescope.org	2023-10-15 10:24:44.291014-07:00	2023-12-29 06:26:41.503856-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	sapphiretech.com	26744.0	www.sapphiretech.com/en	2023-10-16 01:29:45.222754-07:00	2024-12-23 00:46:02.538231-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	status-ovhcloud.com	60118.0	www.status-ovhcloud.com	2023-10-16 02:44:01.481699-07:00	2024-12-23 00:59:58.811900-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	redgifs.com	65633.0	www.redgifs.com	2024-11-19 16:39:28.244992-08:00	2024-12-23 01:14:24.408609-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	indiaglitz.com	79016.0	www.indiaglitz.com	2024-01-07 21:59:40.964809-08:00	2024-01-15 00:34:22.635170-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	dlh.net	80331.0	www.dlh.net/en	2024-03-28 19:48:41.289176-07:00	2024-04-14 01:28:24.642573-07:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	albeebaby.com	105033.0	www.albeebaby.com	2023-10-21 05:00:01.383317-07:00	2023-10-23 00:26:36.046995-07:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	binaryage.com	109611.0	www.binaryage.com	2023-10-15 03:36:44.267561-07:00	2024-12-23 01:50:21.965856-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	ofuxico.com.br	115654.0	www.ofuxico.com.br	2023-12-30 10:38:51.859999-08:00	2024-03-24 01:34:49.514006-07:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	televizyondizisi.com	123433.0	www.televizyondizisi.com	2024-11-29 14:22:10.838217-08:00	2024-11-29 02:43:43.435638-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	mup.com.au	124684.0	www.mup.com.au	2023-10-15 04:27:30.870060-07:00	2024-11-25 03:01:03.889843-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	cdn77.com	124909.0	www.cdn77.com	2023-10-15 03:41:10.992590-07:00	2024-11-25 03:02:34.231531-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	myswissalps.com	159070.0	www.myswissalps.com	2023-10-15 03:36:50.503608-07:00	2023-11-27 01:13:15.743957-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	srnnews.com	195524.0	www.srnnews.com	2024-01-10 19:13:30.685134-08:00	2024-01-18 02:45:03.210537-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	soccervista.com	222285.0	www.soccervista.com	2023-10-15 03:36:42.581676-07:00	2024-02-26 02:03:18.832225-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	luscious.net	237903.0	www.luscious.net	2023-10-15 05:48:58.677213-07:00	2024-12-13 04:27:58.162162-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	airbridgecargo.com	276517.0	www.airbridgecargo.com/en	2023-10-15 05:20:55.383973-07:00	2024-12-12 07:23:26.027139-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'
Cdn77-turbo	kawasaki.co.uk	284702.0	www.kawasaki.co.uk/en/products	2023-10-15 05:13:46.258251-07:00	2024-12-08 05:05:17.013498-08:00	lower(http_request.response_headers) contains 'cdn77-turbo'