Feature request: log to single lines

[Ben Hizak]

Feature Request: Make auditing of database operations in stackdriver easier

Problem: Postgres log creates one line per row in SQL statements, which means that the in Stackdriver is multi-line. In other words, no single log captures a single event. This makes the logging hard to read, and nearly impossible to mine/ monitor.

Possible solution:

If you know what the limit is on your particular platform, you could adjust the chopping-point constant in elog.c (source)

Context: 

in order to audit postgres on Stackdriver logging, I set  log_statement=all

gcloud sql instances patch MY_INSTANCE_NAME --database-flags log_statement=all




Additional reading:

• About setting CloudSQL flags
• Postgres Docs: log_statement flag
• Setting the flag does not trigger database restart

• https://stackoverflow.com/questions/722221/how-to-log-postgresql-queries

• https://stackoverflow.com/a/722236

[Elliott (Google Cloud Platform Support)]

Hello,

Please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for feature requests, which is why I suggest using Issue Tracker to create one.