Input

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

Data

Total Results: 67 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Perl/v5.32.1	financialcontent.com	7172.0	markets.financialcontent.com/stocks	2023-10-16 01:29:45.222754-07:00	2024-12-23 00:41:34.585540-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	capcom.com	11230.0	www.capcom.com	2023-10-16 02:41:01.001125-07:00	2024-12-14 00:03:48.849100-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	colgate.edu	11353.0	math.colgate.edu/~integers	2023-10-15 12:19:57.068357-07:00	2024-12-13 12:52:42.306806-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	newmexico.gov	19430.0	edd.newmexico.gov	2023-10-15 09:03:21.450485-07:00	2024-02-16 09:18:07.810749-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	schmorp.de	60592.0	software.schmorp.de	2023-10-15 02:42:47.299365-07:00	2024-03-26 00:57:23.299581-07:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	queendom.com	80244.0	www.queendom.com	2024-10-09 06:09:03.569599-07:00	2024-12-23 01:08:50.032010-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	211.ca	97349.0	211.ca	2023-10-15 03:36:40.943498-07:00	2024-03-05 01:12:58.662080-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	links.net	100244.0	links.net	2023-10-16 02:20:20.543707-07:00	2024-12-23 01:25:26.184403-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	psychtests.com	104667.0	testyourself.psychtests.com	2024-10-08 09:43:17.133261-07:00	2024-12-23 01:32:06.293569-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	byd.pl	116969.0	wsg.byd.pl/strona-glowna	2023-10-15 03:28:22.643572-07:00	2024-01-25 01:58:57.074042-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	times-online.com	118148.0	business.times-online.com	2024-01-09 06:36:30.889202-08:00	2024-12-12 04:21:38.738287-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	northernminer.com	118665.0	northernminer.com	2024-01-18 14:46:54.983422-08:00	2024-12-11 03:28:54.506168-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	spaceportamerica.com	145516.0	www.spaceportamerica.com	2023-10-15 04:22:20.860697-07:00	2024-12-12 04:34:53.375445-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	tenthousandwaves.com	185629.0	tenthousandwaves.com	2023-10-15 04:27:05.196680-07:00	2024-11-29 03:41:43.632920-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	dotat.at	215587.0	dotat.at	2023-10-15 05:48:00.037408-07:00	2024-12-23 03:21:41.129413-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	cookipedia.co.uk	220380.0	www.cookipedia.co.uk/recipes_wiki/welcome_to_cookipedia	2024-04-12 01:26:14.779916-07:00	2024-08-21 07:49:36.660665-07:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	unitedway.ca	222619.0	www.unitedway.ca	2023-10-15 04:34:48.402190-07:00	2024-03-08 02:42:35.907226-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	fenetre.com	223837.0	www.fenetre.com	2024-08-27 10:59:55.037721-07:00	2024-12-05 03:26:10.312118-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	capcomusa.com	242824.0	capcomusa.com	2023-10-15 05:12:49.722558-07:00	2024-12-11 05:44:48.889666-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'
Perl/v5.32.1	bioniccommando.com	243534.0	www.bioniccommando.com	2023-10-15 06:40:47.686227-07:00	2024-12-11 05:39:47.187717-08:00	lower(http_request.response_headers) contains 'perl/v5.32.1'