Thread: SQL Profiler

SQL Profiler

From
jbelskus@acctvantage.com
Date:
I've made the switch from SQL Server and really like Postgres, but I can't
find an equivalent tool for SQL Profiler.  This allows an administrator to
monitor connections and inbound SQL requests.  Its very useful for
application debugging in that its very easy to see the SQL statements that
an app. is passing to the db.  Is there such a tool in Postgres?

Thanks much,

Jason



Re: SQL Profiler

From
"Pavel Stehule"
Date:
Hello

2008/5/21  <jbelskus@acctvantage.com>:
> I've made the switch from SQL Server and really like Postgres, but I can't
> find an equivalent tool for SQL Profiler.  This allows an administrator to
> monitor connections and inbound SQL requests.  Its very useful for
> application debugging in that its very easy to see the SQL statements that
> an app. is passing to the db.  Is there such a tool in Postgres?
>
> Thanks much,
>
> Jason
>

PostgreSQL has other kits - first slow query log (look to
postgresql.conf) and analyser of this log pgfouine
http://pgfouine.projects.postgresql.org/

Regards
Pavel Stehule

>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>