Re: Monitor SQL Commands - Mailing list pgsql-novice

From A.Bhuvaneswaran
Subject Re: Monitor SQL Commands
Date
Msg-id Pine.LNX.4.44.0304011500580.3691-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Monitor SQL Commands  ("NOFINWAY" <mail@nofinway.com>)
List pgsql-novice
> How would one go about retrieving sql commands that are being sent to the
> database.
>
> What I'm trying to do is take a look at the queries and possibly time them
> to see what is taking so long and where is it getting hung up.

If pre-7.3, below entry must be there in postgresql.conf:
debug_print_query = true

If 7.3 or above, below entries must be there in postgresql.conf:
log_statement = true
log_duration = true

regards,
bhuvaneswaran


pgsql-novice by date:

Previous
From: "Crombleholme, Roy"
Date:
Subject: Re: Export content of a DB
Next
From: "Jennifer Lee"
Date:
Subject: Re: installation issues with postgresql 7.3.2