Skip to content

Instantly share code, notes, and snippets.

@silvestrelosada

silvestrelosada/postgress log

Created October 30, 2014 08:51
Show Gist options
  • Save silvestrelosada/190097e7830b9bc88c99 to your computer and use it in GitHub Desktop.
Save silvestrelosada/190097e7830b9bc88c99 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgress log
2014-10-30 08:46:16 UTC LOG: duration: 219.276 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130295926 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:16 UTC LOG: duration: 3.326 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130297410 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 3.059 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130342072 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.213 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 126779856 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.170 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 493127 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.228 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130315655 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.204 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130303897 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.164 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 491211 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.163 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 428730 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.163 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 436359 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.162 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 24943107 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.161 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 12078548 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.160 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 11978799 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.160 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 12064292 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.194 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 60361340 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.195 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130268428 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:17 UTC LOG: duration: 0.376 ms statement: select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
2014-10-30 08:46:17 UTC LOG: duration: 0.289 ms statement: update query_log set endtime = '2014-10-30 08:46:17.0132', results = 10 where starttime = '2014-10-30 08:42:26.8439' and ipaddress = '81.172.17.98' and query = 'madrid'
2014-10-30 08:46:17 UTC LOG: duration: 0.243 ms statement: update new_query_log set endtime = '2014-10-30 08:46:17.0132', results = 10 where starttime = '2014-10-30 08:42:26.8439' and ipaddress = '81.172.17.98' and query = 'q=madrid&viewbox=-163.57%2C63.04%2C163.57%2C-63.04'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment