explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oXc4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,657.480 ↓ 48.3 68,279 1

Gather Merge (cost=44,758.08..44,923.06 rows=1,414 width=132) (actual time=2,618.341..2,657.480 rows=68,279 loops=1)

  • Workers Planned: 2l_6_0_,
  • Workers Launched: 2 col_7_0_,
  • rows=157625 loops=3)1_.id
2. 45.186 7,831.293 ↓ 32.2 22,760 3

Sort (cost=43,758.05..43,759.82 rows=707 width=132) (actual time=2,607.437..2,610.431 rows=22,760 loops=3)

  • Sort Key: artifact0_.priority
  • Sort Method: quicksort Memory: 4517kB
  • Worker 0: Sort Method: quicksort Memory: 3772kB
  • Worker 1: Sort Method: quicksort Memory: 4211kB
3. 23.814 7,786.107 ↓ 32.2 22,760 3

Nested Loop (cost=2,872.14..43,724.59 rows=707 width=132) (actual time=9.040..2,595.369 rows=22,760 loops=3)

4. 38.013 7,147.782 ↓ 32.2 22,760 3

Nested Loop (cost=2,871.72..43,397.66 rows=707 width=137) (actual time=8.962..2,382.594 rows=22,760 loops=3)

5. 581.536 6,700.095 ↓ 32.2 22,760 3

Nested Loop (cost=2,871.44..43,161.90 rows=707 width=122) (actual time=8.932..2,233.365 rows=22,760 loops=3)

  • -> Nested Loop (cost=2871.16..42946.50 rows=707 width=107) (actual time=8.872..2080.540 rows=22760 loops=3)CROSS JOIN sfuser jpauser4_
  • -> Nested Loop (cost=2870.73..42478.19 rows=740 width=108) (actual time=8.794..1806.940 rows=22760 loops=3)JOIN field_value fieldvalue6_
  • -> Parallel Hash Join (cost=2870.31..26125.10 rows=19107 width=35) (actual time=6.070..110.871
  • Hash Cond: ((artifact0_.status_fv)::text = (fieldvalue5_.id)::text)
  • -> Parallel Hash (cost=2780.29..2780.29 rows=7201 width=21) (actual time=5.521..5.522 rows=4050 loops=3)_.target_id = item1_.id
6. 151.623 160.797 ↑ 1.3 159,225 3

Parallel Seq Scan on artifact artifact0_ (cost=0.00..22,732.32 rows=199,032 width=34) (actual time=0.128..53.599 rows=159,225 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 864kB
7. 7.524 9.174 ↑ 1.8 4,050 3

Parallel Bitmap Heap Scan on field_value fieldvalue5_ (cost=407.29..2,780.29 rows=7,201 width=21) (actual time=0.664..3.058 rows=4,050 loops=3)

  • Recheck Cond: ((value_class)::text = 'Open'::text)
  • Heap Blocks: exact=657
8. 1.650 1.650 ↑ 1.0 12,149 1

Bitmap Index Scan on idx_tuning_hash (cost=0.00..404.23 rows=12,241 width=0) (actual time=1.650..1.650 rows=12,149 loops=1)

  • Index Cond: ((value_class)::text = 'Open'::text)
9. 4,728.740 4,728.740 ↓ 0.0 0 472,874

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
10. 819.348 819.348 ↑ 2.0 1 68,279

Index Scan using relation_target on relationship relationsh2_ (cost=0.42..0.61 rows=2 width=19) (actual time=0.011..0.012 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
11. 409.674 409.674 ↑ 1.0 1 68,279

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)
12. 409.674 409.674 ↑ 1.0 1 68,279

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)
13. 614.511 614.511 ↑ 1.0 1 68,279

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)