Server Status

Top  Previous  Next

Shows one row per server process, showing the process id number(PID),
database name, user name and the backend start time.
The query column will only show data if the  parameter stats_command_string has
been turned on in the postgresql.conf file or via a session variable per user. 
If the server is 8.0 or higher it will show the port and IP address of the backend process.

The LA status monitor has the ability to capture the executing query by
selecting a row and turning on the "Capture selected rows query".

The captured queries will then accumulate in the capture area and you may copy them out for use in debugging etc.

The refresh rate may also be changed by increasing the value in the spin edit control, setting the refresh value to 0 turns it off.