Input

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

Data

Total Results: 146 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Wp rocket/3.12.4	siteefy.com	60991.0	siteefy.com	2023-10-15 09:42:48.582217+00:00	2024-12-23 00:56:14.360401-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	onallcylinders.com	73600.0	www.onallcylinders.com	2023-10-15 09:42:47.299365+00:00	2023-10-24 00:53:11.631736-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	memesbams.com	128901.0	memesbams.com	2023-10-15 10:35:10.261412+00:00	2024-06-17 11:41:16.576079-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	opsu.edu	170747.0	opsu.edu	2023-10-15 11:22:24.814578+00:00	2024-12-05 02:36:45.759961-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	thriftyfrugalmom.com	216322.0	www.thriftyfrugalmom.com	2023-10-15 12:20:53.213924+00:00	2023-12-07 02:46:48.147639-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	themoneymongers.com	221115.0	themoneymongers.com	2024-06-02 01:16:15.731406+00:00	2024-12-05 03:18:30.593541-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	neo.edu	223004.0	neo.edu	2023-10-15 11:20:05.411952+00:00	2024-06-26 22:11:27.769808-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	casino.forum	247255.0	casino.forum	2023-10-15 11:22:24.814578+00:00	2023-11-20 01:40:44.935842-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	purerawz.co	251983.0	purerawz.co	2023-10-15 13:40:16.594451+00:00	2024-02-28 00:44:49.083170-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	cultures.ae	275723.0	cultures.ae	2023-10-15 12:13:14.891811+00:00	2024-04-09 04:36:03.146413-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	especialistaemnotebook.com.br	279261.0	especialistaemnotebook.com.br	2024-08-21 17:44:51.054734+00:00	2024-12-12 07:35:28.623633-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	cleary.edu	284138.0	www.cleary.edu	2023-10-18 11:15:26.745475+00:00	2024-10-11 07:00:10.634676-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	m2sys.com	292261.0	www.m2sys.com	2023-10-15 12:20:38.747396+00:00	2024-12-08 05:11:35.627346-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	chavezfoundation.org	309355.0	chavezfoundation.org	2023-10-15 12:49:00.587668+00:00	2023-12-12 03:29:31.826205-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	rotsvast.nl	317739.0	www.rotsvast.nl	2023-10-15 12:49:02.649622+00:00	2024-04-16 05:44:31.147687-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	iwib.com.au	322681.0	www.iwib.com.au	2023-10-15 12:20:44.581640+00:00	2024-12-11 07:17:57.483461-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	lighthousepoole.co.uk	324789.0	www.lighthousepoole.co.uk	2024-03-11 00:53:39.892764+00:00	2024-03-10 05:19:33.640367-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	proxidize.com	332066.0	proxidize.com	2023-10-15 19:58:17.742970+00:00	2023-11-13 09:21:34.600563-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	paranashop.com.br	333859.0	paranashop.com.br	2023-10-15 12:13:44.808005+00:00	2023-11-21 03:03:49.375157-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'
Wp rocket/3.12.4	caplinked.com	337241.0	www.caplinked.com	2023-10-16 12:13:08.227775+00:00	2024-12-01 05:59:00.535781-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.4'