adey <adey11@xxxxxxxxx> writes: > You could try the following query after enabling the > stats_command_string parameter in the postgresql.conf file:- The pg_stat_activity mechanism *does* have a limit on the query string length it can display, and if memory serves that limit was not large in 7.3.* --- I'm thinking 256 bytes. However, the postmaster log doesn't have any hard limit that I'm aware of, so it seems like Chris' original approach should work. regards, tom lane
