Input

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

Data

Total Results: 15 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Zb php/5.3.29	zkall.com	573438.0	zkall.com	2023-10-15 09:02:42.876742-07:00	2024-01-03 10:22:15.083112+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hs633.com	786135.0	hs633.com	2023-10-15 09:52:02.912877-07:00	2024-02-20 19:04:03.238137+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqshcs.com	NaN	www.hqshcs.com	2023-11-08 23:37:06.660604-08:00	2023-11-08 23:36:02.378101+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	zgwhxww.com	NaN	zgwhxww.com	2023-11-09 02:06:44.685146-08:00	2023-11-08 20:08:10.211188+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	zgxdysg.com	NaN	zgxdysg.com	2023-11-09 02:47:17.691894-08:00	2023-11-08 21:23:13.066276+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	seyspd.com	NaN	seyspd.com	2023-10-15 17:53:01.133746-07:00	2024-02-05 03:31:55.455346+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	zgmszsw.com	NaN	zgmszsw.com	2023-10-15 15:40:23.183312-07:00	2024-02-16 00:45:05.290247+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	fchqshw.com	NaN	fchqshw.com	2023-10-15 18:02:07.985336-07:00	2024-02-19 03:50:15.970748+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqyszmw.com	NaN	hqyszmw.com	2023-10-15 18:02:07.985336-07:00	2024-02-19 03:43:13.804824+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqwhsc.com	NaN	hqwhsc.com	2023-10-15 15:41:00.869514-07:00	2024-02-16 02:06:54.413908+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	zgcyxww.com	NaN	zgcyxww.com	2023-10-15 21:27:07.528140-07:00	2024-02-26 20:18:47.673799+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	huayiwang.net.cn	NaN	huayiwang.net.cn	2023-10-15 21:29:59.028536-07:00	2024-02-26 22:27:16.760551+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqgyzx.com	NaN	hqgyzx.com	2023-11-09 04:40:35.769411-08:00	2023-11-08 23:44:57.867703+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqwhysw.com	NaN	hqwhysw.com	2023-10-15 18:02:07.985336-07:00	2024-02-26 20:13:25.743849+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'
Zb php/5.3.29	hqshzsw.com	NaN	hqshzsw.com	2023-11-09 02:47:17.691894-08:00	2023-11-08 23:48:45.992803+00:00	lower(http_request.response_headers) contains 'zb php/5.3.29'