Input

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

Data

Total Results: 23 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Smugmug	smugmug.com	973.0	www.smugmug.com	2023-10-15 03:37:20.214205-07:00	2024-12-13 00:17:38.541613-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	lasvegasnevada.gov	15766.0	www.lasvegasnevada.gov	2023-10-16 01:29:45.222754-07:00	2024-12-14 00:15:56.543625-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	beaumont.org	26050.0	www.beaumont.org	2023-10-15 13:08:07.948674-07:00	2024-12-23 00:36:37.105107-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	financialexecutives.org	66739.0	www.financialexecutives.org	2023-10-15 02:41:24.852886-07:00	2024-12-23 01:16:24.100309-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	nmc.edu	80065.0	www.nmc.edu	2023-10-15 02:41:27.845959-07:00	2024-12-23 01:04:34.959961-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	beaumont.edu	135769.0	www.beaumont.edu	2023-10-15 04:20:05.411952-07:00	2024-12-12 04:17:33.218473-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	plsa.co.uk	239673.0	www.plsa.co.uk	2023-10-15 05:13:19.426909-07:00	2024-12-13 04:36:03.931293-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	vonwong.com	241838.0	www.vonwong.com	2023-10-15 04:46:55.144783-07:00	2024-12-11 05:38:16.878156-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	kulturbanause.de	326569.0	kulturbanause.de	2023-10-15 05:48:58.677213-07:00	2024-12-11 07:28:27.062895-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	vitalykuzmin.net	328537.0	www.vitalykuzmin.net	2023-10-15 06:38:12.966847-07:00	2024-06-07 12:40:35.740472-07:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	formulastudent.de	340755.0	www.formulastudent.de/fsg	2023-10-15 05:47:51.258628-07:00	2024-12-11 07:33:47.699714-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	sharkbayte.com	344673.0	www.sharkbayte.com	2023-10-16 02:20:20.543707-07:00	2024-12-11 07:56:46.306632-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	chrisburkard.com	407497.0	www.chrisburkard.com	2023-10-15 07:23:02.547656-07:00	2024-12-10 08:44:25.771917-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	mattconti.com	454684.0	www.mattconti.com/galleries/united-states/boston	2023-10-15 07:50:29.212393-07:00	2024-12-08 09:40:20.363287-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	bouvet.no	460023.0	www.bouvet.no	2023-10-15 08:58:29.963061-07:00	2024-12-06 11:09:01.771540-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	alexanderwild.com	499582.0	www.alexanderwild.com	2023-10-15 07:23:52.687345-07:00	2024-12-03 10:31:09.686988-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	dennosmuseum.org	555906.0	www.dennosmuseum.org	2023-10-15 11:21:14.579850-07:00	2023-11-02 07:44:59.758710-07:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	spielbudenplatz.eu	579469.0	spielbudenplatz.eu	2023-11-05 12:51:24.014311-08:00	2024-12-03 13:14:30.027854-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	apollosaturn.com	634283.0	www.apollosaturn.com	2023-10-15 11:58:16.023150-07:00	2024-12-13 11:57:53.444197-08:00	lower(http_request.response_headers) contains 'smugmug'
Smugmug	freelyphotos.com	708302.0	www.freelyphotos.com	2023-10-15 11:46:09.304893-07:00	2024-12-03 15:48:42.033598-08:00	lower(http_request.response_headers) contains 'smugmug'