Alex Ezell wrote:
We often do diagnostics on our PostgreSQL systems by looking at
currently running queries with some sql like this:
select procpid, to_char((now() - query_start), 'HH24:MI:SS.MS') as
query_time, client_addr as client_host, current_query
from pg_stat_activity
where
Sorry the double and top post, but please disregard. I've been
informed by a coworker that this is a PostgreSQL limitation on the
length of the current_query column and that thus far, the PostgreSQL
devs will not change it.
Sorry for the trouble.
/alex
On Mar 4, 9:56 am, Alex Ezell
Alex Ezell wrote:
On Mar 4, 10:01 am, Michael Bayer mike...@zzzcomputing.com wrote:
Alex Ezell wrote:
We often do diagnostics on our PostgreSQL systems by looking at
currently running queries with some sql like this:
select procpid, to_char((now() - query_start), 'HH24:MI:SS.MS') as
Previously Alex Ezell wrote:
Sorry the double and top post, but please disregard. I've been
informed by a coworker that this is a PostgreSQL limitation on the
length of the current_query column and that thus far, the PostgreSQL
devs will not change it.
Postgres has a log_statement