Thread: Query column null
Hi
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.
regards
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