Input

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

Data

Total Results: 33 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.6.21	famitsu.com	7254.0	app.famitsu.com	2023-10-18 09:28:23.424863+00:00	2024-07-08 02:32:47.953000-07:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	do4a.me	32657.0	bc.do4a.me	2023-10-15 11:38:36.947324+00:00	2023-11-01 00:04:14.501965-07:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	kmutnb.ac.th	47124.0	kmutnb.ac.th	2024-06-03 10:59:40.060862+00:00	2024-06-03 01:33:23.426875-07:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	cheari.com	89446.0	cheari.com	2023-10-16 09:41:51.082152+00:00	2024-12-23 01:36:14.724833-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	301pt.com	96206.0	301pt.com	2023-10-15 09:41:30.298350+00:00	2024-12-07 02:17:00.036978-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	barunhosp.com	112293.0	barunhosp.com	2024-09-14 04:14:26.988125+00:00	2024-12-11 03:03:22.806479-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	nasze.fm	147124.0	nasze.fm	2023-10-15 15:03:08.276918+00:00	2024-12-12 04:35:52.158753-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	tigerfan.com	149303.0	tigerfan.com	2023-10-15 13:58:26.972649+00:00	2024-12-12 04:45:31.030975-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	hifiman.com	235438.0	hifiman.com	2023-10-16 10:12:45.223446+00:00	2024-12-13 04:18:06.385180-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	pskgu.ru	289402.0	pskgu.ru	2023-10-25 12:35:09.802712+00:00	2024-12-08 05:38:08.491952-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	primehouse.com.ua	332897.0	primehouse.com.ua	2023-10-16 14:25:05.310458+00:00	2024-06-07 13:01:54.445898-07:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	lastminutemusicians.com	338171.0	www.lastminutemusicians.com	2023-10-15 12:47:29.830299+00:00	2024-11-24 06:54:37.567372-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	shora-gc.ir	365676.0	www.shora-gc.ir	2023-10-15 14:31:43.480272+00:00	2023-12-04 05:24:44.765226-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	medical-cg.ru	412141.0	www.medical-cg.ru	2023-10-15 14:30:41.091828+00:00	2024-12-23 06:56:56.076214-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	csr.ir	535315.0	csr.ir	2023-10-15 16:47:45.498440+00:00	2023-10-28 07:44:16.005126-07:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	ref.org.uk	536248.0	ref.org.uk	2023-10-15 17:03:19.645673+00:00	2024-11-15 17:42:29.497990-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	zensoren.or.jp	594479.0	zensoren.or.jp	2023-10-15 18:01:39.133106+00:00	2024-12-03 13:46:09.827078-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	jscj.com	599919.0	jscj.com	2023-10-15 17:41:04.503223+00:00	2024-12-02 13:26:44.884693-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	cfsbcn.com	658660.0	cfsbcn.com	2023-10-15 19:50:49.050712+00:00	2024-02-17 11:50:25.743318-08:00	lower(http_request.response_headers) contains 'php/5.6.21'
Php/5.6.21	moldexpo.md	660670.0	moldexpo.md	2023-10-15 20:56:53.643201+00:00	2024-12-09 13:00:32.427672-08:00	lower(http_request.response_headers) contains 'php/5.6.21'