Created
October 30, 2014 09:00
-
-
Save silvestrelosada/4239af395e7dae1dff73 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2014-10-24 16:08:56 UTC LOG: received fast shutdown request | |
| 2014-10-24 16:08:56 UTC LOG: aborting any active transactions | |
| 2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command | |
| 2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command | |
| 2014-10-24 16:08:56 UTC LOG: autovacuum launcher shutting down | |
| 2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command | |
| 2014-10-24 16:08:56 UTC CONTEXT: SQL statement "update placex set indexed_status = 2 where parent_place_id = OLD.place_id and indexed_status = 0" | |
| PL/pgSQL function placex_delete() line 27 at SQL statement | |
| SQL statement "delete from placex where place_id = OLD.place_id" | |
| PL/pgSQL function placex_update() line 50 at SQL statement | |
| 2014-10-24 16:08:56 UTC STATEMENT: update placex set indexed_status = 0 where place_id = $1 | |
| 2014-10-24 16:08:56 UTC LOG: shutting down | |
| 2014-10-24 16:08:56 UTC LOG: database system is shut down | |
| 2014-10-29 11:50:37 UTC LOG: database system was shut down at 2014-10-24 16:08:56 UTC | |
| 2014-10-29 11:50:37 UTC LOG: database system is ready to accept connections | |
| 2014-10-29 11:50:37 UTC LOG: autovacuum launcher started | |
| 2014-10-29 11:50:37 UTC LOG: incomplete startup packet | |
| 2014-10-29 12:12:24 UTC LOG: received fast shutdown request | |
| 2014-10-29 12:12:24 UTC LOG: aborting any active transactions | |
| 2014-10-29 12:12:24 UTC LOG: autovacuum launcher shutting down | |
| 2014-10-29 12:12:24 UTC LOG: shutting down | |
| 2014-10-29 12:12:24 UTC LOG: database system is shut down | |
| 2014-10-29 12:13:03 UTC LOG: database system was shut down at 2014-10-29 12:12:24 UTC | |
| 2014-10-29 12:13:03 UTC LOG: autovacuum launcher started | |
| 2014-10-29 12:13:03 UTC LOG: database system is ready to accept connections | |
| 2014-10-29 12:13:03 UTC LOG: incomplete startup packet | |
| 2014-10-29 13:43:15 UTC LOG: received fast shutdown request | |
| 2014-10-29 13:43:15 UTC LOG: aborting any active transactions | |
| 2014-10-29 13:43:15 UTC LOG: autovacuum launcher shutting down | |
| 2014-10-29 13:43:15 UTC LOG: shutting down | |
| 2014-10-29 13:43:15 UTC LOG: database system is shut down | |
| 2014-10-29 13:48:20 UTC LOG: database system was shut down at 2014-10-29 13:43:15 UTC | |
| 2014-10-29 13:48:20 UTC LOG: autovacuum launcher started | |
| 2014-10-29 13:48:20 UTC LOG: database system is ready to accept connections | |
| 2014-10-29 13:48:20 UTC LOG: incomplete startup packet | |
| 2014-10-29 13:53:32 UTC LOG: received fast shutdown request | |
| 2014-10-29 13:53:32 UTC LOG: aborting any active transactions | |
| 2014-10-29 13:53:32 UTC LOG: autovacuum launcher shutting down | |
| 2014-10-29 13:53:32 UTC LOG: shutting down | |
| 2014-10-29 13:53:32 UTC LOG: database system is shut down | |
| 2014-10-30 07:58:13 UTC LOG: database system was shut down at 2014-10-29 13:53:32 UTC | |
| 2014-10-30 07:58:13 UTC LOG: incomplete startup packet | |
| 2014-10-30 07:58:13 UTC FATAL: the database system is starting up | |
| 2014-10-30 07:58:14 UTC LOG: database system is ready to accept connections | |
| 2014-10-30 07:58:14 UTC LOG: autovacuum launcher started | |
| 2014-10-30 08:19:28 UTC LOG: received fast shutdown request | |
| 2014-10-30 08:19:28 UTC LOG: aborting any active transactions | |
| 2014-10-30 08:19:28 UTC LOG: autovacuum launcher shutting down | |
| 2014-10-30 08:19:28 UTC LOG: shutting down | |
| 2014-10-30 08:19:28 UTC LOG: database system is shut down | |
| 2014-10-30 08:33:31 UTC LOG: database system was shut down at 2014-10-30 08:19:28 UTC | |
| 2014-10-30 08:33:31 UTC LOG: database system is ready to accept connections | |
| 2014-10-30 08:33:31 UTC LOG: autovacuum launcher started | |
| 2014-10-30 08:33:31 UTC LOG: incomplete startup packet | |
| 2014-10-30 08:33:32 UTC LOG: duration: 21.919 ms statement: SELECT d.datname as "Name", | |
| pg_catalog.pg_get_userbyid(d.datdba) as "Owner", | |
| pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", | |
| d.datcollate as "Collate", | |
| d.datctype as "Ctype", | |
| pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" | |
| FROM pg_catalog.pg_database d | |
| ORDER BY 1; | |
| 2014-10-30 08:33:32 UTC LOG: duration: 0.991 ms statement: SELECT d.datname as "Name", | |
| pg_catalog.pg_get_userbyid(d.datdba) as "Owner", | |
| pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", | |
| d.datcollate as "Collate", | |
| d.datctype as "Ctype", | |
| pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" | |
| FROM pg_catalog.pg_database d | |
| ORDER BY 1; | |
| 2014-10-30 08:33:33 UTC LOG: duration: 1.052 ms statement: SELECT d.datname as "Name", | |
| pg_catalog.pg_get_userbyid(d.datdba) as "Owner", | |
| pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", | |
| d.datcollate as "Collate", | |
| d.datctype as "Ctype", | |
| pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" | |
| FROM pg_catalog.pg_database d | |
| ORDER BY 1; | |
| 2014-10-30 08:42:21 UTC LOG: duration: 0.113 ms statement: SET DateStyle TO 'sql,european' | |
| 2014-10-30 08:42:21 UTC LOG: duration: 0.023 ms statement: SET client_encoding TO 'utf-8' | |
| 2014-10-30 08:42:22 UTC LOG: duration: 386.991 ms statement: insert into query_log values ('2014-10-30 08:42:21.9294','','81.172.17.98') | |
| 2014-10-30 08:42:22 UTC LOG: duration: 262.037 ms statement: insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2014-10-30 08:42:21.9294','','81.172.17.98','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.104 Safari/537.36','short_name:en-US,short_name:en,short_name:es,short_name:en-GB,short_name:nl,name:en-US,name:en,name:es,name:en-GB,name:nl,place_name:en-US,place_name:en,place_name:es,place_name:en-GB,place_name:nl,official_name:en-US,official_name:en,official_name:es,official_name:en-GB,official_name:nl,short_name,name,place_name,official_name,ref,type','') | |
| 2014-10-30 08:42:22 UTC LOG: duration: 13.413 ms statement: select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1 | |
| 2014-10-30 08:42:22 UTC LOG: duration: 152.482 ms statement: update query_log set endtime = '2014-10-30 08:42:22.6078', results = 0 where starttime = '2014-10-30 08:42:21.9294' and ipaddress = '81.172.17.98' and query = '' | |
| 2014-10-30 08:42:22 UTC LOG: duration: 1.097 ms statement: update new_query_log set endtime = '2014-10-30 08:42:22.6078', results = 0 where starttime = '2014-10-30 08:42:21.9294' and ipaddress = '81.172.17.98' and query = '' | |
| 2014-10-30 08:42:26 UTC LOG: duration: 0.112 ms statement: SET DateStyle TO 'sql,european' | |
| 2014-10-30 08:42:26 UTC LOG: duration: 0.023 ms statement: SET client_encoding TO 'utf-8' | |
| 2014-10-30 08:42:26 UTC LOG: duration: 0.484 ms statement: insert into query_log values ('2014-10-30 08:42:26.8439','madrid','81.172.17.98') | |
| 2014-10-30 08:42:26 UTC LOG: duration: 0.207 ms statement: insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2014-10-30 08:42:26.8439','q=madrid&viewbox=-163.57%2C63.04%2C163.57%2C-63.04','81.172.17.98','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.104 Safari/537.36','short_name:en-US,short_name:en,short_name:es,short_name:en-GB,short_name:nl,name:en-US,name:en,name:es,name:en-GB,name:nl,place_name:en-US,place_name:en,place_name:es,place_name:en-GB,place_name:nl,official_name:en-US,official_name:en,official_name:es,official_name:en-GB,official_name:nl,short_name,name,place_name,official_name,ref,type','') | |
| 2014-10-30 08:42:26 UTC LOG: duration: 125.066 ms statement: select make_standard_name('madrid') as string | |
| 2014-10-30 08:42:28 UTC LOG: duration: 2021.372 ms statement: select word_id,word_token, word, class, type, country_code, operator, search_name_count from word where word_token in (' madrid','madrid') | |
| 2014-10-30 08:45:39 UTC LOG: duration: 190029.364 ms statement: select place_id, 0::int as exactmatch from search_name where name_vector @> ARRAY[4122727] order by (case when importance = 0 OR importance IS NULL then 0.75-(search_rank::float/40) else importance end) * case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-163.57,-63.04),ST_Point(163.57,63.04)),4326), centroid) THEN 1 ELSE 0.5 END * case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-490.71,-189.12),ST_Point(490.71,189.12)),4326), centroid) THEN 1 ELSE 0.5 END DESC limit 20 | |
| 2014-10-30 08:46:16 UTC LOG: duration: 37750.285 ms statement: select osm_type,osm_id,class,type,admin_level,rank_search,rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id, calculated_country_code as country_code,get_address_by_language(place_id, ARRAY['short_name:en-US','short_name:en','short_name:es','short_name:en-GB','short_name:nl','name:en-US','name:en','name:es','name:en-GB','name:nl','place_name:en-US','place_name:en','place_name:es','place_name:en-GB','place_name:nl','official_name:en-US','official_name:en','official_name:es','official_name:en-GB','official_name:nl','short_name','name','place_name','official_name','ref','type']) as langaddress,get_name_by_language(name, ARRAY['short_name:en-US','short_name:en','short_name:es','short_name:en-GB','short_name:nl','name:en-US','name:en','name:es','name:en-GB','name:nl','place_name:en-US','place_name:en','place_name:es','place_name:en-GB','place_name:nl','official_name:en-US','official_name:en','official_name:es','official_name:en-GB','official_name:nl','short_name','name','place_name','official_name','ref','type']) as placename,get_name_by_language(name, ARRAY['ref']) as ref,avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-163.57,-63.04),ST_Point(163.57,63.04)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-490.71,-189.12),ST_Point(490.71,189.12)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * coalesce(importance,0.75-(rank_search::float/40)) as importance, (select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(CASE WHEN placex.rank_search < 28 THEN placex.place_id ELSE placex.parent_place_id END) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, (extratags->'place') as extra_place from placex where place_id in (113182,130295926,130342072,130297410,126779856,493127,130315655,130303897,436359,428730,491211,12078548,11978799,12064292,24943107,60361340,130268428) and (placex.rank_address between 0 and 30 OR (extratags->'place') = 'city') and linked_place_id is null group by osm_type,osm_id,class,type,admin_level,rank_search,rank_address,calculated_country_code,importance,langaddress ,placename ,ref ,extratags->'place' union select 'T' as osm_type,place_id as osm_id,'place' as class,'house' as type,null as admin_level,30 as rank_search,30 as rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id,'us' as country_code,get_address_by_language(place_id, ARRAY['short_name:en-US','short_name:en','short_name:es','short_name:en-GB','short_name:nl','name:en-US','name:en','name:es','name:en-GB','name:nl','place_name:en-US','place_name:en','place_name:es','place_name:en-GB','place_name:nl','official_name:en-US','official_name:en','official_name:es','official_name:en-GB','official_name:nl','short_name','name','place_name','official_name','ref','type']) as langaddress,null as placename,null as ref,avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-163.57,-63.04),ST_Point(163.57,63.04)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-490.71,-189.12),ST_Point(490.71,189.12)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * -1.15 as importance, (select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(location_property_tiger.parent_place_id) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, null as extra_place from location_property_tiger where place_id in (113182,130295926,130342072,130297410,126779856,493127,130315655,130303897,436359,428730,491211,12078548,11978799,12064292,24943107,60361340,130268428) and 30 between 0 and 30 group by place_id union select 'L' as osm_type,place_id as osm_id,'place' as class,'house' as type,null as admin_level,30 as rank_search,30 as rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id,'us' as country_code,get_address_by_language(place_id, ARRAY['short_name:en-US','short_name:en','short_name:es','short_name:en-GB','short_name:nl','name:en-US','name:en','name:es','name:en-GB','name:nl','place_name:en-US','place_name:en','place_name:es','place_name:en-GB','place_name:nl','official_name:en-US','official_name:en','official_name:es','official_name:en-GB','official_name:nl','short_name','name','place_name','official_name','ref','type']) as langaddress,null as placename,null as ref,avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-163.57,-63.04),ST_Point(163.57,63.04)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * case when ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-490.71,-189.12),ST_Point(490.71,189.12)),4326), ST_Collect(centroid)) THEN 1 ELSE 0.75 END * -1.10 as importance, (select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(location_property_aux.parent_place_id) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, null as extra_place from location_property_aux where place_id in (113182,130295926,130342072,130297410,126779856,493127,130315655,130303897,436359,428730,491211,12078548,11978799,12064292,24943107,60361340,130268428) and 30 between 0 and 30 group by place_id,get_address_by_language(place_id, ARRAY['short_name:en-US','short_name:en','short_name:es','short_name:en-GB','short_name:nl','name:en-US','name:en','name:es','name:en-GB','name:nl','place_name:en-US','place_name:en','place_name:es','place_name:en-GB','place_name:nl','official_name:en-US','official_name:en','official_name:es','official_name:en-GB','official_name:nl','short_name','name','place_name','official_name','ref','type']) order by importance desc | |
| 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