Input

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

Data

Total Results: 352 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Django	rte.ie	1954.0	www.rte.ie	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:27:32.353184-08:00	lower(http_request.response_headers) contains 'django'
Django	djangoproject.com	2327.0	www.djangoproject.com	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:20:28.567367-08:00	lower(http_request.response_headers) contains 'django'
Django	cmegroup.com	3599.0	www.cmegroup.com/tools-information	2023-10-15 03:32:51.796867-07:00	2023-10-30 01:13:13.510324-07:00	lower(http_request.response_headers) contains 'django'
Django	pokemon.com	4102.0	www.pokemon.com	2023-11-18 09:11:56.627358-08:00	2024-12-13 00:34:15.571499-08:00	lower(http_request.response_headers) contains 'django'
Django	samaritans.org	4733.0	www.samaritans.org	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:28:57.135941-08:00	lower(http_request.response_headers) contains 'django'
Django	bmo.com	6563.0	capitalmarkets.bmo.com/en	2023-10-15 05:48:39.564392-07:00	2024-11-24 07:08:17.537693-08:00	lower(http_request.response_headers) contains 'django'
Django	top500.org	7532.0	top500.org	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:48:20.955031-08:00	lower(http_request.response_headers) contains 'django'
Django	globalwitness.org	8289.0	www.globalwitness.org/en	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:39:35.837218-08:00	lower(http_request.response_headers) contains 'django'
Django	erudit.org	10066.0	www.erudit.org/fr	2023-10-16 02:40:08.514688-07:00	2024-12-14 00:04:13.369202-08:00	lower(http_request.response_headers) contains 'django'
Django	blogsky.com	10753.0	www.blogsky.com	2023-10-16 02:24:31.826640-07:00	2024-12-14 00:01:43.074995-08:00	lower(http_request.response_headers) contains 'django'
Django	okfn.org	15189.0	okfn.org/en	2023-10-16 02:41:32.700533-07:00	2024-12-14 00:14:49.876023-08:00	lower(http_request.response_headers) contains 'django'
Django	appsumo.com	16111.0	appsumo.com	2023-10-16 02:41:32.700533-07:00	2024-12-14 00:17:51.930572-08:00	lower(http_request.response_headers) contains 'django'
Django	lwl.org	16947.0	www2.lwl.org/de/lwl/portal	2023-10-16 02:40:08.514688-07:00	2024-12-14 00:24:39.481858-08:00	lower(http_request.response_headers) contains 'django'
Django	simonwillison.net	17020.0	simonwillison.net	2024-09-27 01:21:26.072944-07:00	2024-12-14 00:18:13.987130-08:00	lower(http_request.response_headers) contains 'django'
Django	petrobras.com.br	17616.0	agencia.petrobras.com.br/pt	2023-10-21 08:03:15.273702-07:00	2024-01-21 04:17:14.040181-08:00	lower(http_request.response_headers) contains 'django'
Django	portaldaindustria.com.br	21614.0	www.portaldaindustria.com.br/sesi	2023-10-15 07:23:19.436075-07:00	2024-09-01 09:53:29.310450-07:00	lower(http_request.response_headers) contains 'django'
Django	kexp.org	22391.0	kexp.org	2023-10-21 04:43:51.899400-07:00	2024-12-23 00:30:06.256908-08:00	lower(http_request.response_headers) contains 'django'
Django	memo.ru	23262.0	www.memo.ru/ru-ru	2023-10-16 01:29:45.222754-07:00	2024-12-23 00:33:43.884450-08:00	lower(http_request.response_headers) contains 'django'
Django	dandad.org	24159.0	www.dandad.org	2023-10-16 01:45:00.280449-07:00	2024-12-23 00:38:04.713888-08:00	lower(http_request.response_headers) contains 'django'
Django	fun-mooc.fr	25071.0	www.fun-mooc.fr/fr	2023-10-15 05:13:19.426909-07:00	2024-12-23 00:41:17.061158-08:00	lower(http_request.response_headers) contains 'django'