Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"roseville-mn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"roseville-mn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","mn","ramsey-county-mn","roseville-mn"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"a260e51294a1bf3805d8082eb2712531"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"ba2f6b73fd84bf797875bc62f5f59582"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"roseville-mn","start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767592800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.18119812011719,44.99489974975586],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	52	21
8	db.events_radius_cache.count( {"_id":"ba2f6b73fd84bf797875bc62f5f59582"} )	0	1
9	db.events_radius_cache.insert( {"_id":"ba2f6b73fd84bf797875bc62f5f59582","radius":7,"modified":"MongoDate(0.69300000 1767053765)","created":"MongoDate(0.69300000 1767053765)"} , true)	0	2
10	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767333600)","$lt":"MongoDate(0.00000000 1767592799)"},"geo":{"$geoWithin":{"$center":[[-93.18119812011719,44.99489974975586],0.10144927536231885]}}}, ["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 )	16	10
11	db.events_cache.count( {"_id":"a260e51294a1bf3805d8082eb2712531"} )	0	1
12	db.events_cache.count( {"_id":"a260e51294a1bf3805d8082eb2712531"} )	0	1
13	db.events_cache.insert( {"_id":"a260e51294a1bf3805d8082eb2712531","town_sef_url":"roseville-mn","data_key":["68a75b6e03a70639b6cf6b40","69036aec4389be6be5f63f5e","69036aec4389be6be5f63f84","68a75b6e03a70639b6cf6c56","69036aec4389be6be5f63fbc","69036aec4389be6be5f63fd1","68a75b6e03a70639b6cf6d19","69036aec4389be6be5f64163","69036aec4389be6be5f6416c","69036aec4389be6be5f641d1","68a75b6f03a70639b6cf6e49","68a75b6f03a70639b6cf6f33","68a75b6f03a70639b6cf6fee","69036aed4389be6be5f64484","693321094389be6be5656591"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"this-weekend\",\"keyword\":\"\",\"radius\":7,\"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\":44.99489974975586,\"lng\":-93.18119812011719,\"latlng\":\"44.994899749756,-93.181198120117\",\"city\":\"Roseville\",\"state\":\"MN\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.72500000 1767053765)","created":"MongoDate(0.72500000 1767053765)"} , true)	0	2

Roseville

Minnesota

Roseville Events for 1/2/2026 to 1/4/2026

St. Thomas Tommies Hockey vs. Ferris State Bulldogs Hockey

IIHF World Junior Hockey Championship

2026 IIHF World Junior Championship Quarterfinal 1

How the Grinch Stole Christmas

IIHF World Junior Hockey Championship

2026 IIHF World Junior Championship Quarterfinal 3

How the Grinch Stole Christmas

The Chaos of the Bells

IIHF World Junior Hockey Championship

Karl Denson’s Tiny Universe

St. Thomas Tommies Hockey vs. Ferris State Bulldogs Hockey

How the Grinch Stole Christmas

How the Grinch Stole Christmas

The Chaos of the Bells

Vin and andthecanaryfell.

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.

Roseville 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.