Monitoring performance

From: Jan Ploski <jpljpl(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Monitoring performance
Date: 2001-03-15 22:34:19
Message-ID: 5394851.984695659329.JavaMail.jpl@remotejava
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is there a way to monitor query performance on the database server level?
What I am doing now is tweaking the JDBC driver to log slow queries
(slow = taking longer than some arbitrary threshold), but it appears to
me that the db server itself should be the ideal place for such tasks.

Can anyone point me to some documentation about how to get to some
internal stats, if they exist? I have found nothing in the Admin guide
nor in the book (apart from general advice about top/ps).

Thanks,
JPL

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2001-03-15 22:34:40 Re: Re: Re: LIKE and indexes?
Previous Message Bill Huff 2001-03-15 22:33:29 Re: Re: Re: LIKE and indexes?