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