Pessoal,
Como posso saber exatamente o tempo que durou um determinado comando? Vejam
um trecho do log abaixo:
2014-08-09 16:53:39.853 BRT [13628]: [13-1] user=user_dgt,db=db_dgt LOG:
executar pdo_stmt_00000003: SELECT conemb_dtmovimento FROM usuario_expedicao
2014-08-09 16:53:39.869 BRT [13628]: [14-1] user=user_dgt,db=db_dgt LOG:
duração: 15.706 ms
2014-08-09 16:53:39.869 BRT [13628]: [15-1] user=user_dgt,db=db_dgt LOG:
comando: DEALLOCATE pdo_stmt_00000002
*2014-08-09 16:53:39.869 BRT [13628]: [16-1] user=user_dgt,db=db_dgt LOG:
duração: 0.065 ms2014-08-09 16:53:39.876 BRT [13628]: [17-1]
user=user_dgt,db=db_dgt LOG: duração: 0.145 ms2014-08-09 16:53:39.877 BRT
[13628]: [18-1] user=user_dgt,db=db_dgt LOG: duração: 0.241 ms*
2014-08-09 16:53:39.877 BRT [13628]: [19-1] user=user_dgt,db=db_dgt LOG:
executar pdo_stmt_00000004: SELECT
(SELECT rzsoc FROM tb001emp WHERE
(codtb001 = 1)) AS empnome
, (SELECT '07/08/2014') AS dataini
, (SELECT '07/08/2014') AS datafim
2014-08-09 16:53:39.877 BRT [13628]: [20-1] user=user_dgt,db=db_dgt LOG:
duração: 0.035 ms
2014-08-09 16:53:39.877 BRT [13628]: [21-1] user=user_dgt,db=db_dgt LOG:
comando: DEALLOCATE pdo_stmt_00000003
2014-08-09 16:53:39.877 BRT [13628]: [22-1] user=user_dgt,db=db_dgt LOG:
duração: 0.046 ms
2014-08-09 16:53:39.878 BRT [13628]: [23-1] user=user_dgt,db=db_dgt LOG:
comando: DEALLOCATE pdo_stmt_00000004
2014-08-09 16:53:39.878 BRT [13628]: [24-1] user=user_dgt,db=db_dgt LOG:
duração: 0.035 ms
O 1º comando "SELECT conemb_dtmovimento FROM usuario_expedicao" durou
15.706 ms? e os tempos das linhas abaixo, referem-se a qual comando?
[]s
Danilo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
