Input

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

Data

Total Results: 3,662 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Apache/2.2.9	archive.org	63.0	web.archive.org/web/20130729200341id_/http://www	2023-10-15 09:42:39.409345+00:00	2024-12-13 01:46:15.078750-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	ufmg.br	2732.0	www.periodicos.letras.ufmg.br/files/journals/6/articles/22674/submission/original/22674-1125639250-2-sm	2023-10-15 17:06:10.824926+00:00	2024-03-01 11:11:28.337593-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	photoscape.org	24167.0	photoscape.org/ps/main/index	2023-10-16 08:13:44.105098+00:00	2024-12-23 00:31:08.910643-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	ignou.ac.in	30957.0	ignou.ac.in	2023-10-16 08:45:00.280449+00:00	2024-06-09 00:42:37.344488-07:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	freewebtown.com	43816.0	www.freewebtown.com	2023-10-16 09:15:30.711992+00:00	2023-11-28 00:02:24.094552-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	thermcom.cz	68309.0	thermcom.cz	2023-10-16 09:41:51.082152+00:00	2024-12-23 01:16:41.546695-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	fobas.cz	70059.0	fobas.cz	2023-10-16 09:12:51.151783+00:00	2024-12-13 01:30:02.198838-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	countryclaim.cz	72540.0	countryclaim.cz	2023-10-16 09:43:34.479410+00:00	2024-12-13 01:36:06.834703-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	bojovesporty.cz	75947.0	bojovesporty.cz	2023-10-16 09:43:34.479410+00:00	2024-12-13 01:51:20.980987-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	zoo-foto.cz	82902.0	zoo-foto.cz	2023-10-16 09:43:34.479410+00:00	2024-12-23 01:15:53.702724-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	rracc.com	88386.0	rracc.com	2023-10-15 09:41:26.437800+00:00	2024-12-23 01:35:05.895510-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	dotbamboo.com	89881.0	dotbamboo.com	2023-10-15 09:41:22.676770+00:00	2024-10-10 02:12:10.481510-07:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	cuso-edu.ru	101329.0	cuso-edu.ru	2023-10-16 09:43:34.479410+00:00	2024-12-23 01:23:26.473053-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	wgadget.com	102339.0	wgadget.com	2023-10-15 09:41:31.500275+00:00	2024-12-23 01:21:08.285388-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	testron.ru	105067.0	testron.ru	2023-10-15 10:32:34.049387+00:00	2024-12-23 01:32:09.985466-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	pop-around.com	106406.0	pop-around.com	2023-10-15 09:41:30.298350+00:00	2024-12-23 01:43:28.977490-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	unsl.edu.ar	111084.0	unsl.edu.ar	2023-10-15 10:37:20.214205+00:00	2024-03-01 00:44:17.626742-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	medizinfo.de	112974.0	www.medizinfo.de	2023-10-15 10:36:44.267561+00:00	2024-12-11 03:05:36.094828-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	idm-energie.cz	117786.0	idm-energie.cz	2023-10-15 09:42:47.299365+00:00	2024-12-11 03:29:52.491467-08:00	lower(http_request.response_headers) contains 'apache/2.2.9'
Apache/2.2.9	veterina-naslunci.cz	118833.0	veterina-naslunci.cz	2023-10-15 10:33:08.913001+00:00	2024-10-10 02:34:41.994601-07:00	lower(http_request.response_headers) contains 'apache/2.2.9'