Re: Query column null

On Thu, 2020-11-26 at 20:50 +0200, Yambu wrote:
> A strange thing is happening in my csv logs, i cannot see the query that ran whenever there is a duration in the logs, is there something i'm missing?
>
> When i run the below query it returns nothing
>
> select message,query from postgres_log where message ilike '%duration%' and query is not null limit 1;
>
> Note: I loaded the csv logs into postgres_log table.

Hard to say with that information, but perhaps you set "log_duration = on".

If you use "log_min_duration_statement = 0", you might get what you want.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com