1.) you have several statement, which one is taking too much time? 2.) you don't give enough information ( http://wiki.postgresql.org/wiki/Slow_Query_Questions) 3.) If you need "progress percent", http://dba.stackexchange.com/questions/50602/how-do-i-find-out-how-far-along-my-postgresql-query-is
Cheers, Rémi-C Cheers, Rémi-C 2014-05-08 9:12 GMT+02:00 J.Alejandro Martinez Linares < [email protected]>: > 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/ > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
