From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: log sql? |
Date: | 2002-07-30 15:06:54 |
Message-ID: | 200207301506.g6UF6sS25229@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
What we really need is something that prints the query, username, and
times for admins who want to see which queries are slow. That is on the
TODO list.
---------------------------------------------------------------------------
Andrew Sullivan wrote:
> On Tue, Jul 30, 2002 at 12:14:16AM -0400, Bruce Momjian wrote:
> > Andrew, what postgresql.conf parameter is query logging. I don't see
> > it. I see:
> >
> > #log_connections = false
> > #log_timestamp = false
> > #log_pid = false
>
> debug_print_query = true
>
> If you really want to see what's going on, you can also turn on any
> of these:
>
> #debug_print_parse = false
> #debug_print_rewritten = false
> #debug_print_plan = false
> #debug_pretty_print = false
>
> The _rewritten one is really interesting, and sometimes shows you why
> your query runs slowly. Not recommended for production systems,
> though!
>
> Note that all of this exacts a cost, so if you need really blazing
> performance, it's not a bad idea to turn it off. But for tracking
> down problems, nothing beats a good verbose log.
>
> A
>
> --
> ----
> Andrew Sullivan 87 Mowat Avenue
> Liberty RMS Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)info> M6K 3E3
> +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Laurette Cisneros | 2002-07-30 16:29:36 | Re: [GENERAL] log sql? |
Previous Message | Andrew Sullivan | 2002-07-30 15:00:02 | Re: log sql? |
From | Date | Subject | |
---|---|---|---|
Next Message | Amin Abdulghani | 2002-07-30 15:07:25 | Re: postgres 7.2.1 parse bug |
Previous Message | Andrew Sullivan | 2002-07-30 15:00:02 | Re: log sql? |