explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vVbt

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 4,034.579 ↑ 1.0 15 1

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

2. 404.662 4,034.565 ↑ 36.3 15 1

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

  • Workers Planned: 1
  • Workers Launched: 1
3. 17.936 3,629.903 ↑ 68.0 8 2 / 2

Sort (cost=34,455.18..34,456.54 rows=544 width=136) (actual time=3,629.903..3,629.903 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. 28.880 3,611.967 ↓ 62.8 34,140 2 / 2

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

5. 16.486 3,344.111 ↓ 62.8 34,140 2 / 2

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

6. 20.560 3,156.928 ↓ 62.8 34,140 2 / 2

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

7. 7.423 2,965.670 ↓ 62.8 34,140 2 / 2

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

8. 0.000 2,616.852 ↓ 59.9 34,140 2 / 2

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

9. 30.697 262.669 ↓ 16.1 236,437 2 / 2

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

10. 7.683 13.290 ↓ 1.5 6,074 2 / 2

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

  • Hash Cond: ((fieldvalue5_.value_class)::text = ('Open'::text))
11. 5.595 5.595 ↑ 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.196..5.595 rows=63,756 loops=2)

12. 0.008 0.012 ↑ 1.0 1 2 / 2

Hash (cost=0.02..0.02 rows=1 width=32) (actual time=0.012..0.012 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. 218.682 218.682 ↑ 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.036 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. 341.395 341.395 ↑ 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.010..0.010 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. 170.697 170.697 ↑ 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.005..0.005 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (relationsh2_.origin_id)::text)
18. 170.697 170.697 ↑ 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.005..0.005 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (item1_.created_by_id)::text)
19. 238.977 238.977 ↑ 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.007..0.007 rows=1 loops=68,279)

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