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
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 |