Обсуждение: Query column null

Поиск
Список
Период
Сортировка

Query column null

От
Yambu
Дата:
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

Re: Query column null

От
Laurenz Albe
Дата:
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