Sample nodetiles queries

gistfile1.sql

-- Make sure indexes are set up
CREATE INDEX responses_the_geom_gist ON responses USING GIST (the_geom);
vacuum analyze responses;

-- Set on or off to test if the sequential scan is faster
SET ENABLE_SEQSCAN=OFF;

-- Wider query
EXPLAIN ANALYZE SELECT ST_AsGeoJson(the_geom) as geometry,* FROM responses WHERE the_geom && ST_MakeEnvelope(-83.18847656250001,42.39100860920504, -82.92480468750001,42.585444257384886); 

-- Closer query 
EXPLAIN ANALYZE SELECT ST_AsGeoJson(the_geom) as geometry,* FROM responses WHERE the_geom && ST_MakeEnvelope(-83.02436828613283,42.4351133853526, -83.02024841308594,42.438153950765916);