Input

field	value
Query:	SELECT 'Wp rocket/3.10.8' 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] = 'wp rocket/3.10.8' 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] = 'wp rocket/3.10.8'::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] = 'wp rocket/3.10.8'::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
Wp rocket/3.10.8	epilstudio.ru	125026.0	epilstudio.ru	2023-10-15 11:04:51.871952-07:00	2023-11-09 06:21:35.463536-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	moneyscience.ir	126077.0	moneyscience.ir	2023-10-15 08:06:50.226103-07:00	2024-11-25 03:01:43.315240-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	botox.life	241401.0	botox.life	2023-10-15 10:03:58.331780-07:00	2023-11-20 06:08:26.043242-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	survivalcache.com	253063.0	survivalcache.com	2024-05-26 19:42:37.877142-07:00	2024-12-23 03:48:08.972009-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	duoclieusuckhoe.vn	255408.0	duoclieusuckhoe.vn	2023-10-15 02:42:39.409345-07:00	2023-11-21 00:47:48.353794-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	templon.com	288606.0	www.templon.com/exhibitions/current	2023-10-15 05:48:07.689600-07:00	2024-03-30 04:44:35.853989-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	famousage.com	322880.0	famousage.com	2023-10-21 19:51:49.251902-07:00	2024-10-04 10:41:45.619589-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	smtnn.ru	323591.0	smtnn.ru	2024-01-16 20:03:26.181469-08:00	2024-05-25 14:06:24.018045-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	theplanetvape.com	349544.0	theplanetvape.com	2023-10-15 21:40:55.029691-07:00	2024-09-30 06:34:17.973556-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	bingomum.co.uk	385421.0	www.bingomum.co.uk	2023-10-15 12:20:19.120765-07:00	2024-02-05 15:29:45.480458-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	altamiraweb.net	389054.0	altamiraweb.net	2023-10-15 07:01:19.870993-07:00	2023-11-27 03:58:16.088395-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	simpleskincarescience.com	397255.0	simpleskincarescience.com	2023-10-15 05:13:27.976349-07:00	2023-12-07 02:38:45.820128-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	indusnet.co.in	425010.0	www.indusnet.co.in	2023-10-15 06:37:58.508907-07:00	2024-12-08 07:35:03.127716-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	boots.jobs	430882.0	www.boots.jobs	2024-06-06 21:37:42.236858-07:00	2024-12-11 10:24:42.964966-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	talkativefox.com	473712.0	talkativefox.com	2023-11-22 15:13:47.410611-08:00	2024-12-13 08:52:55.974471-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	hawaiifoodbank.org	488924.0	hawaiifoodbank.org	2023-10-15 08:56:41.932899-07:00	2023-10-28 06:02:07.893185-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	mooistedorpjes.nl	496811.0	www.mooistedorpjes.nl	2023-10-15 09:46:22.565389-07:00	2023-10-24 06:59:26.377128-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	zahlungsverkehrsfragen.de	500469.0	www.zahlungsverkehrsfragen.de	2023-10-16 05:13:08.227775-07:00	2023-12-23 05:23:13.727094-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	omni-cnc.com	507335.0	www.omni-cnc.com	2024-02-01 10:42:03.827778-08:00	2024-04-09 06:41:24.079530-07:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'
Wp rocket/3.10.8	fourmilepark.org	521956.0	www.fourmilepark.org	2023-10-15 10:06:10.824926-07:00	2024-12-07 10:15:35.357077-08:00	lower(http_request.response_headers) contains 'wp rocket/3.10.8'