explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7SLs

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 4,354.697 ↑ 1.0 15 1

Limit (cost=44,889.41..44,891.16 rows=15 width=149) (actual time=4,340.591..4,354.697 rows=15 loops=1)

2. 29.343 4,354.688 ↑ 99.1 15 1

Gather Merge (cost=44,889.41..45,062.79 rows=1,486 width=149) (actual time=4,340.590..4,354.688 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 13.214 4,325.345 ↑ 57.2 13 3 / 3

Sort (cost=43,889.39..43,891.25 rows=743 width=149) (actual time=4,325.344..4,325.345 rows=13 loops=3)

  • Sort Key: artifact0_.priority, (to_number("substring"((item1_.id)::text, 5), '999999999999999999999999999'::text))
  • Sort Method: top-N heapsort Memory: 30kB
  • Worker 0: Sort Method: top-N heapsort Memory: 30kB
  • Worker 1: Sort Method: top-N heapsort Memory: 30kB
4. 42.684 4,312.131 ↓ 30.6 22,760 3 / 3

Nested Loop (cost=2,716.32..43,871.16 rows=743 width=149) (actual time=483.471..4,312.131 rows=22,760 loops=3)

5. 17.775 4,019.091 ↓ 30.6 22,760 3 / 3

Nested Loop (cost=2,715.90..43,538.09 rows=743 width=127) (actual time=483.132..4,019.091 rows=22,760 loops=3)

6. 13.529 3,841.998 ↓ 30.6 22,760 3 / 3

Nested Loop (cost=2,715.62..43,291.79 rows=743 width=112) (actual time=483.101..3,841.998 rows=22,760 loops=3)

7. 13.141 3,646.392 ↓ 30.6 22,760 3 / 3

Nested Loop (cost=2,715.33..43,065.41 rows=743 width=97) (actual time=483.043..3,646.392 rows=22,760 loops=3)

8. 57.355 3,291.856 ↓ 29.2 22,760 3 / 3

Nested Loop (cost=2,714.91..42,571.65 rows=780 width=98) (actual time=480.517..3,291.856 rows=22,760 loops=3)

9. 68.344 219.993 ↓ 8.4 158,658 3 / 3

Parallel Hash Join (cost=2,714.48..25,141.28 rows=18,980 width=24) (actual time=9.146..219.993 rows=158,658 loops=3)

  • Hash Cond: ((artifact0_.status_fv)::text = (fieldvalue5_.id)::text)
10. 145.121 145.121 ↑ 1.2 160,259 3 / 3

Parallel Seq Scan on artifact artifact0_ (cost=0.00..21,904.32 rows=199,032 width=34) (actual time=2.289..145.121 rows=160,259 loops=3)

11. 1.667 6.528 ↑ 1.8 4,050 3 / 3

Parallel Hash (cost=2,625.07..2,625.07 rows=7,153 width=10) (actual time=6.527..6.528 rows=4,050 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 736kB
12. 4.128 4.861 ↑ 1.2 6,074 2 / 3

Parallel Bitmap Heap Scan on field_value fieldvalue5_ (cost=414.66..2,625.07 rows=7,153 width=10) (actual time=1.279..7.292 rows=6,074 loops=2)

  • Recheck Cond: ((value_class)::text = 'Open'::text)
  • Heap Blocks: exact=568
13. 0.733 0.733 ↑ 1.0 12,149 1 / 3

Bitmap Index Scan on field_class_idx (cost=0.00..411.62 rows=12,160 width=0) (actual time=2.199..2.199 rows=12,149 loops=1)

  • Index Cond: ((value_class)::text = 'Open'::text)
14. 3,014.508 3,014.508 ↓ 0.0 0 475,975 / 3

Index Scan using item_pk on item item1_ (cost=0.43..0.92 rows=1 width=74) (actual time=0.019..0.019 rows=0 loops=475,975)

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

Index Scan using relation_target on relationship relationsh2_ (cost=0.42..0.61 rows=2 width=19) (actual time=0.015..0.015 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
16. 182.077 182.077 ↑ 1.0 1 68,279 / 3

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

  • Index Cond: ((id)::text = (relationsh2_.origin_id)::text)
17. 159.318 159.318 ↑ 1.0 1 68,279 / 3

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

  • Index Cond: ((id)::text = (item1_.created_by_id)::text)
18. 250.356 250.356 ↑ 1.0 1 68,279 / 3

Index Only Scan using field_value_pk on field_value fieldvalue6_ (cost=0.42..0.44 rows=1 width=10) (actual time=0.011..0.011 rows=1 loops=68,279)

  • Index Cond: (id = (artifact0_.category_fv)::text)
  • Heap Fetches: 0
Planning time : 24.003 ms
Execution time : 4,354.850 ms