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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
