explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Iyp

options
# exclusive inclusive rows x rows loops node
1. 0.000 846.134 ↑ 1.0 76 1
→

Limit (cost=37.02..1253.65 rows=76 width=8) (actual time=4.594..846.134 rows=76 loops=1)

2.          

Initplan (forLimit)
3. 0.098 0.418 ↑ 1.0 1 1
→

Aggregate (cost=37.01..37.02 rows=1 width=4) (actual time=0.418..0.418 rows=1 loops=1)

4. 0.320 0.320 ↓ 1.5 107 1
→

Index Scan using teamparticipation_person_idx on teamparticipation (cost=0.00..36.83 rows=72 width=4) (actual time=0.023..0.320 rows=107 loops=1)

  • Index Cond: (person = 21997)
5. 1.546 845.998 ↑ 534.2 76 1
→

Nested Loop Semi Join (cost=0.00..649981.58 rows=40603 width=8) (actual time=4.591..845.998 rows=76 loops=1)

6. 42.494 42.494 ↑ 363.7 458 1
→

Index Scan Backward using bugtaskflat__distribution__importance__bugtask__idx on bugtaskflat (cost=0.00..178291.50 rows=166583 width=12) (actual time=0.162..42.494 rows=458 loops=1)

  • Index Cond: (distribution = 1)
  • Filter: ((duplicateof IS NULL) AND ((information_type = ANY ('{1,2}'::integer[])) OR (access_grants && $0)) AND (status = ANY ('{10,20,21,22,25,13,14}'::integer[])))
7. 801.958 801.958 ↓ 0.0 0 458
→

Index Scan using sourcepackagepublishinghistory__sourcepackagename__idx on sourcepackagepublishinghistory (cost=0.00..2.83 rows=1 width=4) (actual time=1.751..1.751 rows=0 loops=458)

  • Index Cond: (sourcepackagepublishinghistory.sourcepackagename = bugtaskflat.sourcepackagename)
  • Filter: ((sourcepackagepublishinghistory.archive = ANY ('{1,534}'::integer[])) AND (sourcepackagepublishinghistory.distroseries = 110) AND (sourcepackagepublishinghistory.component = 3) AND (sourcepackagepublishinghistory.status = 2))