What can cause quick queries to run unusually slow?

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: What can cause quick queries to run unusually slow?
Date: 2013-03-14 16:07:48
Message-ID: 5141F5D4.7090904@pukkasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug


Had an interesting query in my logs this morning:

DELETE FROM formobject WHERE objectid =
'C37EDD28-F46C-4DC4-A2D5FF042895C696';

It took *104 seconds* to complete. Here's the plan captured from the
log as well:

QUERY PLAN
-------------------------------------------------------------------
Delete (cost=0.00..6.33 rows=1 width=6)
-> Index Scan using formobject_pkey on formobject (cost=0.00..6.33
rows=1 width=6)
Index Cond: (objectid =
'C37EDD28-F46C-4DC4-A2D5FF042895C696'::bpchar)

We run this query all day long. What are things that might cause it to
take 1000 times longer than normal? It was not during our nightly
backup or any other intensive scheduled task that I'm aware of.
Autovacuum? Something else?

Brian

Responses

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2013-03-14 20:25:34 Re: What can cause quick queries to run unusually slow?
Previous Message Josh Berkus 2013-03-06 19:50:35 April, May SFPUGs scheduled