Re: Long (really long) queries and not sure how to diagnose - Mailing list pgsql-novice

From Tom Lane
Subject Re: Long (really long) queries and not sure how to diagnose
Date
Msg-id 15083.1272605532@sss.pgh.pa.us
Whole thread Raw
In response to Re: Long (really long) queries and not sure how to diagnose  (Tony Day <tonyd@panztel.com>)
List pgsql-novice
Tony Day <tonyd@panztel.com> writes:
> I am not sure what you mean by "complete query logs" but I do have a 1.3G
> Postgresql log file from the day in question.
> Is there a particular way that a "write-preventing lock" will be logged that
> I can search for in that file?

Well, other than an explicit LOCK TABLE, it'd be some sort of DDL action
on the table.  CREATE INDEX, ALTER TABLE, that sort of thing.  I'd try
grepping the query log for the table name and then filtering out the
easy select/insert/update/delete stuff.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tony Day
Date:
Subject: Re: Long (really long) queries and not sure how to diagnose
Next
From: Tony Day
Date:
Subject: Re: Long (really long) queries and not sure how to diagnose