Show full text of running queries in PostgreSQL

In order to show more information on the live queries, edit postgresql.conf and modify below value to a higher value (8000+ something): 
track_activity_query_size = 1024
After that run this command in psql console to view the live queries:
SELECT * FROM pg_stat_activity ORDER BY pid;
  • postgresql, query, full text, show
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

 Automatically cleaning up archived WAL files on a PostgreSQL server

It's been a couple of weeks since I set up a PostgreSQL replication but in the past few days...

 Finding corrupted row in the postgresql database

In case of a large database it is often the case where there might be corruption in it.Below is a...