boa noite, Pelo que entendi uma das vantagens de usar prepared statements é que o parse é realizado apenas uma vez para consultas idênticas, gostaria de saber se é nomal ter no log todos estes registros de bind também?
2016-01-13 14:17:04 BRST [10225]: [4-1] LOG: duration: 33570.858 ms execute <unnamed>: ... 2016-01-13 14:17:04 BRST [10229]: [4-1] LOG: duration: 32828.979 ms execute <unnamed>: ... 2016-01-13 14:17:05 BRST [10228]: [4-1] LOG: duration: 33158.300 ms execute <unnamed>: ... 2016-01-13 14:17:05 BRST [9522]: [10-1] LOG: duration: 33564.056 ms execute <unnamed>: ... 2016-01-13 14:17:05 BRST [10227]: [4-1] LOG: duration: 32830.827 ms execute <unnamed>: ... 2016-01-13 14:17:07 BRST [10233]: [4-1] LOG: duration: 33707.367 ms execute <unnamed>: ... 2016-01-13 14:17:08 BRST [10232]: [4-1] LOG: duration: 34604.249 ms execute <unnamed>: ... 2016-01-13 14:17:09 BRST [10235]: [4-1] LOG: duration: 34825.490 ms execute <unnamed>: ... 2016-01-13 14:17:11 BRST [10234]: [4-1] LOG: duration: 35785.093 ms execute <unnamed>: ... 2016-01-13 14:17:12 BRST [10236]: [4-1] LOG: duration: 36861.005 ms execute <unnamed>: ... 2016-01-13 14:17:14 BRST [10231]: [4-1] LOG: duration: 37549.028 ms execute <unnamed>: ... 2016-01-13 14:17:20 BRST [10224]: [5-1] LOG: duration: 17592.364 ms bind <unnamed>: ... 2016-01-13 14:17:23 BRST [10239]: [5-1] LOG: duration: 19288.528 ms bind <unnamed>: ... 2016-01-13 14:17:23 BRST [10225]: [5-1] LOG: duration: 19133.306 ms bind <unnamed>: ... 2016-01-13 14:17:24 BRST [10238]: [3-1] LOG: duration: 20334.185 ms bind <unnamed>: ... 2016-01-13 14:17:25 BRST [10308]: [3-1] LOG: duration: 20392.145 ms bind <unnamed>: ... 2016-01-13 14:17:26 BRST [10226]: [5-1] LOG: duration: 20771.352 ms bind <unnamed>: ... 2016-01-13 14:17:26 BRST [10229]: [5-1] LOG: duration: 20935.923 ms bind <unnamed>: ... 2016-01-13 14:17:27 BRST [10240]: [3-1] LOG: duration: 21022.901 ms bind <unnamed>: ... 2016-01-13 14:17:29 BRST [9522]: [11-1] LOG: duration: 20882.280 ms bind <unnamed>: ... 2016-01-13 14:17:30 BRST [10320]: [3-1] LOG: duration: 22028.661 ms bind <unnamed>: ... 2016-01-13 14:17:30 BRST [10318]: [3-1] LOG: duration: 22472.868 ms bind <unnamed>: ... 2016-01-13 14:17:30 BRST [10327]: [3-1] LOG: duration: 2535.394 ms parse <unnamed>: ... exite algum timeout para que a query realize um novo parse? Atenciosamente, Alessandro Lima
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
