Input

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

Data

Total Results: 88 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Nginx/1.0.13	jonfan.com	76568.0	jonfan.com	2023-10-15 02:41:24.852886-07:00	2023-10-31 00:35:39.370386-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	wzchuyin.com	79093.0	wzchuyin.com	2023-11-30 01:21:07.347699-08:00	2023-11-30 00:09:42.819895-08:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	suibianhu.com	85400.0	suibianhu.com	2024-09-10 07:18:44.665628-07:00	2024-09-10 02:06:52.181136-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	shendun520.com	85707.0	shendun520.com	2024-04-03 06:54:05.946975-07:00	2024-05-25 02:17:59.698919-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	wxtianchang.com	94446.0	wxtianchang.com	2024-03-14 06:20:12.174680-07:00	2024-03-14 00:23:29.819498-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	sohocapital.cn	100647.0	sohocapital.cn	2024-06-18 15:34:24.087578-07:00	2024-06-18 13:26:30.277308-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	richnew.cn	118744.0	richnew.cn	2024-05-24 16:14:38.033336-07:00	2024-06-29 13:06:30.440932-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	abbforum.com	125861.0	abbforum.com	2024-01-08 04:17:45.709582-08:00	2024-02-07 01:02:32.211032-08:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	ahyqkj.com	127941.0	ahyqkj.com	2023-10-15 02:41:31.500275-07:00	2023-10-18 00:46:56.283271-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	tjkyhr.com	152016.0	tjkyhr.com	2024-08-21 09:44:06.929232-07:00	2024-09-09 02:37:20.745719-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	shyhjj.com	160290.0	shyhjj.com	2024-02-03 05:29:17.007927-08:00	2024-02-18 01:39:22.393446-08:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	business-inchina.com	165830.0	business-inchina.com	2024-08-19 20:11:55.381398-07:00	2024-08-31 04:12:12.200408-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	fgxyy.com	191825.0	fgxyy.com	2023-10-15 03:17:08.417916-07:00	2023-11-02 00:53:09.676054-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	fegcosmetic.com	234139.0	fegcosmetic.com	2023-10-18 02:40:03.999481-07:00	2023-11-18 00:55:06.130619-08:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	sdzscm.cn	358757.0	sdzscm.cn	2024-09-09 23:27:08.683745-07:00	2024-09-09 09:25:54.675905-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	11lu.net	422150.0	11lu.net	2024-05-02 21:17:21.602073-07:00	2024-05-26 11:25:52.978664-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	9955yh.com	438840.0	9955yh.com	2023-10-15 04:35:10.052577-07:00	2023-10-30 01:42:31.923603-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	ashleyshortphotography.com	517949.0	ashleyshortphotography.com	2023-10-23 20:18:18.483919-07:00	2024-02-27 05:19:08.141919-08:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	xfqdszx.cn	522001.0	xfqdszx.cn	2024-08-29 22:50:02.764342-07:00	2024-09-10 11:58:14.208040-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'
Nginx/1.0.13	lyphp.cn	522221.0	lyphp.cn	2024-08-29 23:29:17.333593-07:00	2024-09-10 12:29:37.304104-07:00	lower(http_request.response_headers) contains 'nginx/1.0.13'