Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"pawtucket-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	15
2	db.towns.find( {"sef_url":"pawtucket-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","pawtucket-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"a526014ae6ec4d91ff7eaccab9d12a0b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events_radius_cache.find( {"_id":"918d42f2af2b4d21447b4ee761d3e051"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
6	db.events.count( {"address.town_sef_url":"pawtucket-ri","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	2	3
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.37300109863281,41.87779998779297],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	26	30
8	db.events_radius_cache.count( {"_id":"918d42f2af2b4d21447b4ee761d3e051"} )	0	1
9	db.events_radius_cache.insert( {"_id":"918d42f2af2b4d21447b4ee761d3e051","radius":7,"modified":"MongoDate(0.68300000 1765865721)","created":"MongoDate(0.68300000 1765865721)"} , true)	0	2
10	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-71.37300109863281,41.87779998779297],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	124
11	db.events_cache.count( {"_id":"a526014ae6ec4d91ff7eaccab9d12a0b"} )	0	1
12	db.events_cache.count( {"_id":"a526014ae6ec4d91ff7eaccab9d12a0b"} )	0	1
13	db.events_cache.insert( {"_id":"a526014ae6ec4d91ff7eaccab9d12a0b","town_sef_url":"pawtucket-ri","data_key":["68a75b5d03a70639b6cf080b","69036add4389be6be5f5ef9c","68a75b5f03a70639b6cf0ecc","69036adf4389be6be5f5f9f2","68a75b6103a70639b6cf198e","69036adf4389be6be5f5fae8","693321024389be6be5653aa5","693321024389be6be5653b74","69036ae04389be6be5f5ff7d","69036ae04389be6be5f6022b","69036ae14389be6be5f6024b","69036ae14389be6be5f60363","69036ae14389be6be5f602d1","69036ae14389be6be5f605b0","69036ae24389be6be5f60936"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Pawtucket Featured Events\",\"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,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":41.87779998779297,\"lng\":-71.37300109863281,\"latlng\":\"41.877799987793,-71.373001098633\",\"city\":\"Pawtucket\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.83900000 1765865721)","created":"MongoDate(0.83900000 1765865721)"} , true)	0	1

Pawtucket

Rhode Island

Pawtucket Featured Events

Live Music - Matt Martin and the Daydrinkers

Bike Routes and wakelee

Live Music - Dan Lilley and The Keepers

Providence College Friars Mens Basketball vs. Seton Hall Pirates Mens Basketball

Paint with Us!

Cirque Dreams Holidaze

Riffmas Rager

Plight, Ghosts in the Snow, Goodall, Weatherman, & Galeer

Tragedy: A Metal Tribute to the Bee Gees

Hope International Market

Cultural Survival Bazaar

Holly Jolly Holiday Stroll Craft Fair

Cirque Dreams Holidaze

Cirque Dreams Holidaze

Providence Bruins vs. Syracuse Crunch

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.

Pawtucket Featured Events

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.