phantom long-running query (check_postgres.pl reports a long-running query, but the database logs don't show it)

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: phantom long-running query (check_postgres.pl reports a long-running query, but the database logs don't show it)
Date: 2012-02-09 00:32:37
Message-ID: CA+jMWocErE4Ek3qpY-DGwiSKqckPZtZhv4iAYX5tGX1tfeRXxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I got an alert from check_postgres.pl today on a long-running query on
our production database, but our PostgreSQL 8.4.9 server log, which is
configured to log queries over 5 seconds long
("log_min_duration_statement = 5000") does not show the query.

check_postgres.pl showed:
Date/Time: Wed Feb 8 08:41:36 PST 2012
POSTGRES_QUERY_TIME WARNING: (host:xxx) longest query: 264s
(database:xxx PID:xxx port:xxx address:xxx username:xxx)

postgres log showed other long-running queries, but nothing over 48s.

It's really interesting why the database server log does not show this query.

Can you think of some scenario where check_postgres.pl would see a
long-running query but it would not get logged by the database server?

I checked the server log and there is nothing there for 08:41 at all.
08:40 and 08:42, yes, some queries over 5 secs, but nothing even close
to 264 secs.

I've added the verbose switch to my check_postgres.pl script so we'll
have a record of what was the long-running query.

Best,
-at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2012-02-09 08:46:41 What is this vacuum doing?
Previous Message Vincent Veyron 2012-02-08 22:40:05 Re: Don't Thread On Me (PostgreSQL related)