Input

field	value
Query:	SELECT 'Hiawatha' 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] = 'hiawatha' 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] = 'hiawatha'::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] = 'hiawatha'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 221 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Hiawatha	leesunlee.kr	127119.0	leesunlee.kr	2024-10-03 14:31:37.041616-07:00	2024-12-02 02:45:17.649609-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	wanyuantemple.tw	149949.0	wanyuantemple.tw	2023-10-15 03:17:10.100749-07:00	2023-10-28 01:25:34.303115-07:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	kmx.kr	163845.0	kmx.kr	2023-10-15 04:34:37.435851-07:00	2024-12-23 02:12:44.414664-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	dseyeon.com	182564.0	dseyeon.com	2023-10-15 02:41:31.500275-07:00	2024-12-02 04:11:20.869770-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	hiawatha-webserver.org	204302.0	www.hiawatha-webserver.org	2023-10-15 05:00:50.350349-07:00	2024-04-09 04:41:03.545981-07:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	antiverte.com	209917.0	antiverte.com	2024-11-14 07:42:19.520467-08:00	2024-12-09 04:11:38.936816-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	piximus.net	230219.0	piximus.net	2023-10-15 05:12:49.722558-07:00	2024-12-13 03:59:46.912138-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	inxin.kr	246940.0	inxin.kr	2023-10-17 13:10:38.949840-07:00	2024-12-11 05:59:09.777692-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	igepn.edu.ec	275683.0	igepn.edu.ec	2024-12-06 14:43:54.301415-08:00	2024-12-12 07:13:10.937296-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	vistamar.info	293166.0	vistamar.info	2024-01-04 12:19:37.357732-08:00	2024-02-21 02:22:20.427811-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	walhello.com	309661.0	www.walhello.com	2023-10-15 05:47:51.258628-07:00	2024-12-09 05:52:43.152171-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	blogbort.com	327306.0	blogbort.com	2024-05-24 22:27:26.558971-07:00	2024-07-07 19:06:58.447952-07:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	kssink.com	346140.0	kssink.com	2023-10-15 03:36:44.267561-07:00	2024-12-11 08:05:44.021490-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	ndmhg.co.kr	354771.0	ndmhg.co.kr	2023-10-15 04:39:13.262957-07:00	2024-12-23 05:51:08.098651-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	kungfucinema.com	363897.0	kungfucinema.com	2023-10-15 06:11:42.126358-07:00	2024-12-13 06:34:58.249043-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	uzeik.net	364252.0	uzeik.net	2023-10-15 10:24:44.291014-07:00	2024-12-13 06:26:19.737223-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	insultmonger.com	378280.0	www.insultmonger.com	2023-10-15 06:40:22.814407-07:00	2024-12-12 09:59:29.497569-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	gulpener.nl	400356.0	www.gulpener.nl	2023-10-15 08:03:47.093833-07:00	2024-12-10 08:11:52.529352-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	kmkeen.com	413868.0	kmkeen.com	2023-10-15 08:05:09.248811-07:00	2024-02-16 07:46:37.791532-08:00	lower(http_request.response_headers) contains 'hiawatha'
Hiawatha	xn--ob0bx78ap3ek4as34bkc.com	437255.0	xn--ob0bx78ap3ek4as34bkc.com	2023-10-15 05:13:22.614705-07:00	2024-09-02 07:24:44.779061-07:00	lower(http_request.response_headers) contains 'hiawatha'