Unix Technical Forum

SQL Profiler

This is a discussion on SQL Profiler within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> I've made the switch from SQL Server and really like Postgres, but I can't find an equivalent tool for ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-24-2008, 06:11 AM
jbelskus@acctvantage.com
 
Posts: n/a
Default SQL Profiler

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


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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-24-2008, 06:11 AM
Pavel Stehule
 
Posts: n/a
Default Re: SQL Profiler

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
>


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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:31 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com