Questions tagged [pgfouine]

3 questions
5
votes
1 answer

How to use pgFouine with PostgreSQL 9.1?

Using pgFouine 1.2, PostgreSQL 9.1.3. postgresql.conf settings: log_min_duration_statement = 0 log_duration = on log_line_prefix = '%t [%p]: [%l-1] ' log_statement = 'all' lc_messages = 'C' # locale for system error message…
Răzvan Flavius Panda
  • 21,730
  • 17
  • 111
  • 169
0
votes
0 answers

can't find the error in my postgresql.conf

im using pgfouine 1.2 for postgres 9.6 on windows 7 i keep getting this error when trying to analyse my log file and generate report , “pgfouine did not find any valid postgresql log line in your log file “ Here is my postgresql.conf file…
0
votes
1 answer

PostgreSQL. Slow Prepare Transaction and Commit Prepared

I've just encountered a strange problem. I've made a report in pgfourine, and found out that my XA transactions started to work really slow. Prepare transaction and commit prepared combined took 12.55s out of 13.2s. But why? ##### Overall…
Andrey Frolov
  • 1,534
  • 10
  • 19