explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XTf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.002 3,206.623 ↑ 1.0 5 1

Limit (cost=233,819.86..233,819.87 rows=5 width=16) (actual time=3,206.621..3,206.623 rows=5 loops=1)

2. 502.012 3,206.621 ↑ 600,000.4 5 1

Sort (cost=233,819.86..241,319.86 rows=3,000,002 width=16) (actual time=3,206.619..3,206.621 rows=5 loops=1)

  • Sort Key: cg.created
  • Sort Method: top-N heapsort Memory: 25kB
3. 1,963.459 2,704.609 ↑ 1.0 3,000,002 1

Hash Join (cost=42,270.85..183,990.90 rows=3,000,002 width=16) (actual time=257.430..2,704.609 rows=3,000,002 loops=1)

  • Hash Cond: (cg.issueid = jiraissue.id)
4. 483.818 483.818 ↑ 1.0 3,000,002 1

Seq Scan on changegroup cg (cost=0.00..55,000.02 rows=3,000,002 width=16) (actual time=0.008..483.818 rows=3,000,002 loops=1)

5. 74.765 257.332 ↑ 1.0 300,000 1

Hash (cost=37,348.85..37,348.85 rows=300,000 width=8) (actual time=257.332..257.332 rows=300,000 loops=1)

6. 125.395 182.567 ↑ 1.0 300,000 1

Hash Semi Join (cost=21.85..37,348.85 rows=300,000 width=8) (actual time=0.219..182.567 rows=300,000 loops=1)

  • Hash Cond: (jiraissue.project = project.id)
7. 56.962 56.962 ↑ 1.0 300,000 1

Seq Scan on jiraissue (cost=0.00..33,202.00 rows=300,000 width=17) (actual time=0.003..56.962 rows=300,000 loops=1)

8. 0.122 0.210 ↑ 1.0 571 1

Hash (cost=14.71..14.71 rows=571 width=9) (actual time=0.210..0.210 rows=571 loops=1)

9. 0.088 0.088 ↑ 1.0 571 1

Seq Scan on project (cost=0.00..14.71 rows=571 width=9) (actual time=0.004..0.088 rows=571 loops=1)