"COPY TO stdout" statements occurrence in log files
От | Fernando Mertins |
---|---|
Тема | "COPY TO stdout" statements occurrence in log files |
Дата | |
Msg-id | AANLkTinUziwN+9fMRin0n3uKhfqB1B3WfX5gLyO9zq6f@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: "COPY TO stdout" statements occurrence in log files
|
Список | pgsql-performance |
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
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
В списке pgsql-performance по дате отправления: