Input

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

Data

Total Results: 76 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/7.4.4	psychologicalscience.org	3419.0	www.psychologicalscience.org	2023-10-16 02:23:22.789681-07:00	2024-01-29 00:16:17.697698-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	vgchartz.com	15496.0	www.vgchartz.com	2023-10-16 02:40:08.514688-07:00	2024-12-14 00:13:47.923399-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	utp.edu.co	35541.0	www.utp.edu.co	2023-11-09 23:32:41.266138-08:00	2024-02-13 01:22:57.586640-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	undiksha.ac.id	64974.0	tte.undiksha.ac.id/speed	2024-10-04 10:26:08.826302-07:00	2024-10-04 05:51:31.217291-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	slidetodoc.com	70788.0	slidetodoc.com	2023-10-16 02:44:01.481699-07:00	2024-12-13 01:33:56.733761-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	belygorod.ru	73049.0	belygorod.ru	2024-08-25 21:41:30.212584-07:00	2024-12-13 01:39:47.091237-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	noravank.am	74690.0	noravank.am	2024-04-18 18:50:55.291442-07:00	2024-12-02 02:11:59.653274-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	mentalhealth.org.nz	84807.0	mentalhealth.org.nz	2023-10-15 03:37:16.392771-07:00	2024-12-23 01:24:36.245130-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	themoviespoiler.com	100363.0	themoviespoiler.com	2023-10-15 04:22:02.051440-07:00	2024-12-23 01:18:07.914273-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	bushimo.jp	113787.0	www.bushimo.jp	2023-10-15 03:17:10.100749-07:00	2023-10-16 00:54:55.909873-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	tverigrad.ru	121581.0	tverigrad.ru	2023-10-21 15:47:14.363859-07:00	2023-11-04 01:18:47.861496-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	azerbaycan24.com	145975.0	www.azerbaycan24.com	2023-10-25 21:37:56.550903-07:00	2024-06-03 09:45:14.765491-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	iot.ru	146572.0	iot.ru	2023-10-21 15:47:14.363859-07:00	2023-11-17 01:03:05.119275-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	partners.io	148153.0	partners.io/en	2023-10-15 05:41:36.752471-07:00	2024-12-12 04:48:39.987004-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	ubos.org	153465.0	www.ubos.org	2024-02-29 05:09:06.433385-08:00	2024-04-30 05:17:10.578037-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	ccg.org	157744.0	ccg.org	2023-10-15 05:49:05.926520-07:00	2024-12-06 03:56:52.801585-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	navi.gg	160795.0	navi.gg/en	2023-10-15 03:41:13.458034-07:00	2024-12-23 02:04:35.206566-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	snowbasin.com	162203.0	www.snowbasin.com	2023-10-15 04:27:03.552131-07:00	2023-10-18 02:36:42.383778-07:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	sourcemod.net	206460.0	www.sourcemod.net	2023-10-15 04:22:17.506069-07:00	2024-12-09 03:42:02.565844-08:00	lower(http_request.response_headers) contains 'php/7.4.4'
Php/7.4.4	kawarthanow.com	222564.0	kawarthanow.com	2023-10-15 05:02:23.010722-07:00	2024-12-05 03:50:51.888725-08:00	lower(http_request.response_headers) contains 'php/7.4.4'