| Lists: | pgsql-hackers |
|---|
| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | disabling log_min_duration_statement from pg_dump? |
| Date: | 2010-03-08 21:12:51 |
| Message-ID: | 3073cc9b1003081312s6b34b6c6qc50b37c9d92e7a7e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi,
Every often, i analyze logs to find most slow queries... and every
time i found myself trying to ignore pg_dump's generated COPY commands
which could be very expensive...
can we add a parameter in pg_dump and pg_dumpall to disable
log_min_duration_statement?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: disabling log_min_duration_statement from pg_dump? |
| Date: | 2010-03-08 21:25:31 |
| Message-ID: | 23207.1268083531@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> can we add a parameter in pg_dump and pg_dumpall to disable
> log_min_duration_statement?
export PGOPTIONS="-c log_min_duration_statement=-1"
Or use ALTER USER SET to add that to the options for the account
you do pg_dump with; etc etc.
regards, tom lane
| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: disabling log_min_duration_statement from pg_dump? |
| Date: | 2010-03-08 22:01:41 |
| Message-ID: | 3073cc9b1003081401i690dd72difc7585861a036b7c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, Mar 8, 2010 at 4:25 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
>> can we add a parameter in pg_dump and pg_dumpall to disable
>> log_min_duration_statement?
>
> export PGOPTIONS="-c log_min_duration_statement=-1"
>
ah! so, that is PGOPTIONS for :)
and that works for every libpq application?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: disabling log_min_duration_statement from pg_dump? |
| Date: | 2010-03-08 22:57:20 |
| Message-ID: | 201003082257.o28MvKG02862@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Jaime Casanova wrote:
> On Mon, Mar 8, 2010 at 4:25 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> >> can we add a parameter in pg_dump and pg_dumpall to disable
> >> log_min_duration_statement?
> >
> > export PGOPTIONS="-c log_min_duration_statement=-1"
> >
>
> ah! so, that is PGOPTIONS for :)
> and that works for every libpq application?
Yes.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do