Menu
Yes, I know there is a stack overflow question with the exact same name:
Queries in pg_stat_activity are truncated?
I set this value to 7168, rebooted the server, and verified it with show track_activity_query_size. It actually shortened the amount of text shown, its now truncating at 256 characters.
What am I missing?
Edit: My database is an AWS RDS instance (db.t2.small) runningPostgreSQL 9.3.6
777
pg_stat_activity is a system view that allows you to identify active SQL queries in AnalyticDB for PostgreSQL instances. The pg_stat_activity view shows a server process and its related session and query in each row.
The view pg_stat_activity shows one row per server process with details about the associated user session and query. The columns that report data on the current query are available unless the parameter stats_command_string has been turned off.
backend_xid means Top-level transaction identifier of this backend, if any. backend_xmin means The current backend's xmin horizon.
I was using PGAdmin. The query actually was returning a larger value, but PGAdmin was truncating it and I was copy/pasting it from the column out. The solution (for anybody else having this problem) is to use Query -> execute to file. This will write the full results, which you can then look at in the CSV file that it writes.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
