Input

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

Data

Total Results: 7 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.4.7	uprightmedia.co.kr	191718.0	uprightmedia.co.kr	2023-12-09 14:37:48.700900-08:00	2024-12-23 02:25:07.638240-08:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	xn--oy2bp0c52i10c9tal0f.com	333820.0	xn--oy2bp0c52i10c9tal0f.com	2024-05-27 16:28:32.778962-07:00	2024-12-01 05:04:46.192868-08:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	xn--dmc-er3mk84c9xam7fdsikwd79hs0w.com	648099.0	xn--dmc-er3mk84c9xam7fdsikwd79hs0w.com	2024-06-16 21:01:33.172144-07:00	2024-12-06 13:07:15.876703-08:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	trungtamytehaiha.vn	654968.0	trungtamytehaiha.vn	2023-10-15 10:38:15.634349-07:00	2024-03-20 08:52:47.958042-07:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	arukumachikyoto.jp	956769.0	arukumachikyoto.jp	2023-11-09 01:02:26.919951-08:00	2023-11-08 11:31:11.262742-08:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	portal.bg	NaN	portal.bg/hosting	2023-10-15 12:51:15.677367-07:00	2023-10-26 09:27:01.222066-07:00	lower(http_request.response_headers) contains 'php/5.4.7'
Php/5.4.7	av380.cn	NaN	av380.cn	2023-10-15 15:14:32.292737-07:00	2024-02-18 17:48:29.137160-08:00	lower(http_request.response_headers) contains 'php/5.4.7'