Input

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

Data

Total Results: 16 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Bunnycdn-de1-860	tmdb.org	31823.0	image.tmdb.org	2023-11-16 13:19:48.097517-08:00	2023-11-16 00:16:54.157912-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	dansko-shoes.org	414829.0	www.dansko-shoes.org	2023-12-12 06:38:23.902145-08:00	2024-08-20 09:27:14.892438-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	gigapxl.org	458513.0	www.gigapxl.org	2023-11-23 09:18:08.679137-08:00	2024-01-22 07:37:01.297003-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	demotivationalposters.org	591096.0	www.demotivationalposters.org	2023-10-15 09:03:52.003726-07:00	2024-02-05 09:31:58.747626-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	russianbrides180.com	595728.0	russianbrides180.com	2024-03-04 18:12:51.952079-08:00	2024-03-18 03:44:06.693063-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	latinbusinesschronicle.com	618428.0	www.latinbusinesschronicle.com	2023-12-17 14:18:17.942431-08:00	2024-02-05 09:50:54.614160-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	manusport.com	672609.0	manusport.com	2023-11-20 07:05:55.943739-08:00	2023-11-20 04:46:43.406690-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	watchbha.xyz	920196.0	watchbha.xyz	2023-10-16 09:43:47.391610-07:00	2023-10-16 08:15:40.195738-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	firmware-flash.com	931750.0	www.firmware-flash.com	2023-10-15 18:02:07.985336-07:00	2023-10-29 13:12:47.969226-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	xgcssx.com	NaN	www.xgcssx.com	2024-03-22 21:40:46.350495-07:00	2024-03-22 11:18:54.467395-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	celadonhcm.com	NaN	www.celadonhcm.com	2023-11-08 14:38:23.754036-08:00	2023-11-08 06:19:43.127104-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	lifelabs.io	NaN	www.lifelabs.io	2023-11-05 13:11:24.758825-08:00	2023-11-05 07:36:43.461279-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	arabiccpa.com	NaN	www.arabiccpa.com	2024-02-10 20:01:28.073538-08:00	2024-02-10 16:01:38.415999-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	docbaotintuc24h.net	NaN	www.docbaotintuc24h.net	2023-10-23 20:47:26.684377-07:00	2023-10-23 12:44:56.734221-07:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	playgrouphongkong.com	NaN	playgrouphongkong.com	2024-02-20 19:59:48.670888-08:00	2024-02-20 18:02:12.040167-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'
Bunnycdn-de1-860	nadeausoftware.com	NaN	nadeausoftware.com	2023-10-16 11:51:06.706504-07:00	2023-11-22 09:44:32.691883-08:00	lower(http_request.response_headers) contains 'bunnycdn-de1-860'