You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2013/04/23 12:39:15 UTC
[jira] [Created] (CONNECTORS-678) Postgresql generating terrible
plans for stuffer queries
Karl Wright created CONNECTORS-678:
--------------------------------------
Summary: Postgresql generating terrible plans for stuffer queries
Key: CONNECTORS-678
URL: https://issues.apache.org/jira/browse/CONNECTORS-678
Project: ManifoldCF
Issue Type: Bug
Components: Framework core
Affects Versions: ManifoldCF 1.1.1
Reporter: Karl Wright
Assignee: Karl Wright
Fix For: ManifoldCF 1.2
Query plans like this seem to be taking place:
{code}
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Limit (cost=9597.49..9597.49 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Sort (cost=9597.49..9597.49 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Sort Key: t0.docpriority
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Nested Loop Anti Join (cost=17.68..9597.48 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Join Filter: (t2.jobid <> t0.jobid)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Nested Loop Semi Join (cost=17.68..9588.87 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Join Filter: (t0.jobid = t1.id)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Nested Loop Anti Join (cost=17.68..9586.81 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Join Filter: (t0.id = t3.owner)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Bitmap Heap Scan on jobqueue t0 (cost=4.53..6.54 rows=1 width=155)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Recheck Cond: (status = ANY ('{P,G}'::bpchar[]))
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Filter: ((checktime <= 1366628406182::bigint) AND (checkaction = 'R'::bpchar))
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Bitmap Index Scan on i1362584563122 (cost=0.00..4.53 rows=1 width=0)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Index Cond: (status = ANY ('{P,G}'::bpchar[]))
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Hash Join (cost=13.15..7635.56 rows=231554 width=8)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Hash Cond: ((t3.eventname)::text = (t4.name)::text)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Seq Scan on prereqevents t3 (cost=0.00..4438.54 rows=231554 width=37)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Hash (cost=11.40..11.40 rows=140 width=516)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Seq Scan on events t4 (cost=0.00..11.40 rows=140 width=516)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Seq Scan on jobs t1 (cost=0.00..2.03 rows=2 width=8)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Filter: ((status = ANY ('{A,a}'::bpchar[])) AND (priority = 5::bigint))
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: -> Index Scan using i1362584563120 on jobqueue t2 (cost=0.00..4.30 rows=1 width=49)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Index Cond: ((dochash)::text = (t0.dochash)::text)
WARN 2013-04-22 13:01:20,414 (Stuffer thread) - Plan: Filter: (status = ANY ('{A,F,a,f,D,d}'::bpchar[]))
WARN 2013-04-22 13:01:20,414 (Stuffer thread) -
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira