Input

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

Data

Total Results: 10 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Sailsjs.org	5miles.com	112763.0	www.5miles.com	2023-10-15 03:32:49.246077-07:00	2024-12-11 03:13:46.296689-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	urbanadventures.com	124649.0	urbanadventures.com	2023-11-14 15:40:40.770420-08:00	2023-11-29 01:01:45.882516-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	wizer.me	340678.0	app.wizer.me	2023-10-16 03:48:14.025975-07:00	2024-12-11 07:37:31.249772-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	canadianwebhosting.com	425986.0	canadianwebhosting.com	2023-10-15 07:50:29.212393-07:00	2024-12-06 10:45:39.072719-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	cases.media	446089.0	cases.media	2023-10-15 10:14:27.391840-07:00	2024-12-10 09:39:09.610376-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	minicabit.com	588813.0	www.minicabit.com	2023-10-15 09:48:03.201555-07:00	2024-10-08 15:09:54.861586-07:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	getplan.co	711261.0	getplan.co	2023-10-15 11:21:32.266017-07:00	2024-12-09 14:47:09.625057-08:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	dharma-production.com	816131.0	dharma-production.com	2023-10-15 12:02:15.003245-07:00	2024-08-30 17:48:16.999829-07:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	galaxycine.vn	872879.0	www.galaxycine.vn	2023-10-15 13:04:10.815344-07:00	2023-10-16 10:13:11.084654-07:00	lower(http_request.response_headers) contains 'sailsjs.org'
Sailsjs.org	lulufanatics.com	NaN	www.lulufanatics.com	2023-11-08 23:37:06.660604-08:00	2024-12-10 08:55:59.666100-08:00	lower(http_request.response_headers) contains 'sailsjs.org'