Re: Logging SQL queries to optimize them ?

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Logging SQL queries to optimize them ?
Date: 2006-04-02 14:45:34
Message-ID: e0oo2d$2r7a$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


"Bruno Baguette" <pgsql-ml(at)baguette(dot)net> wrote
>
>
> Is there a way to log all SQL queries, with the date/time when they were
> launched, and the cost of that query (if this is possible) in order to see
> which queries need to be optimized ?
>

See if log_statement, log_statement_stats parameters can help you. Also,
EXPLAIN ANALYZE can help you more on the target query.

Regards,
Qingqing

Browse pgsql-performance by date

  From Date Subject
Next Message Jan Kesten 2006-04-02 16:20:16 Re: index not used again
Previous Message Qingqing Zhou 2006-04-02 14:36:17 Re: Large Binary Objects Middleware