[postgis-users] Query with LONG execution TIME, need to know the progress status of my query

J.Alejandro Martinez Linares islanis at infomed.sld.cu
Sat Apr 19 11:35:03 PDT 2014


Hi people, i am executing a query that contain st_contains function of 
postgis, but y am 3 days executing this query, and it is dont done, i 
need help to obtain the progress percent of how much time it will be in 
that status, or a similar solution, thanks to all.


CREATE TABLE sigfre_cub_Adm_Asentam_intersec
AS (SELECT
   a.codigo,
   a.nombre,
   a.cod_munic,
   a.viviendas,
   a.poblacion,
   a.categoria,
   a.tipo,
ST_Intersection(a.the_geom, b.the_geom) as the_geom
FROM "sigfre_cub_Adm_Asentam" as a, mapa_base_disolver as b
WHERE
ST_Intersects(a.the_geom, b.the_geom));
UPDATE sigfre_cub_Adm_Asentam_intersec SET 
the_geom=ST_SetSRID(the_geom,4326);
SELECT 
Populate_Geometry_Columns('public.sigfre_cub_Adm_Asentam_intersec'::regclass);
ALTER TABLE sigfre_cub_Adm_Asentam_intersec ADD column gid serial;
ALTER TABLE sigfre_cub_Adm_Asentam_intersec ADD PRIMARY KEY (gid);

--

Este mensaje le ha llegado mediante el servicio de correo electronico que ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema Nacional de Salud. La persona que envia este correo asume el compromiso de usar el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/



More information about the postgis-users mailing list