How to get more characters in a cell when querying?

Question

PostgreSQL

Good afternoon.
I am making a query in the Postgresql database to find out queries against my database.
SELECT * FROM pg_stat_activity;
Below is a list of columns with queries

. In the column called current_query_text, some queries do not fit - apparently there is a limit on the number of characters in a cell. As a result, requests are cut off. How can I remove the character limit?

Answer 1

pg_stat_activity.query is capped at the top by the configuration parameter track_activity_query_size. Default is 1024 bytes.
PS: current_query was called before postgresql 9.2, which is already EOL for a long time and 9.2 itself is already EOL. Plan for an update.