Input

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

Data

Total Results: 25 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Ud forwarding	freeware.de	115639.0	freeware.de	2023-10-15 03:36:40.943498-07:00	2023-11-24 01:00:28.893974-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	onetwomax.de	142808.0	onetwomax.de	2023-10-15 03:35:12.026349-07:00	2023-11-25 01:21:09.361780-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	noerr.com	157981.0	noerr.com	2024-05-28 13:47:25.483987-07:00	2024-05-28 08:53:41.131755-07:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	woolworths.co.uk	235967.0	woolworths.co.uk	2023-10-15 04:38:40.556887-07:00	2023-12-10 02:06:32.554425-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	mopo24.de	244999.0	mopo24.de	2023-10-15 04:47:32.341746-07:00	2023-11-24 02:06:35.360008-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	db4o.com	366324.0	db4o.com	2023-10-15 06:29:02.256873-07:00	2024-12-13 06:55:28.478212-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	shareware.de	393598.0	shareware.de	2023-10-15 06:38:19.167895-07:00	2023-12-15 03:49:23.940450-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	unperfekthaus.de	410073.0	unperfekthaus.de	2024-03-21 17:31:53.238985-07:00	2024-03-21 05:47:13.186698-07:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	nikerevolution.us	592658.0	nikerevolution.us	2023-10-15 06:58:08.965276-07:00	2023-12-15 05:23:40.661481-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	hotelguide.com	604254.0	hotelguide.com	2023-10-15 09:47:45.498440-07:00	2023-11-26 05:41:56.618387-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	nowhere.com	613350.0	nowhere.com	2023-10-15 10:14:08.353671-07:00	2023-12-06 06:58:41.809958-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	kilianschoenberger.de	708034.0	kilianschoenberger.de	2023-10-15 13:42:04.696678-07:00	2023-11-13 10:24:05.007991-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	bonn.berlin	714567.0	bonn.berlin	2023-10-16 08:50:48.329825-07:00	2023-11-29 04:20:32.374254-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	kostenloses-forum.be	731500.0	kostenloses-forum.be	2023-10-15 11:01:14.303822-07:00	2023-11-28 07:25:20.066019-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	meome.de	741824.0	meome.de	2023-10-15 12:20:19.120765-07:00	2023-12-20 08:25:45.284549-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	guennewig.de	918170.0	guennewig.de	2023-10-15 14:38:17.296007-07:00	2023-10-26 10:57:25.947942-07:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	popuri.us	929549.0	popuri.us	2023-10-15 14:28:05.353391-07:00	2023-11-22 09:56:11.787307-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	ratschlag24.com	946288.0	ratschlag24.com	2023-10-15 15:31:21.603958-07:00	2023-11-23 10:43:38.246569-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	muenchen-tv.de	962087.0	muenchen-tv.de	2023-10-15 14:38:17.296007-07:00	2023-11-22 09:59:26.531340-08:00	lower(http_request.response_headers) contains 'ud forwarding'
Ud forwarding	glossar.de	968106.0	glossar.de	2023-11-09 01:44:52.509500-08:00	2023-11-08 15:55:28.062771-08:00	lower(http_request.response_headers) contains 'ud forwarding'