On Thu, 14 Apr 2005, Cristian Prieto wrote:
> Hello, I have a couple of bussy pgsql 8 servers running in my office, in
> MySQL I use SHOW PROCESSLIST to show the actual process running in the
> MySQL server (idle time, resources and other statistical data) and a
> little perl app named mytop to show the data like the top unix
> utility... There such way to do the same or similar stuff in PostgreSQL?
>
PostgreSQL can log long time executed sql commands. Set
log_min_duration_statement on some value in your postgresql.conf file.
I have good experience with it. Its very usefull for finding long sql
cmds.
regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
