Input

field	value
Query:	SELECT 'Ubuntu3.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] = 'ubuntu3.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] = 'ubuntu3.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] = 'ubuntu3.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: 142 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Ubuntu3.26	fc2.com	581.0	analyzer.fc2.com	2023-10-15 13:58:15.837787+00:00	2024-12-13 07:11:02.202361-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	mibbit.com	24331.0	search.mibbit.com	2023-10-16 14:04:43.793961+00:00	2024-10-08 13:39:37.978241-07:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	maemo.org	26413.0	maemo.org	2023-10-16 08:45:00.280449+00:00	2024-10-12 01:03:32.672954-07:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	salem-news.com	36129.0	salem-news.com	2023-10-16 08:46:37.479980+00:00	2024-12-12 02:06:59.191265-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	dotclear.org	40632.0	dotclear.org	2023-10-15 11:27:30.870060+00:00	2024-12-12 04:13:46.713957-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	gumer.info	40985.0	www.gumer.info	2023-10-16 08:46:37.479980+00:00	2024-10-08 01:12:35.412533-07:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	psychologies.ru	53325.0	www.psychologies.ru	2023-10-16 09:41:51.082152+00:00	2024-12-23 00:53:35.987630-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	thailande.ru	66466.0	www.thailande.ru	2023-10-16 09:15:30.711992+00:00	2024-12-23 01:12:00.012279-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	silicon-power.com	67640.0	www.silicon-power.com//web/us	2023-10-15 09:42:47.299365+00:00	2024-12-23 01:20:26.683147-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	casadelahistoriadevenezuela.com	73824.0	casadelahistoriadevenezuela.com	2023-10-16 09:10:05.102012+00:00	2024-12-13 01:43:14.688323-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	tvc-krsk.ru	76512.0	tvc-krsk.ru	2023-10-16 09:12:51.151783+00:00	2024-12-13 01:49:39.250151-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	cabildofuer.es	82124.0	www.cabildofuer.es/cabildo	2023-10-15 13:37:58.508907+00:00	2023-12-30 03:33:49.690279-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	hwagyesa.org	85691.0	hwagyesa.org	2023-10-16 08:29:45.222754+00:00	2023-12-12 00:09:25.412952-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	musichunt.pro	87650.0	www.musichunt.pro	2023-10-15 09:42:43.082224+00:00	2024-10-02 01:22:37.886155-07:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	world-newspapers.com	94600.0	www.world-newspapers.com	2023-10-15 10:17:11.749172+00:00	2024-04-30 02:35:02.497379-07:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	alternatio.org	95477.0	alternatio.org	2023-10-15 10:32:49.246077+00:00	2024-12-07 02:17:10.421470-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	eloiseplease.com	97417.0	eloiseplease.com	2023-10-15 10:35:14.855042+00:00	2024-12-07 02:24:30.933284-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	jm-tech.com.tw	98654.0	jm-tech.com.tw	2023-10-15 10:32:54.049990+00:00	2024-12-07 02:24:04.877811-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	rg-be.ru	101219.0	rg-be.ru	2023-10-15 11:22:05.050003+00:00	2024-12-23 01:18:06.662244-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'
Ubuntu3.26	blogalia.com	103349.0	www.blogalia.com	2023-10-15 10:17:10.100749+00:00	2024-03-02 01:14:34.139756-08:00	lower(http_request.response_headers) contains 'ubuntu3.26'