Run A Query

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

Data

Total Results: 129 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Wp rocket/3.12.1	ispionline.it	24170.0	www.ispionline.it	2023-12-16 03:44:44.677939-08:00	2024-05-01 01:02:30.729725-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	prdentalkerala.com	89704.0	prdentalkerala.com	2024-11-29 06:42:46.735384-08:00	2024-12-23 01:34:12.852870-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	invest-top.net	123225.0	invest-top.net	2024-11-15 17:20:49.913079-08:00	2024-11-23 03:29:37.213057-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	bestpointonline.com	128600.0	bestpointonline.com	2023-10-15 02:42:47.299365-07:00	2024-04-29 01:42:22.048304-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	abruzzoweb.it	139159.0	abruzzoweb.it	2024-05-25 13:56:23.893096-07:00	2024-12-12 04:32:07.684464-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	foundagrave.com	150435.0	www.foundagrave.com	2023-10-15 09:04:58.115248-07:00	2023-10-25 07:16:44.354682-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	biocenfis.es	154016.0	biocenfis.es	2023-10-26 15:01:49.626818-07:00	2023-10-26 00:55:48.991542-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	bridge.nl	214388.0	www.bridge.nl	2023-10-15 04:47:10.263931-07:00	2024-12-23 03:11:52.214211-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	preparedcooks.com	223007.0	preparedcooks.com	2023-10-15 05:41:43.386543-07:00	2024-12-05 03:35:05.076049-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	flyttfirma-arbetspartner.se	227301.0	www.flyttfirma-arbetspartner.se	2023-10-15 03:32:34.049387-07:00	2024-12-01 04:32:22.394974-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	altagency.co.uk	293565.0	www.altagency.co.uk	2024-08-20 20:45:17.313135-07:00	2024-12-08 05:15:58.019430-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	aiper.com	296448.0	aiper.com	2023-10-15 10:46:14.920796-07:00	2023-12-01 06:41:29.132145-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	monikahibbs.com	306915.0	monikahibbs.com	2023-10-15 09:01:53.128229-07:00	2024-12-09 05:36:56.264785-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	gabbly.com	319544.0	gabbly.com	2023-10-15 05:49:05.926520-07:00	2024-08-31 07:14:00.896847-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	foxclone.com	325410.0	www.foxclone.com	2023-10-15 03:37:20.214205-07:00	2024-03-11 01:15:22.068398-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	perudelights.com	331293.0	perudelights.com	2023-10-15 08:13:22.222419-07:00	2024-12-06 07:42:09.941859-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	enzian.org	344800.0	enzian.org	2023-10-15 06:29:02.256873-07:00	2024-04-18 06:06:54.008133-07:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	tm-robot.com	361806.0	www.tm-robot.com/en	2023-10-15 09:02:58.138954-07:00	2024-12-13 06:07:36.830155-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	eureca.me	378793.0	eureca.me	2023-12-19 22:42:18.439534-08:00	2023-12-19 04:46:12.049699-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'
Wp rocket/3.12.1	mygfguide.com	392189.0	www.mygfguide.com	2023-12-23 12:53:39.443677-08:00	2024-01-09 07:22:16.615302-08:00	lower(http_request.response_headers) contains 'wp rocket/3.12.1'

Run A Query

Input

Query Result

Query Plan

Query Result

Data