"COPY TO stdout" statements occurrence in log files

From: Fernando Mertins <fernando(dot)mertins(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: "COPY TO stdout" statements occurrence in log files
Date: 2011-01-14 19:42:23
Message-ID: AANLkTinUziwN+9fMRin0n3uKhfqB1B3WfX5gLyO9zq6f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2011-01-14 20:11:11 Re: queries with lots of UNIONed relations
Previous Message Robert Haas 2011-01-14 19:03:47 Re: Problems with FTS