explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lWo2

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 4,472.727 ↑ 1.0 15 1

Limit (cost=35,455.19..35,456.91 rows=15 width=136) (actual time=4,466.568..4,472.727 rows=15 loops=1)

2. 631.389 4,472.712 ↑ 36.3 15 1

Gather Merge (cost=35,455.19..35,517.75 rows=544 width=136) (actual time=4,466.565..4,472.712 rows=15 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 21.458 3,841.323 ↑ 68.0 8 2 / 2

Sort (cost=34,455.18..34,456.54 rows=544 width=136) (actual time=3,841.323..3,841.323 rows=8 loops=2)

  • Sort Key: artifact0_.priority, artifact0_.artifact_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 30kB
4. 3.264 3,819.865 ↓ 62.8 34,140 2 / 2

Nested Loop (cost=2.29..34,441.83 rows=544 width=136) (actual time=2,231.899..3,819.865 rows=34,140 loops=2)

5. 12.215 3,509.345 ↓ 62.8 34,140 2 / 2

Nested Loop (cost=1.87..34,190.28 rows=544 width=141) (actual time=2,231.883..3,509.345 rows=34,140 loops=2)

6. 17.857 3,292.293 ↓ 62.8 34,140 2 / 2

Nested Loop (cost=1.59..34,008.87 rows=544 width=126) (actual time=2,231.873..3,292.293 rows=34,140 loops=2)

7. 30.513 3,069.599 ↓ 62.8 34,140 2 / 2

Nested Loop (cost=1.31..33,843.13 rows=544 width=111) (actual time=2,231.857..3,069.599 rows=34,140 loops=2)

8. 29.448 2,663.552 ↓ 59.9 34,140 2 / 2

Nested Loop (cost=0.88..33,482.40 rows=570 width=112) (actual time=2,231.838..2,663.552 rows=34,140 loops=2)

9. 30.951 269.734 ↓ 16.1 236,437 2 / 2

Nested Loop (cost=0.45..20,884.87 rows=14,719 width=39) (actual time=5.840..269.734 rows=236,437 loops=2)

10. 8.048 14.026 ↓ 1.5 6,074 2 / 2

Hash Semi Join (cost=0.03..3,273.72 rows=3,929 width=21) (actual time=0.932..14.026 rows=6,074 loops=2)

  • Hash Cond: ((fieldvalue5_.value_class)::text = ('Open'::text))
11. 5.965 5.965 ↑ 1.2 63,756 2 / 2

Parallel Seq Scan on field_value fieldvalue5_ (cost=0.00..3,033.08 rows=75,008 width=21) (actual time=0.243..5.965 rows=63,756 loops=2)

12. 0.009 0.013 ↑ 1.0 1 2 / 2

Hash (cost=0.02..0.02 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.004 0.004 ↑ 1.0 1 2 / 2

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=2)

14. 224.756 224.756 ↑ 3.0 39 12,149 / 2

Index Scan using artifact_status on artifact artifact0_ (cost=0.42..3.30 rows=118 width=38) (actual time=0.012..0.037 rows=39 loops=12,149)

  • Index Cond: ((status_fv)::text = (fieldvalue5_.id)::text)
15. 2,364.370 2,364.370 ↓ 0.0 0 472,874 / 2

Index Scan using item_pk on item item1_ (cost=0.43..0.86 rows=1 width=73) (actual time=0.010..0.010 rows=0 loops=472,874)

  • Index Cond: ((id)::text = (artifact0_.id)::text)
  • Filter: ((NOT is_deleted) AND ((folder_id)::text = 'tracker5673'::text))
  • Rows Removed by Filter: 1
16. 375.534 375.534 ↑ 2.0 1 68,279 / 2

Index Scan using relation_target on relationship relationsh2_ (cost=0.42..0.61 rows=2 width=19) (actual time=0.011..0.011 rows=1 loops=68,279)

  • Index Cond: ((target_id)::text = (artifact0_.id)::text)
  • Filter: ((NOT is_deleted) AND ((relationship_type_name)::text = 'ArtifactAssignment'::text))
  • Rows Removed by Filter: 1
17. 204.837 204.837 ↑ 1.0 1 68,279 / 2

Index Scan using sfuser_id on sfuser jpauser3_ (cost=0.28..0.30 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (relationsh2_.origin_id)::text)
18. 204.837 204.837 ↑ 1.0 1 68,279 / 2

Index Scan using sfuser_id on sfuser jpauser4_ (cost=0.28..0.33 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (item1_.created_by_id)::text)
19. 307.255 307.255 ↑ 1.0 1 68,279 / 2

Index Scan using field_value_pk on field_value fieldvalue6_ (cost=0.42..0.46 rows=1 width=15) (actual time=0.009..0.009 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (artifact0_.category_fv)::text)