Input

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

Data

Total Results: 13 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Optimal cdn	elmanana.com	199140.0	www.elmanana.com	2023-10-15 11:27:30.870060+00:00	2024-06-11 10:24:06.512541-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	udgtv.com	246294.0	udgtv.com	2023-10-15 12:13:27.976349+00:00	2024-12-11 05:56:25.928533-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	posta.com.mx	283094.0	posta.com.mx	2023-10-15 12:13:44.808005+00:00	2024-10-12 06:22:23.860518-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	expreso.com.mx	284579.0	www.expreso.com.mx	2023-10-15 12:13:38.488672+00:00	2024-06-09 11:55:11.736740-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	imagendelgolfo.mx	307855.0	imagendelgolfo.mx	2023-10-15 15:05:09.248811+00:00	2024-04-26 07:19:02.812477-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	imagendeveracruz.mx	395724.0	imagendeveracruz.mx	2023-10-15 19:19:57.068357+00:00	2024-03-25 01:53:18.626468-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	diariopresente.mx	546535.0	diariopresente.mx	2023-10-15 16:02:18.480805+00:00	2024-12-12 13:41:51.342587-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	medicinaysaludpublica.com	568384.0	medicinaysaludpublica.com	2023-10-15 17:47:32.245168+00:00	2024-12-13 11:16:50.448593-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	elporvenir.mx	577335.0	elporvenir.mx	2023-10-15 17:57:34.903880+00:00	2024-12-09 11:18:16.456220-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	xevt.com	606919.0	www.xevt.com	2023-10-15 15:21:10.286166+00:00	2024-12-12 14:56:58.459168-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	el-mexicano.com	733462.0	el-mexicano.com	2024-08-21 05:39:31.589066+00:00	2024-12-09 14:06:33.860474-08:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	latarde.com.mx	736573.0	latarde.com.mx	2023-10-15 19:01:59.762005+00:00	2024-08-26 18:44:08.748204-07:00	lower(http_request.response_headers) contains 'optimal cdn'
Optimal cdn	diariodelyaqui.mx	781548.0	diariodelyaqui.mx	2023-10-15 20:07:53.630870+00:00	2024-03-12 13:10:03.952346-07:00	lower(http_request.response_headers) contains 'optimal cdn'