Re: Monitor SQL Commands

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Monitor SQL Commands
Date: 2003-04-01 09:32:29
Message-ID: Pine.LNX.4.44.0304011500580.3691-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jennifer Lee 2003-04-01 18:22:20 Re: installation issues with postgresql 7.3.2
Previous Message Crombleholme, Roy 2003-04-01 09:25:34 Re: Export content of a DB