Hi there,
I have one log file per week and logging all statements >= 500 ms execution time.
But, with "normal" statements are occuring something like this:
2011-01-13 00:11:38 BRT LOG: duration: 2469.000 ms statement: FETCH 1000 IN bloboid
2011-01-13 00:12:01 BRT LOG: duration: 797.000 ms statement: SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) as rolname, nspacl FROM pg_namespace
2011-01-13 00:12:06 BRT LOG: duration: 766.000 ms statement: COPY public.log (codlog, matricula, data, descricao, codcurso, ip) WITH OIDS TO stdout;
2011-01-13 00:12:10 BRT LOG: duration: 2328.000 ms statement: FETCH 1000 IN bloboid
2011-01-13 00:12:34 BRT LOG: duration: 594.000 ms statement: SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) as rolname, nspacl FROM pg_namespace
2011-01-13 00:12:38 BRT LOG: duration: 672.000 ms statement: COPY public.avaliacao_topico_opcao (codavaliacao_topico_opcao, codavaliacao_topico, descricao, selecao) WITH OIDS TO stdout;
2011-01-13 00:12:39 BRT LOG: duration: 891.000 ms statement: COPY public.log (codlog, matricula, data, descricao, codcurso, ip) WITH OIDS TO stdout;
Is this normal? I'm afraid because my application doesn't run this kind of statement, so how can I know what is doing these commands? Maybe pg_dump?
Thank you!
Fernando