Input

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

Data

Total Results: 524 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Blitz	hugedomains.com	265.0	www.hugedomains.com/domain_profile	2024-03-11 14:49:59.387169-07:00	2024-03-11 09:47:24.515355-07:00	lower(http_request.response_headers) contains 'blitz'
Blitz	npmjs.com	774.0	www.npmjs.com	2024-04-19 01:23:40.490549-07:00	2024-04-19 00:02:05.326351-07:00	lower(http_request.response_headers) contains 'blitz'
Blitz	sophos.com	1129.0	community.sophos.com/sandboxie	2024-01-03 18:01:08.314441-08:00	2024-01-03 00:01:55.009464-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	mcdonalds.com	1489.0	www.mcdonalds.com/ca/en-ca	2024-08-27 05:33:31.271744-07:00	2024-08-27 02:48:14.600227-07:00	lower(http_request.response_headers) contains 'blitz'
Blitz	cloudinary.com	1695.0	cloudinary.com	2023-10-15 06:37:53.096359-07:00	2024-12-13 07:01:57.343552-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	webfx.com	2461.0	www.webfx.com	2024-02-27 18:42:47.121564-08:00	2024-02-27 00:19:47.220794-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	transparency.org	2790.0	www.transparency.org	2023-10-16 02:25:52.872100-07:00	2024-01-29 00:13:36.672392-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	alabama.gov	3358.0	www.alabama.gov/subscriptions	2024-12-23 20:18:20.543148-08:00	2024-12-23 03:02:08.446854-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	planetary.org	5636.0	www.planetary.org	2023-10-25 02:22:20.028260-07:00	2024-12-09 00:20:18.068179-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	linksapp.top	6805.0	linksapp.top	2024-10-10 06:20:54.861080-07:00	2024-10-10 00:20:04.993107-07:00	lower(http_request.response_headers) contains 'blitz'
Blitz	inthesetimes.com	6906.0	inthesetimes.com	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:34:19.802028-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	windowsreport.com	8454.0	windowsreport.com	2023-11-23 18:33:35.948030-08:00	2023-11-23 00:02:23.010661-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	transportenvironment.org	8550.0	www.transportenvironment.org	2024-11-13 01:49:49.755932-08:00	2024-11-13 00:58:05.763336-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	bmel.de	9306.0	www.bmel.de/de/home/home_node	2023-10-15 02:41:31.500275-07:00	2024-12-23 01:13:37.609815-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	trustedshops.com	9557.0	www.trustedshops.com	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:46:18.075239-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	batteryuniversity.com	11799.0	batteryuniversity.com	2023-10-15 10:06:10.824926-07:00	2024-12-14 00:08:14.217896-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	moneygram.com	12167.0	www.moneygram.com/mgo/us/en	2024-02-10 21:44:13.837048-08:00	2024-02-10 00:07:43.450741-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	urssaf.fr	12170.0	mon-entreprise.urssaf.fr	2023-10-15 13:10:48.338548-07:00	2023-12-15 07:37:01.132025-08:00	lower(http_request.response_headers) contains 'blitz'
Blitz	pogo.org	12819.0	www.pogo.org/projects-and-partnerships	2023-10-16 02:12:51.151783-07:00	2024-10-10 11:53:52.142011-07:00	lower(http_request.response_headers) contains 'blitz'
Blitz	centralparknyc.org	12888.0	www.centralparknyc.org	2023-11-21 23:28:15.272210-08:00	2024-06-26 01:06:13.171371-07:00	lower(http_request.response_headers) contains 'blitz'