Input

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

Data

Total Results: 53 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Ced652	bitly.com	753.0	bitly.com/pages/landing/branded-short-domains-powered-by-bitly	2024-11-13 23:48:56.606267-08:00	2024-11-13 18:51:41.359380-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	pmi.org	2667.0	www.pmi.org	2024-06-25 02:17:41.166591-07:00	2024-06-25 00:45:31.570242-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	toshiba.com	4404.0	www.toshiba.com/tai	2024-08-28 03:50:23.033103-07:00	2024-08-28 00:48:34.287330-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	donga.com	5943.0	www.donga.com	2024-08-28 01:55:49.808386-07:00	2024-08-28 00:48:34.972822-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	zenit.org	11485.0	zenit.org	2024-06-01 04:43:23.419815-07:00	2024-06-01 00:31:29.322046-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	funky-fruits-slot.com	14051.0	funky-fruits-slot.com	2024-09-22 01:11:02.966618-07:00	2024-09-22 00:02:16.966881-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	ocado.com	14825.0	www.ocado.com/webshop/startwebshop	2024-01-08 14:59:50.235945-08:00	2024-01-08 00:25:11.106128-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	catracalivre.com.br	17345.0	catracalivre.com.br	2023-11-10 20:38:56.830184-08:00	2023-11-10 00:29:21.872761-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	filehorse.com	28294.0	www.filehorse.com	2024-10-07 06:56:44.708335-07:00	2024-10-07 00:47:58.681060-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	getsocialnetwork.com	41766.0	getsocialnetwork.com	2023-11-16 10:09:53.497568-08:00	2023-11-16 00:03:25.746188-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	tideschart.com	44038.0	www.tideschart.com	2024-01-31 03:29:17.411881-08:00	2024-01-31 01:15:42.876768-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	ascsa.edu.gr	54910.0	ascsa.edu.gr	2023-11-16 03:58:29.738696-08:00	2023-11-16 00:47:46.085110-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	unchainedcrypto.com	60209.0	unchainedcrypto.com	2024-02-08 00:08:07.009644-08:00	2024-02-07 01:10:57.575160-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	bcdtravel.com	66460.0	www.bcdtravel.com	2024-03-26 04:55:11.040569-07:00	2024-03-26 01:06:53.783114-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	carcare.org	89654.0	www.carcare.org	2024-06-24 21:14:40.860502-07:00	2024-06-24 13:27:45.368614-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	toprevenuegate.com	138061.0	www.toprevenuegate.com/bsfxjwvd	2024-02-04 20:59:31.034998-08:00	2024-02-04 16:59:17.957592-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	contentsnare.com	140344.0	contentsnare.com	2024-06-04 16:28:10.112385-07:00	2024-06-04 11:33:55.337646-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	legalnature.com	142849.0	www.legalnature.com	2024-01-13 23:37:30.145428-08:00	2024-01-13 02:29:31.069512-08:00	lower(http_request.response_headers) contains 'ced652'
Ced652	bhimchat.com	144516.0	www.bhimchat.com/welcome	2024-05-29 17:20:27.682578-07:00	2024-05-29 06:35:01.681969-07:00	lower(http_request.response_headers) contains 'ced652'
Ced652	boe.com	146407.0	boe.com	2024-12-04 17:15:20.270542-08:00	2024-12-04 03:08:18.272638-08:00	lower(http_request.response_headers) contains 'ced652'