Guido Neitzer wrote:
Hi.
Is there a way to set up logging in a way that I can see queries which
trigger seq scans? Or to log queries "taking longer than xx ms"?
The second is straightforward. See the "log_min_duration_statement"
setting in the "logging" section of the manuals.
--
Richard
On 07.03.2006, at 12:11 Uhr, A. Kretschmer wrote:
Yes, of cource. You can define
log_min_duration_statement = 100
to log all queries taking longer 100 ms.
Thanks.
cug
--
PharmaLine, Essen, GERMANY
Software and Database Development
smime.p7s
Description: S/MIME cryptographic signature
am 07.03.2006, um 11:59:18 +0100 mailte Guido Neitzer folgendes:
> Hi.
>
> Is there a way to set up logging in a way that I can see queries which
> trigger seq scans? Or to log queries "taking longer than xx ms"?
Yes, of cource. You can define
log_min_duration_statement = 100
to log all quer
Hi.
Is there a way to set up logging in a way that I can see queries
which trigger seq scans? Or to log queries "taking longer than xx ms"?
Background is, that it is nearly impossible to tell, which queries
are used in my applications as they are mostly generated by the
frameworks. Yester
