pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Query column null
2+ messages / 2 participants
[nested] [flat]

* Query column null
@ 2020-11-26 18:50  Yambu <hyambu@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Yambu @ 2020-11-26 18:50 UTC (permalink / raw)
  To: Pgsql-admin <pgsql-admin@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Query column null
@ 2020-11-27 07:40  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: Yambu <hyambu@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2020-11-27 07:40 UTC (permalink / raw)
  To: Yambu <hyambu@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2020-11-27 07:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-26 18:50 Query column null Yambu <hyambu@gmail.com>
2020-11-27 07:40 ` Laurenz Albe <laurenz.albe@cybertec.at>

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