Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"new-haven-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"new-haven-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ct","new-haven-county-ct","new-haven-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"ab8ba9b6c681fe3b0774f64655f08a71"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
5	db.events_radius_cache.find( {"_id":"ae30326d72af3d871f96c4158b4bab4a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	7
6	db.events.count( {"address.town_sef_url":"new-haven-ct","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	4	10
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.93009948730469,41.310699462890625],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	4	26
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.93009948730469,41.310699462890625],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	7	21
9	db.events_radius_cache.count( {"_id":"ae30326d72af3d871f96c4158b4bab4a"} )	0	1
10	db.events_radius_cache.insert( {"_id":"ae30326d72af3d871f96c4158b4bab4a","radius":25,"modified":"MongoDate(0.81700000 1766564795)","created":"MongoDate(0.81700000 1766564795)"} , true)	0	1
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767333600)","$lt":"MongoDate(0.00000000 1767592799)"},"geo":{"$geoWithin":{"$center":[[-72.93009948730469,41.310699462890625],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 16 ).skip( 0 )	6	8
12	db.events_cache.count( {"_id":"ab8ba9b6c681fe3b0774f64655f08a71"} )	0	1
13	db.events_cache.count( {"_id":"ab8ba9b6c681fe3b0774f64655f08a71"} )	0	1
14	db.events_cache.insert( {"_id":"ab8ba9b6c681fe3b0774f64655f08a71","town_sef_url":"new-haven-ct","data_key":["69036aec4389be6be5f63f30","69036aec4389be6be5f64063","69036aed4389be6be5f64403","69036aed4389be6be5f6448b","69036aed4389be6be5f6453a","69036aee4389be6be5f64994"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"title\":\"{local_city} Events for 1\\\/2\\\/2026 to 1\\\/4\\\/2026\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2026-01-02\",\"searchenddate\":\"2026-01-04\",\"lat\":41.310699462890625,\"lng\":-72.93009948730469,\"latlng\":\"41.310699462891,-72.930099487305\",\"city\":\"New Haven\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.84300000 1766564795)","created":"MongoDate(0.84300000 1766564795)"} , true)	0	1

New Haven

Connecticut

New Haven Events for 1/2/2026 to 1/4/2026

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Quinnipiac Bobcats Mens Ice Hockey vs. Harvard Crimson Hockey

Sacred Heart Pioneers Women's Basketball vs. Canisius University Women's Basketball

Bridgeport Islanders v. Hartford Wolf Pack

Quinnipiac Bobcats Mens Ice Hockey vs. Dartmouth Big Green Hockey

WWE Live Holiday Tour

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

New Haven Events for 1/2/2026 to 1/4/2026

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.