Input

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

Data

Total Results: 52 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.6.34	brocku.ca	8167.0	brocku.ca	2023-11-24 21:43:50.701128-08:00	2024-12-12 01:03:50.812486-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	ispeech.org	63142.0	www.ispeech.org	2023-10-15 03:35:13.239801-07:00	2024-12-23 01:13:13.168534-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	plantoneintl.com	85627.0	www.plantoneintl.com	2023-10-15 02:41:26.437800-07:00	2024-05-02 03:09:49.935919-07:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	vibia.com	109827.0	vibia.com	2023-10-21 16:55:59.313538-07:00	2024-01-14 01:07:29.099808-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	zhangyi123.com	112319.0	zhangyi123.com	2023-10-15 03:35:10.261412-07:00	2024-12-11 03:04:59.574038-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	thefly.com	131285.0	thefly.com	2024-02-09 21:12:38.243939-08:00	2024-12-12 04:04:11.663485-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	pressmax.ru	211789.0	pressmax.ru	2023-10-15 04:27:33.526375-07:00	2024-12-23 02:54:06.355524-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	cu.ac.kr	228767.0	cu.ac.kr/index	2023-10-15 06:58:00.033440-07:00	2024-12-05 03:44:22.358457-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	t-progress.ru	281322.0	t-progress.ru	2024-10-06 17:55:11.100836-07:00	2024-12-08 04:48:05.275715-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	critical-art.net	285936.0	critical-art.net	2023-10-15 05:48:03.567747-07:00	2024-12-08 05:14:33.622782-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	1dom.info	324904.0	1dom.info	2023-10-15 04:38:53.733149-07:00	2023-11-21 02:14:06.152310-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	gregbear.com	340450.0	gregbear.com	2023-10-15 08:12:37.841376-07:00	2024-05-25 14:15:51.534131-07:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	karunaspa.ru	352578.0	karunaspa.ru	2023-10-15 11:07:33.631167-07:00	2024-01-07 05:11:05.210221-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	kodokanjudoinstitute.org	371496.0	kodokanjudoinstitute.org	2023-10-15 04:27:28.590402-07:00	2024-03-15 02:02:54.456639-07:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	grani21.ru	385450.0	grani21.ru	2023-10-15 05:48:03.567747-07:00	2024-04-16 08:09:43.806968-07:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	similarpornsites.net	405465.0	similarpornsites.net	2023-10-15 05:13:27.976349-07:00	2023-10-29 02:51:46.815583-07:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	daiwa-dp.co.jp	422827.0	daiwa-dp.co.jp	2023-10-15 08:13:09.485753-07:00	2024-12-05 07:32:28.210870-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	nikufes.jp	449751.0	nikufes.jp	2023-10-15 08:06:50.226103-07:00	2024-12-10 10:14:05.455810-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	meio-u.ac.jp	458364.0	www.meio-u.ac.jp	2023-10-15 09:04:30.300811-07:00	2024-12-04 09:59:26.750213-08:00	lower(http_request.response_headers) contains 'php/5.6.34'
Php/5.6.34	blacklistalert.org	480646.0	blacklistalert.org	2023-10-15 09:04:02.391534-07:00	2024-12-03 10:34:24.101959-08:00	lower(http_request.response_headers) contains 'php/5.6.34'