Re: Is there a way to list running queries

Frank Church caused electrons to display this:
>
> Is there a way to list running queries in PostgreSQL, especially those that
> appear to have gone away or don't seem to be running at all?

You should always include relevant info such as which version of postgres you are using.

If the stats are enabled (stats_start_collector and stats_command_string in 8.1) you can see running queries in the pg_stat_activity system view.

You can also set the logging to show all commands (in 8.1 set log_min_duration_statement to 0 (and perhaps set log_statement to 'all') and the designated log will show all queries.

Queries which have gone away will prove to most elusive, I fear ... not running at all could be a symptom of locks or contentions for tables/rows, etc. More information might help people give you a better answer.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC