Input

field	value
Query:	SELECT 'W3 total cache/2.1.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] = 'w3 total cache/2.1.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] = 'w3 total cache/2.1.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] = 'w3 total cache/2.1.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: 9 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
W3 total cache/2.1.3	soundgardenworld.com	148281.0	soundgardenworld.com	2023-10-15 11:21:35.225570+00:00	2024-01-07 02:15:24.373506-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	balisafarimarinepark.com	279645.0	www.balisafarimarinepark.com	2023-10-15 12:48:58.677213+00:00	2024-04-16 05:16:35.240928-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	agiloft.com	281861.0	www.agiloft.com	2023-10-15 12:13:40.588913+00:00	2023-12-19 02:52:35.017833-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	2luxury2.com	449269.0	www.2luxury2.com	2023-10-15 15:13:09.485753+00:00	2024-12-10 09:55:19.066490-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	usetinc.org	465858.0	www.usetinc.org	2023-10-15 15:30:36.022432+00:00	2024-12-09 09:30:02.620701-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	arthurrogergallery.com	671696.0	arthurrogergallery.com	2023-10-15 18:42:06.382266+00:00	2024-12-13 12:24:57.955803-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	majsterkowo.pl	678480.0	majsterkowo.pl	2023-10-15 16:53:27.878633+00:00	2024-12-13 13:00:51.961824-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	foodpyramid.com	799942.0	www.foodpyramid.com	2023-10-15 17:41:04.503223+00:00	2024-12-02 20:06:39.595853-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'
W3 total cache/2.1.3	graylinealaska.com	804338.0	www.graylinealaska.com	2023-10-15 15:56:41.932899+00:00	2023-11-08 05:29:05.799061-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.3'