Input

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

Data

Total Results: 400 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.3.10	fc2.com	581.0	analyzer.fc2.com	2023-10-15 13:58:15.837787+00:00	2024-12-13 07:11:02.202361-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	kr.ua	3481.0	kr.ua	2024-08-19 20:35:27.177515+00:00	2024-12-13 00:26:01.568324-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	anglican.org	8667.0	anglican.org	2023-10-16 09:24:31.826640+00:00	2024-12-13 00:41:49.017496-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	unifesp.br	13101.0	unifesp.br	2023-10-16 09:41:01.001125+00:00	2023-10-21 00:19:53.348443-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	htcdev.com	16667.0	www.htcdev.com	2023-10-16 09:41:32.700533+00:00	2024-02-28 00:13:02.217350-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	mibbit.com	24331.0	search.mibbit.com	2023-10-16 14:04:43.793961+00:00	2024-10-08 13:39:37.978241-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	maemo.org	26413.0	maemo.org	2023-10-16 08:45:00.280449+00:00	2024-10-12 01:03:32.672954-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	unesa.ac.id	31316.0	unesa.ac.id	2023-10-16 09:10:05.102012+00:00	2024-09-29 00:39:33.281785-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	nomachine.com	34405.0	www.nomachine.com	2023-10-16 08:56:02.570067+00:00	2024-02-21 00:52:38.804403-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	tvr.ro	35954.0	www.tvr.ro	2023-10-16 08:46:37.479980+00:00	2024-12-10 00:52:27.594532-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	salem-news.com	36129.0	salem-news.com	2023-10-16 08:46:37.479980+00:00	2024-12-12 02:06:59.191265-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	newdaynews.ru	37595.0	newdaynews.ru/ural	2023-10-15 12:13:33.527187+00:00	2024-12-12 07:12:52.551050-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	dotclear.org	40632.0	dotclear.org	2023-10-15 11:27:30.870060+00:00	2024-12-12 04:13:46.713957-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	gumer.info	40985.0	www.gumer.info	2023-10-16 08:46:37.479980+00:00	2024-10-08 01:12:35.412533-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	devicedoctor.com	41894.0	devicedoctor.com	2023-10-16 08:29:45.222754+00:00	2024-12-12 02:17:59.629643-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	uni-miskolc.hu	44056.0	www.uni-miskolc.hu/	2023-10-16 09:15:30.711992+00:00	2024-03-26 00:07:50.061269-07:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	bizvion.kr	44543.0	whitelinedental.bizvion.kr	2023-10-15 11:35:18.012042+00:00	2024-12-23 03:07:26.298945-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	ucv.ve	44738.0	ucv.ve	2024-05-01 16:28:31.789617+00:00	2024-12-12 02:24:04.579193-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	leaders.com.tn	46887.0	leaders.com.tn	2023-10-16 08:56:02.570067+00:00	2024-12-12 02:36:30.494436-08:00	lower(http_request.response_headers) contains 'php/5.3.10'
Php/5.3.10	psychologies.ru	53325.0	www.psychologies.ru	2023-10-16 09:41:51.082152+00:00	2024-12-23 00:53:35.987630-08:00	lower(http_request.response_headers) contains 'php/5.3.10'