postgresql-log for testing pgbadger reports

postgresql-Thu.log

2012-12-06 12:22:01 CET [2875]: [1-1] db=[unknown],user=[unknown] LOG:  connection received: host=::1 port=35588                                                                                                                                  
2012-12-06 12:22:01 CET [2875]: [2-1] db=spielplatz,user=postgres LOG:  connection authorized: user=postgres database=spielplatz
2012-12-06 12:22:01 CET [2875]: [3-1] db=spielplatz,user=postgres LOG:  duration: 0.094 ms  statement: begin
2012-12-06 12:22:01 CET [2875]: [4-1] db=spielplatz,user=postgres LOG:  duration: 1.130 ms  parse dbdpg_p2874_1:
                 SELECT id, hexcode FROM foo WHERE color like $1 ORDER BY hexcode DESC

2012-12-06 12:22:01 CET [2875]: [5-1] db=spielplatz,user=postgres LOG:  duration: 0.055 ms  bind dbdpg_p2874_1:
                 SELECT id, hexcode FROM foo WHERE color like $1 ORDER BY hexcode DESC

2012-12-06 12:22:01 CET [2875]: [6-1] db=spielplatz,user=postgres DETAIL:  parameters: $1 = 'red'
2012-12-06 12:22:03 CET [2875]: [7-1] db=spielplatz,user=postgres LOG:  duration: 1873.834 ms  execute dbdpg_p2874_1:
                 SELECT id, hexcode FROM foo WHERE color like $1 ORDER BY hexcode DESC

2012-12-06 12:22:03 CET [2875]: [8-1] db=spielplatz,user=postgres DETAIL:  parameters: $1 = 'red'
2012-12-06 12:22:05 CET [2875]: [9-1] db=spielplatz,user=postgres LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp2875.0", size 3678208
2012-12-06 12:22:05 CET [2875]: [10-1] db=spielplatz,user=postgres STATEMENT:  DEALLOCATE dbdpg_p2874_1
2012-12-06 12:22:05 CET [2875]: [11-1] db=spielplatz,user=postgres LOG:  duration: 1.871 ms  statement: DEALLOCATE dbdpg_p2874_1
2012-12-06 12:22:05 CET [2875]: [12-1] db=spielplatz,user=postgres LOG:  duration: 0.074 ms  statement: rollback
2012-12-06 12:22:05 CET [2875]: [13-1] db=spielplatz,user=postgres LOG:  disconnection: session time: 0:00:03.893 user=postgres database=spielplatz host=::1 port=35588