From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Matthew Vernon <matthew(dot)vernon(at)sac(dot)ac(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Logging successful SELECTS? |
Date: | 2013-01-24 12:57:16 |
Message-ID: | CAFj8pRDHJGfbocY4B4Od49fEOyiaRPRc_Uyj5GKx4VqC8PjfFQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2013/1/24 Matthew Vernon <matthew(dot)vernon(at)sac(dot)ac(dot)uk>:
> Hi,
>
> I can get postgres to log unsuccessful queries, including the user who
> wrote them, but I'm missing how to get postgres to log the successful
> queries too (I don't need a store of the answer, just the query
> itself). How do I do this?
use log_min_duration_statement = 0
Regards
Pavel Stehule
>
> Thanks,
>
> Matthew
>
> --
> Matthew Vernon
> Quantitative Veterinary Epidemiologist
> Epidemiology Research Unit, SAC Inverness
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2013-01-24 13:50:36 | Re: BUG #6510: A simple prompt is displayed using wrong charset |
Previous Message | Виктор Егоров | 2013-01-24 12:48:26 | Re: Logging successful SELECTS? |