Input

field	value
Query:	SELECT 'Wp rocket/3.2.3' 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.2.3' 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.2.3'::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.2.3'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 15 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Wp rocket/3.2.3	favorflav.com	364950.0	favorflav.com/nl	2023-10-18 05:33:53.870650-07:00	2024-12-13 06:49:18.985208-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	thechairmansbao.com	457754.0	www.thechairmansbao.com	2023-10-15 09:48:03.201555-07:00	2024-04-13 10:17:03.150680-07:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	gaietytheatre.ie	482975.0	www.gaietytheatre.ie	2023-10-15 08:30:36.022432-07:00	2024-12-09 09:55:30.533726-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	idn.org.pl	534092.0	idn.org.pl	2023-10-15 08:12:37.841376-07:00	2024-12-08 10:28:13.947957-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	amayzine.com	609574.0	amayzine.com/nl	2023-10-15 09:02:58.138954-07:00	2024-12-12 15:10:06.641860-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	korwin-mikke.pl	710986.0	korwin-mikke.pl	2023-10-15 08:30:36.022432-07:00	2024-08-30 13:51:28.051397-07:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	torredealtamar.com	897621.0	torredealtamar.com	2023-10-15 14:28:05.353391-07:00	2023-12-08 11:49:03.948370-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	essentialsclothing.store	NaN	essentialsclothing.store	2023-11-09 07:12:00.831324-08:00	2023-11-08 14:13:08.097603-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	ranchotowing.com	NaN	ranchotowing.com	2023-10-15 07:50:23.267474-07:00	2023-12-02 04:07:33.103308-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	bluebelt.asia	NaN	www.bluebelt.asia	2023-11-09 02:47:17.691894-08:00	2023-11-08 14:53:27.748617-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	agentur-traumhochzeit.de	NaN	www.agentur-traumhochzeit.de	2023-10-15 15:40:23.183312-07:00	2024-02-15 17:15:32.008687-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	askedsum.com	NaN	askedsum.com	2023-11-12 14:05:39.812598-08:00	2023-12-25 05:38:46.594759-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	bitrepository.com	NaN	bitrepository.com	2023-10-15 13:57:45.010436-07:00	2023-12-09 10:07:04.937915-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	trafficcrow.com	NaN	trafficcrow.com	2023-10-15 21:27:07.528140-07:00	2024-02-26 16:08:17.136324-08:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'
Wp rocket/3.2.3	infinitesgs.com	NaN	infinitesgs.com	2023-10-24 12:12:54.098155-07:00	2024-03-12 14:02:45.466182-07:00	lower(http_request.response_headers) contains 'wp rocket/3.2.3'