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

From Tony Day
Subject Re: Long (really long) queries and not sure how to diagnose
Date
Msg-id k2t22eb2d871004292245he2cce000g79deb6a3db04bca5@mail.gmail.com
Whole thread Raw
In response to Long (really long) queries and not sure how to diagnose  (Tony Day <tonyd@panztel.com>)
List pgsql-novice
Hi Tom

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.


Thanks - at least I now have something to try - gives me the illusion of being in control :-)

Regards, Tony

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Long (really long) queries and not sure how to diagnose
Next
From: Lonni J Friedman
Date:
Subject: returning more than one value from a function