Postgres_log table import not captuirng SQL

Posted on

Question :

While importing postgres log,sql is not inserting into table query column:

enter image description here

Answer :

Not all log messages include the query text. log_duration, for example, just logs the duration, not the text of the query. If the query text isn’t in the csv file to start with, it won’t get populated into the table.

Using log_min_duration_statement=0 rather than log_duration will log both the duration and the text of all queries.

Leave a Reply

Your email address will not be published. Required fields are marked *