Input

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

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
W3 total cache/2.1.8	virtual-data.net	218201.0	virtual-data.net	2023-10-24 03:58:52.582933-07:00	2023-10-25 01:27:05.911079-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	mountaincountryfarm.com	240930.0	mountaincountryfarm.com	2023-10-15 03:35:14.855042-07:00	2023-10-31 01:10:12.175910-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	theventurecation.com	322765.0	theventurecation.com	2023-10-15 06:11:04.756570-07:00	2024-03-12 04:27:04.193805-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	medisoftreports.com	339569.0	medisoftreports.com	2023-10-15 03:33:08.913001-07:00	2023-10-31 00:59:00.309677-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	cookprimalgourmet.com	390811.0	cookprimalgourmet.com	2023-10-15 11:42:06.382266-07:00	2024-02-04 14:57:08.602548-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	softysols.com	415199.0	softysols.com	2023-10-15 04:22:05.050003-07:00	2023-10-31 02:04:55.794283-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	sbmcsurvey.com	422324.0	sbmcsurvey.com	2023-10-16 03:48:14.025975-07:00	2023-10-27 03:02:31.753458-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	servicewaves.com	445880.0	servicewaves.com	2023-10-15 05:40:36.899794-07:00	2023-10-25 03:33:11.963124-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	abcdrduson.com	531339.0	www.abcdrduson.com	2023-10-15 09:52:02.912877-07:00	2024-11-14 17:23:18.788922-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	perfectchoicemarkeing.com	545194.0	perfectchoicemarkeing.com	2023-10-15 04:38:51.770283-07:00	2023-10-30 02:01:13.027099-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	shespot.nl	595943.0	www.shespot.nl/shespot	2024-05-25 20:33:21.163881-07:00	2024-12-07 11:48:56.941299-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	abccardiol.org	842121.0	abccardiol.org	2023-10-15 13:57:55.233571-07:00	2024-01-17 13:57:27.755382-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	gruppomarica.it	NaN	www.gruppomarica.it	2023-10-15 12:20:19.120765-07:00	2024-02-15 18:09:41.344927-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	topmastersinpublichealth.com	NaN	www.topmastersinpublichealth.com	2023-11-09 04:21:00.366755-08:00	2023-11-08 15:00:42.925732-08:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'
W3 total cache/2.1.8	thegeschaft.de	NaN	thegeschaft.de	2023-10-15 05:48:11.034817-07:00	2023-10-28 04:05:42.222062-07:00	lower(http_request.response_headers) contains 'w3 total cache/2.1.8'