Input

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

Data

Total Results: 288 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Varnish/7.0	decrypt.co	3603.0	decrypt.co	2023-10-15 07:23:02.547656-07:00	2024-12-13 09:00:12.786535-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	hypotheses.org	3695.0	hypotheses.org	2023-10-16 02:25:52.872100-07:00	2024-05-29 00:25:40.592699-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	london.gov.uk	3781.0	www.london.gov.uk/who-we-are/city-halls-buildings-and-squares/what-can-you-visit-city-hall	2023-10-15 11:47:29.810090-07:00	2024-12-03 15:03:43.247868-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	republicworld.com	4993.0	www.republicworld.com	2024-02-28 16:26:46.423119-08:00	2024-06-20 00:45:42.983538-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	wellcome.org	5854.0	wellcome.org	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:44:18.923964-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	unlp.edu.ar	6931.0	unlp.edu.ar	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:38:38.508677-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	workday.com	6974.0	community.workday.com/invalid-url	2024-08-19 15:15:56.881173-07:00	2024-12-12 01:59:55.335996-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	leica-camera.com	8700.0	leica-camera.com/en-us	2023-10-16 02:25:52.872100-07:00	2024-12-13 00:44:28.223295-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	blackbaud.com	8835.0	host.nxt.blackbaud.com	2024-02-09 05:27:03.348333-08:00	2024-12-13 01:51:21.793824-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	blogg.se	9220.0	blogg.se	2024-10-04 01:42:17.060980-07:00	2024-12-13 00:41:23.660485-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	uni-augsburg.de	10719.0	www.uni-augsburg.de/de	2023-10-16 02:40:08.514688-07:00	2024-03-07 00:05:28.877590-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	unipa.it	14609.0	www.unipa.it	2023-10-16 02:40:08.514688-07:00	2024-12-14 00:10:12.033010-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	abus.com	16357.0	mobil.abus.com/de	2023-10-15 05:13:19.426909-07:00	2023-10-16 02:37:08.672691-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	invezz.com	22967.0	invezz.com	2023-10-15 08:05:09.248811-07:00	2024-05-01 00:55:14.986448-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	pioneer-car.eu	24643.0	www.pioneer-car.eu/eur/sites/segmentation/segmentation	2023-10-15 05:20:38.747396-07:00	2023-11-25 02:34:58.067717-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	kurir.rs	24728.0	www.kurir.rs	2024-01-25 05:15:14.579677-08:00	2024-12-23 00:33:46.180471-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	nyheter24.se	33717.0	nyheter24.se	2023-10-16 01:29:45.222754-07:00	2024-12-12 01:55:23.707055-08:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	hlj.com	33799.0	www.hlj.com	2023-10-16 01:29:45.222754-07:00	2024-06-26 01:56:36.606045-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	watson.de	34061.0	www.watson.de	2023-10-16 02:15:30.711992-07:00	2024-07-01 01:56:52.166600-07:00	lower(http_request.response_headers) contains 'varnish/7.0'
Varnish/7.0	fanuc.eu	34401.0	www.fanuc.eu/eu-en	2024-11-13 12:05:32.117941-08:00	2024-12-12 01:59:50.040459-08:00	lower(http_request.response_headers) contains 'varnish/7.0'