From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Yambu <hyambu@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Query column null
Date: Fri, 27 Nov 2020 08:40:13 +0100
Message-ID: <dcf256f9e9db553993c78770bc51b06c7f9a5194.camel@cybertec.at> (raw)
In-Reply-To: <CALhHtcBfLUARnSBkowzwyMwehwoyM_JWd5nBUqhjBd_tixNtzg@mail.gmail.com>
References: <CALhHtcBfLUARnSBkowzwyMwehwoyM_JWd5nBUqhjBd_tixNtzg@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, hyambu@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Query column null
In-Reply-To: <dcf256f9e9db553993c78770bc51b06c7f9a5194.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox