Input

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

Data

Total Results: 732 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Dreampress	childhelp.org	15963.0	www.childhelp.org	2023-10-15 16:52:02.912877+00:00	2023-10-31 07:29:09.896827+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	weburbanist.com	17813.0	weburbanist.com	2023-10-21 11:12:18.420035+00:00	2023-10-28 07:35:23.948177+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	startupnation.com	27116.0	startupnation.com	2023-10-16 08:13:44.105098+00:00	2023-10-19 07:15:40.865007+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	nationalhomeless.org	28279.0	nationalhomeless.org	2023-10-16 08:29:45.222754+00:00	2023-10-24 07:27:54.947105+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	gearboxsoftware.com	28841.0	www.gearboxsoftware.com	2023-10-16 08:45:00.280449+00:00	2023-10-30 07:19:05.187958+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	electronicsforu.com	34310.0	www.electronicsforu.com/category/news	2023-10-15 11:20:05.411952+00:00	2023-10-29 08:54:12.187711+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	linuxlinks.com	34315.0	www.linuxlinks.com	2023-10-16 08:52:22.919205+00:00	2023-10-24 07:14:02.575622+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	suicidology.org	36049.0	suicidology.org	2023-10-16 08:52:22.919205+00:00	2023-10-26 07:14:56.715926+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	blueoceanstrategy.com	38247.0	www.blueoceanstrategy.com	2023-10-16 08:56:02.570067+00:00	2023-10-18 07:18:28.774341+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	boxesandarrows.com	38774.0	boxesandarrows.com	2023-10-16 08:56:02.570067+00:00	2023-10-31 07:28:27.841180+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	almaobservatory.org	38802.0	www.almaobservatory.org/en/home	2023-10-16 09:10:05.102012+00:00	2023-10-30 07:12:17.868773+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	synthtopia.com	41657.0	www.synthtopia.com	2023-10-16 08:52:22.919205+00:00	2023-10-31 07:14:37.871218+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	cogconnected.com	45174.0	cogconnected.com	2023-10-16 09:10:05.102012+00:00	2023-10-30 07:16:56.394029+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	suasnews.com	45286.0	www.suasnews.com	2023-10-16 09:12:51.151783+00:00	2023-10-31 07:16:31.242392+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	icrisat.org	46091.0	www.icrisat.org	2023-10-16 09:15:30.711992+00:00	2023-10-31 07:18:07.140934+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	nsula.edu	46249.0	www.nsula.edu	2023-10-16 08:56:02.570067+00:00	2023-10-30 07:37:21.873516+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	petpartners.org	46816.0	petpartners.org	2023-10-15 12:00:50.350349+00:00	2023-10-24 09:56:23.579734+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	homesnacks.com	46895.0	www.homesnacks.com	2023-10-16 08:52:22.919205+00:00	2023-10-27 09:22:10.748690+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	lightspeedmagazine.com	51307.0	www.lightspeedmagazine.com	2023-10-15 09:41:31.500275+00:00	2023-10-18 07:47:50.839878+00:00	lower(http_request.response_headers) contains 'dreampress'
Dreampress	nesslabs.com	51356.0	nesslabs.com	2023-10-15 09:42:48.582217+00:00	2023-10-26 07:34:27.546186+00:00	lower(http_request.response_headers) contains 'dreampress'