explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pZaGY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,057.630 ↑ 1.0 15 1

Limit (cost=43,521.12..43,522.87 rows=15 width=149) (actual time=3,052.942..3,057.630 rows=15 loops=1)

2. 21.643 3,057.623 ↑ 97.3 15 1

Gather Merge (cost=43,521.12..43,691.46 rows=1,460 width=149) (actual time=3,052.941..3,057.623 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 11.627 3,035.980 ↑ 66.4 11 3 / 3

Sort (cost=42,521.09..42,522.92 rows=730 width=149) (actual time=3,035.980..3,035.980 rows=11 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. 171.133 3,024.353 ↓ 31.2 22,760 3 / 3

Nested Loop (cost=2,586.12..42,503.18 rows=730 width=149) (actual time=18.389..3,024.353 rows=22,760 loops=3)

5. 171.723 2,853.220 ↓ 31.2 22,760 3 / 3

Nested Loop (cost=2,585.84..42,257.67 rows=730 width=102) (actual time=18.297..2,853.220 rows=22,760 loops=3)

6. 231.438 2,681.497 ↓ 31.2 22,760 3 / 3

Nested Loop (cost=2,585.56..42,035.27 rows=730 width=87) (actual time=18.225..2,681.497 rows=22,760 loops=3)

7. 302.245 2,450.059 ↓ 31.2 22,760 3 / 3

Nested Loop (cost=2,585.14..41,711.68 rows=730 width=97) (actual time=16.748..2,450.059 rows=22,760 loops=3)

8. 2,024.024 2,147.814 ↓ 29.9 22,760 3 / 3

Nested Loop (cost=2,584.72..41,229.28 rows=762 width=98) (actual time=16.665..2,147.814 rows=22,760 loops=3)

9. 50.624 123.790 ↓ 8.6 158,812 3 / 3

Parallel Hash Join (cost=2,584.29..25,011.09 rows=18,550 width=24) (actual time=8.653..123.790 rows=158,812 loops=3)

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

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

11. 2.606 8.277 ↑ 1.7 4,050 3 / 3

Parallel Hash (cost=2,496.90..2,496.90 rows=6,991 width=10) (actual time=8.277..8.277 rows=4,050 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 736kB
12. 5.671 5.671 ↑ 1.7 4,050 3 / 3

Parallel Bitmap Heap Scan on field_value fieldvalue5_ (cost=288.52..2,496.90 rows=6,991 width=10) (actual time=0.911..5.671 rows=4,050 loops=3)

  • Recheck Cond: ((value_class)::text = 'Open'::text)
  • Heap Blocks: exact=590
  • -> Bitmap Index Scan on idx_tuning_value_valueclass (cost=0.00..285.55
13. 0.000 2.335 ↓ 0.0 12,149 1

rows=11884 width=0) (cost=0..0 rows=0 width=0) (actual time=2.335..2.335 rows=12,149 loops=1)

  • Index Cond: ((value_class)::text = 'Open'::text)
14. 5,717.244 5,717.244 ↓ 0.0 0 476,437

Index Scan using idx_tuning_3_artifact on item item1_ (cost=0.43..0.87 rows=1 width=74) (actual time=0.012..0.012 rows=0 loops=476,437)

  • Index Cond: (((folder_id)::text = 'tracker5673'::text) AND (is_deleted = false) AND ((id)::text = (artifact0_.id)::text))
  • Filter: (NOT is_deleted)
15. 887.627 887.627 ↑ 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.012..0.013 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. 682.790 682.790 ↑ 1.0 1 68,279

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

  • Index Cond: (id = (artifact0_.category_fv)::text)
  • Heap Fetches: 0
17. 477.953 477.953 ↑ 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.007..0.007 rows=1 loops=68,279)

  • Index Cond: ((id)::text = (relationsh2_.origin_id)::text)
18. 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)
Planning time : 111.557 ms
Execution time : 3,058.134 ms