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
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 |