Input

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

Data

Total Results: 1,827 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Apache/2.4.54	openstreetmap.org	359.0	www.openstreetmap.org	2023-10-15 15:39:51.634385-07:00	2024-07-08 01:17:27.456219-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	vanderbilt.edu	1078.0	www.vanderbilt.edu/jetlaw	2023-10-15 12:51:15.677367-07:00	2024-02-19 14:57:51.003733-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	uic.edu	1426.0	www.uic.edu	2023-10-16 02:24:31.826640-07:00	2024-05-03 00:44:05.241287-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	uh.edu	1590.0	www.instruction.uh.edu	2024-03-20 16:05:06.023087-07:00	2024-12-09 07:54:01.737381-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	zotero.org	1975.0	www.zotero.org	2023-10-16 02:23:22.789681-07:00	2023-12-03 00:05:07.043138-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	site123.me	2085.0	65793b39514be.site123.me	2023-12-13 11:09:28.907958-08:00	2023-12-14 06:20:53.941224-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	ballotpedia.org	2521.0	ballotpedia.org	2023-10-16 02:25:52.872100-07:00	2024-12-13 00:23:10.648553-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	ahrq.gov	2811.0	www.ahrq.gov	2023-10-15 04:38:32.055684-07:00	2023-11-03 00:15:49.216127-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	wtop.com	2998.0	wtop.com	2023-10-15 02:42:45.998931-07:00	2024-03-21 01:07:40.355170-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	nrf.com	3096.0	nexus.nrf.com	2023-10-15 04:34:37.435851-07:00	2024-03-15 01:48:29.337335-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	wm.edu	3764.0	www.wm.edu	2023-10-16 02:25:52.872100-07:00	2024-09-17 00:15:37.565210-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	bookstime.com	4015.0	www.bookstime.com	2023-10-16 02:24:31.826640-07:00	2024-09-02 00:28:44.077288-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	escardio.org	5327.0	www.escardio.org	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:31:13.848012-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	helpnetsecurity.com	6316.0	www.helpnetsecurity.com	2023-10-16 01:13:44.105098-07:00	2024-12-23 00:47:40.718040-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	greatplacetowork.com	6599.0	www.greatplacetowork.com	2023-10-15 07:23:52.687345-07:00	2024-03-29 00:24:13.176511-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	ccel.org	7558.0	ccel.org	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:35:17.845885-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	ccohs.ca	7713.0	www.ccohs.ca	2023-10-16 02:24:31.826640-07:00	2024-02-09 00:40:31.846837-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	psl.eu	7997.0	psl.eu	2023-10-16 02:23:22.789681-07:00	2024-12-09 00:31:45.583091-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	knaw.nl	8482.0	dans.knaw.nl/nl/data-diensten/narcis	2023-10-15 03:32:26.649483-07:00	2024-01-22 01:20:45.961771-08:00	lower(http_request.response_headers) contains 'apache/2.4.54'
Apache/2.4.54	hhmi.org	8746.0	www.hhmi.org	2023-10-16 02:24:31.826640-07:00	2023-10-21 00:28:39.452508-07:00	lower(http_request.response_headers) contains 'apache/2.4.54'