Input

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

Data

Total Results: 6 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Phusion_passenger/5.0.26	dbb.de	111136.0	www.dbb.de	2023-10-21 15:41:24.891041-07:00	2024-01-29 03:17:19.192119-08:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'
Phusion_passenger/5.0.26	gdl.de	340097.0	www.gdl.de	2023-10-15 08:22:16.407667-07:00	2024-03-14 04:02:02.844487-07:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'
Phusion_passenger/5.0.26	dpolg.de	486169.0	www.dpolg.de	2023-10-15 05:48:58.677213-07:00	2024-03-18 04:30:24.939616-07:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'
Phusion_passenger/5.0.26	goko.go.jp	779382.0	www.goko.go.jp	2023-10-15 13:08:07.948674-07:00	2024-03-12 13:39:42.625018-07:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'
Phusion_passenger/5.0.26	dpolg.berlin	NaN	www.dpolg.berlin	2023-11-09 01:19:17.106610-08:00	2023-11-08 15:50:44.785902-08:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'
Phusion_passenger/5.0.26	sbb.de	NaN	www.sbb.de	2023-11-09 05:07:39.977593-08:00	2023-11-08 13:01:20.755207-08:00	lower(http_request.response_headers) contains 'phusion_passenger/5.0.26'