Input

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

Data

Total Results: 18 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Consisto	merano-suedtirol.it	53484.0	www.merano-suedtirol.it/de/schenna	2023-10-15 09:52:02.912877-07:00	2024-10-06 15:32:29.757370-07:00	lower(http_request.response_headers) contains 'consisto'
Consisto	seiseralm.it	119230.0	www.seiseralm.it/de/urlaub-in-den-dolomiten	2023-10-15 03:35:10.261412-07:00	2024-12-11 03:38:05.030556-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	vinschgau.net	205580.0	www.vinschgau.net/de/willkommen	2023-10-15 04:46:36.703612-07:00	2024-12-09 03:36:51.315238-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	bikehotels.it	270240.0	www.bikehotels.it/de/suedtirol	2023-10-15 14:13:18.605554-07:00	2024-12-12 06:55:17.920554-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	drei-zinnen.info	276876.0	www.drei-zinnen.info/de/dolomitenregion-3-zinnen	2023-10-15 05:02:12.112668-07:00	2024-12-12 07:21:46.857586-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	ahrntal.com	350981.0	www.ahrntal.com/de/urlaub-im-ahrntal	2023-10-16 04:52:14.774353-07:00	2024-12-23 05:30:46.749338-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	dreizinnen.com	391260.0	www.dreizinnen.com/de/skigebiet-drei-zinnen	2023-10-15 08:12:37.841376-07:00	2024-12-13 06:59:49.085081-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	caravanparksexten.it	420741.0	www.caravanparksexten.it/de/camping-suedtirol	2023-10-15 07:31:53.764535-07:00	2024-12-06 09:57:59.355969-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	venosta.net	507644.0	www.venosta.net/it/benvenuti	2023-10-15 10:24:23.754729-07:00	2024-10-03 16:11:53.839505-07:00	lower(http_request.response_headers) contains 'consisto'
Consisto	tre-cime.info	510607.0	www.tre-cime.info/it/zona-delle-3-cime	2023-10-15 09:04:30.300811-07:00	2024-12-11 11:49:03.404992-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	klausen.it	541923.0	www.klausen.it/de/urlaub-eisacktal	2023-10-15 11:04:51.871952-07:00	2024-12-12 13:11:14.964155-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	consistoire.org	559560.0	www.consistoire.org	2023-10-16 06:59:36.158277-07:00	2024-12-03 10:41:13.291472-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	tessmann.it	627700.0	www.tessmann.it/de/home	2023-10-15 10:14:08.353671-07:00	2024-12-03 15:26:38.969964-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	suedtirols-sueden.info	956820.0	www.suedtirols-sueden.info/de/urlaub	2023-10-15 14:38:17.296007-07:00	2024-03-13 14:09:18.510023-07:00	lower(http_request.response_headers) contains 'consisto'
Consisto	ratschings.info	NaN	www.ratschings.info/de/urlaub-in-ratschings	2023-10-15 15:14:51.631364-07:00	2024-02-18 17:06:34.689910-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	marlene.it	NaN	www.marlene.it/de/der-apfel-aus-suedtirol	2023-11-09 04:00:28.956572-08:00	2023-11-08 15:47:32.866122-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	consistoiredelyon.fr	NaN	www.consistoiredelyon.fr	2023-12-01 12:50:18.810738-08:00	2024-12-07 13:50:34.443262-08:00	lower(http_request.response_headers) contains 'consisto'
Consisto	sterzing-ratschings.com	NaN	www.sterzing-ratschings.com/de/entdecke-sterzing-ratschings	2023-10-15 13:42:27.177673-07:00	2024-08-30 18:33:20.932385-07:00	lower(http_request.response_headers) contains 'consisto'