explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T5ks

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 870.122 ↑ 1.0 15 1

Limit (cost=1,002.70..4,271.75 rows=15 width=132) (actual time=865.320..870.122 rows=15 loops=1)

2. 17.149 870.115 ↑ 61.7 15 1

Gather Merge (cost=1,002.70..202,593.90 rows=925 width=132) (actual time=865.319..870.115 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.017 852.966 ↑ 25.7 15 3 / 3

Nested Loop (cost=2.68..201,487.11 rows=385 width=132) (actual time=852.045..852.966 rows=15 loops=3)

4. 0.011 852.799 ↑ 25.7 15 3 / 3

Nested Loop (cost=2.26..201,309.08 rows=385 width=137) (actual time=852.024..852.799 rows=15 loops=3)

5. 0.008 852.683 ↑ 25.7 15 3 / 3

Nested Loop (cost=1.98..201,180.69 rows=385 width=122) (actual time=852.009..852.683 rows=15 loops=3)

6. 0.007 852.555 ↑ 25.7 15 3 / 3

Nested Loop (cost=1.69..201,063.39 rows=385 width=107) (actual time=851.983..852.555 rows=15 loops=3)

7. 16.656 852.293 ↑ 26.9 15 3 / 3

Nested Loop (cost=1.27..200,807.72 rows=404 width=108) (actual time=851.939..852.293 rows=15 loops=3)

8. 13.061 410.256 ↓ 2.9 30,384 3 / 3

Nested Loop Semi Join (cost=0.84..191,884.43 rows=10,426 width=35) (actual time=0.178..410.256 rows=30,384 loops=3)

  • Join Filter: ((fieldvalue5_.value_class)::text = ('Open'::text))
  • Rows Removed by Join Filter: 410
9. 5.025 397.195 ↑ 6.5 30,794 3 / 3

Nested Loop (cost=0.84..185,415.89 rows=199,032 width=35) (actual time=0.164..397.195 rows=30,794 loops=3)

10. 22.638 22.638 ↑ 6.5 30,794 3 / 3

Parallel Index Scan using artifact_priority on artifact artifact0_ (cost=0.42..93,380.39 rows=199,032 width=34) (actual time=0.047..22.638 rows=30,794 loops=3)

11. 369.532 369.532 ↑ 1.0 1 92,383 / 3

Index Scan using field_value_pk on field_value fieldvalue5_ (cost=0.42..0.46 rows=1 width=21) (actual time=0.012..0.012 rows=1 loops=92,383)

  • Index Cond: ((id)::text = (artifact0_.status_fv)::text)
12. 0.000 0.000 ↑ 1.0 1 92,383 / 3

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=92,383)

13. 425.381 425.381 ↓ 0.0 0 91,153 / 3

Index Scan using item_pk on item item1_ (cost=0.43..0.86 rows=1 width=73) (actual time=0.014..0.014 rows=0 loops=91,153)

  • Index Cond: ((id)::text = (artifact0_.id)::text)
  • Filter: ((NOT is_deleted) AND ((folder_id)::text = 'tracker5673'::text))
  • Rows Removed by Filter: 1
14. 0.255 0.255 ↑ 2.0 1 45 / 3

Index Scan using relation_target on relationship relationsh2_ (cost=0.42..0.61 rows=2 width=19) (actual time=0.016..0.017 rows=1 loops=45)

  • Index Cond: ((target_id)::text = (artifact0_.id)::text)
  • Filter: ((NOT is_deleted) AND ((relationship_type_name)::text = 'ArtifactAssignment'::text))
  • Rows Removed by Filter: 1
15. 0.120 0.120 ↑ 1.0 1 45 / 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=45)

  • Index Cond: ((id)::text = (relationsh2_.origin_id)::text)
16. 0.105 0.105 ↑ 1.0 1 45 / 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=45)

  • Index Cond: ((id)::text = (item1_.created_by_id)::text)
17. 0.150 0.150 ↑ 1.0 1 45 / 3

Index Scan using field_value_pk on field_value fieldvalue6_ (cost=0.42..0.46 rows=1 width=15) (actual time=0.010..0.010 rows=1 loops=45)

  • Index Cond: ((id)::text = (artifact0_.category_fv)::text)
Planning time : 26.760 ms
Execution time : 870.264 ms