Input

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

Data

Total Results: 41 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Iransamaneh-1.7.0-s1	yjc.ir	37247.0	www.yjc.ir	2023-10-16 02:12:51.151783-07:00	2024-12-12 02:06:26.762148-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	tabnak.ir	37249.0	www.tabnak.ir	2023-10-16 02:10:05.102012-07:00	2024-12-12 02:06:33.047277-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	asriran.com	37351.0	www.asriran.com	2023-10-16 02:10:05.102012-07:00	2024-12-12 02:07:49.026685-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	entekhab.ir	67660.0	www.entekhab.ir	2023-11-01 03:53:35.125967-07:00	2024-12-23 01:15:13.267534-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	jamejamonline.ir	68272.0	jamejamonline.ir	2023-10-15 02:41:22.676770-07:00	2024-12-23 01:19:56.164630-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	eghtesadonline.com	71727.0	www.eghtesadonline.com	2024-08-19 18:04:18.917422-07:00	2024-12-13 01:39:27.868146-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	aftabnews.ir	75546.0	aftabnews.ir	2023-10-15 03:17:07.063370-07:00	2024-12-13 01:49:12.996944-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	fararu.com	77280.0	fararu.com	2023-10-15 03:28:22.643572-07:00	2024-12-13 01:50:31.862440-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	borna.news	80842.0	borna.news	2023-10-15 03:17:13.879097-07:00	2024-12-23 01:10:06.516478-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	snn.ir	92465.0	snn.ir	2023-10-15 03:35:10.261412-07:00	2024-12-07 02:11:08.250048-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	mizanonline.ir	109877.0	www.mizanonline.ir	2023-10-15 05:41:15.779695-07:00	2024-12-23 04:35:28.354173-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	ettelaat.com	130480.0	ettelaat.com	2023-10-15 04:34:58.973905-07:00	2024-07-03 16:24:04.171749-07:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	javanonline.ir	136425.0	www.javanonline.ir	2023-10-15 04:22:05.050003-07:00	2024-12-12 04:21:27.010956-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	ana.ir	153600.0	ana.ir	2023-11-20 19:13:45.320536-08:00	2024-12-06 03:40:49.645192-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	parsine.com	168511.0	www.parsine.com	2023-10-15 04:34:58.973905-07:00	2023-12-24 04:20:17.022749-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	ana.press	195357.0	ana.press	2023-10-15 03:36:47.149600-07:00	2023-11-18 02:45:33.739629-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	bultannews.com	226954.0	www.bultannews.com	2023-10-15 05:13:14.891811-07:00	2024-12-05 03:49:27.374120-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	defapress.ir	305444.0	defapress.ir	2023-10-15 06:38:19.167895-07:00	2024-12-09 05:34:09.643062-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	rouydad24.ir	312580.0	www.rouydad24.ir	2023-10-15 05:48:11.034817-07:00	2024-12-23 05:04:38.595486-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'
Iransamaneh-1.7.0-s1	noandish.com	368117.0	noandish.com	2024-02-11 20:04:53.171945-08:00	2024-12-13 07:02:20.364236-08:00	lower(http_request.response_headers) contains 'iransamaneh-1.7.0-s1'