Input

field	value
Query:	SELECT 'W3 total cache/0.15.2' 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/0.15.2' 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/0.15.2'::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/0.15.2'::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/0.15.2	sipsmith.com	103817.0	sipsmith.com	2023-10-15 03:34:10.690011-07:00	2024-10-11 03:12:10.270445-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	peruforless.com	287237.0	peruforless.com	2023-10-15 05:13:14.891811-07:00	2024-04-10 06:07:46.388774-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	morninglazziness.com	427960.0	www.morninglazziness.com	2024-03-05 21:17:20.244285-08:00	2024-03-21 07:01:37.548565-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	muncheye.com	512494.0	muncheye.com	2023-10-15 08:05:09.248811-07:00	2024-12-11 12:01:57.907998-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	computertutor.in	529976.0	computertutor.in	2023-10-15 07:49:27.317331-07:00	2024-12-08 09:56:44.721712-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	collegefinance.com	551496.0	collegefinance.com	2023-10-15 06:28:48.092018-07:00	2024-12-10 11:18:41.049856-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	salonedellostudente.it	572864.0	www.salonedellostudente.it	2024-12-03 23:19:58.834608-08:00	2024-12-09 12:56:51.535714-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	disabilityrightsfund.org	600830.0	disabilityrightsfund.org	2023-10-15 10:03:58.331780-07:00	2024-09-23 10:50:27.847693-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	concours-lepine.com	634376.0	www.concours-lepine.com	2023-10-15 10:40:19.553755-07:00	2024-08-26 15:35:14.040979-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	forrager.com	711667.0	forrager.com/laws	2023-10-15 10:47:32.245168-07:00	2024-10-03 14:42:41.596478-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	delfinamazoncruises.com	739352.0	www.delfinamazoncruises.com	2023-10-15 12:06:59.082409-07:00	2024-12-02 17:26:09.970155-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	groovetechnology.com	754256.0	groovetechnology.com	2023-10-15 11:20:53.513228-07:00	2024-10-01 14:35:34.235874-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	csh.ae	859811.0	csh.ae	2023-10-15 15:14:51.631364-07:00	2024-01-31 16:18:28.357799-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	skylinkhome.com	903682.0	www.skylinkhome.com	2023-10-15 12:36:07.578679-07:00	2023-10-24 10:53:27.163449-07:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'
W3 total cache/0.15.2	thegermanprofessor.com	NaN	www.thegermanprofessor.com	2023-10-15 17:59:41.854208-07:00	2023-12-08 11:51:07.694657-08:00	lower(http_request.response_headers) contains 'w3 total cache/0.15.2'