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

[Rémi Cura]

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 <
islanis at infomed.sld.cu>:

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140420/59eaa1de/attachment.html>