Pessoal, tenho uma aplicação desenvolvida em Genexus na linguagem Java. Ocorre que se eu verificar as querys que estão executando por meio da view pg_stat_activity existem várias querys com essa situação? O que seria isso exatamente? Algumas ficam às vezes horas executando. Tenho estranhado porque em sistemas desenvolvidos internamente e em outro que controla o nosso proxy isso nunca ocorreu. O que isso significa? Algo preocupante? Onde acho material técnico sobre isso?
datid | datname | procpid | usesysid | usename | current_query | query_start | backend_start | client_addr | client_port ------------+-----------+---------+----------+-----------+-----------------------+-------------------------------+-------------------------------+--------------+------------- 986218045 | protocolo | 22175 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:36.932242-03 | 2008-04-01 15:14:06.635605-03| 172.16.0.121 | 52661 986218045 | protocolo | 18416 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:18:17.999633-03 | 2008-04-01 09:10:16.397198-03| 172.16.0.122 | 42205 986218045 | protocolo | 19787 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:15:34.986614-03 | 2008-04-01 11:10:15.923526-03| 172.16.0.121 | 48650 986218045 | protocolo | 19788 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:15:35.432149-03 | 2008-04-01 11:10:15.950376-03| 172.16.0.121 | 48651 986218045 | protocolo | 22184 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:14:23.789697-03 | 2008-04-01 15:14:23.741447-03| 172.16.0.122 | 47409 986218045 | protocolo | 21116 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:14:37.846981-03 | 2008-04-01 13:31:30.202287-03| 172.16.0.121 | 50215 986218045 | protocolo | 21345 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:18:59.160153-03 | 2008-04-01 13:52:44.270813-03| 172.16.0.122 | 45548 986218045 | protocolo | 21350 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:46.426281-03 | 2008-04-01 13:53:16.103704-03| 172.16.0.122 | 45559 986218045 | protocolo | 21369 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:24.23198-03 | 2008-04-01 13:56:11.417009-03| 172.16.0.121 | 50664 986218045 | protocolo | 19149 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:13:42.26453-03 | 2008-04-01 10:14:22.006571-03| 172.16.0.121 | 47591 986218045 | protocolo | 21573 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:29.163194-03 | 2008-04-01 14:16:54.232667-03| 172.16.0.122 | 45966 986218045 | protocolo | 21608 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:18:42.41049-03 | 2008-04-01 14:20:54.906966-03| 172.16.0.121 | 51297 986218045 | protocolo | 21660 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:29.316444-03 | 2008-04-01 14:27:35.071414-03| 172.16.0.121 | 51428 986218045 | protocolo | 21855 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:18:17.970385-03 | 2008-04-01 14:45:44.362054-03| 172.16.0.122 | 46823 986218045 | protocolo | 21911 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:19:26.988034-03 | 2008-04-01 14:50:47.682127-03| 172.16.0.121 | 52110 986218045 | protocolo | 21917 | 218109 | protocolo | <IDLE> in transaction | 2008-04-01 15:14:42.857047-03 | 2008-04-01 14:51:21.247532-03| 172.16.0.121 | 52137 3680981633 | pmcs | 20505 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:19:45.939045-03 | 2008-04-01 12:22:49.182312-03| 172.16.0.121 | 49518 3680981633 | pmcs | 22141 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:19:46.419756-03 | 2008-04-01 15:10:27.765861-03| 172.16.0.122 | 47340 3680981633 | pmcs | 13828 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:19:46.149615-03 | 2008-03-31 22:44:32.853187-03| 172.16.0.121 | 45674 3680981633 | pmcs | 19547 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:19:46.647931-03 | 2008-04-01 10:52:54.087083-03| 172.16.0.121 | 48274 3680981633 | pmcs | 22185 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:14:23.854391-03 | 2008-04-01 15:14:23.850349-03| 172.16.0.122 | 47410 3680981633 | pmcs | 22203 | 218101 | sigamweb | <IDLE> in transaction | 2008-04-01 15:19:46.061452-03 | 2008-04-01 15:15:51.783964-03| 172.16.0.121 | 52719 (22 registros) -- Fernando Brombatti email-msn-gtalk-skype: [EMAIL PROTECTED] work: +55 54 3218-6060 mobile: +55 54 8112-7250 Visite www.datamais.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
