explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oyoO

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,053.021 ↑ 1.0 15 1

Limit (cost=43,500.78..43,502.53 rows=15 width=47) (actual time=2,046.990..2,053.021 rows=15 loops=1)

2. 15.957 2,053.015 ↑ 101.9 15 1

Gather Merge (cost=43,500.78..43,679.06 rows=1,528 width=47) (actual time=2,046.987..2,053.015 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 8.592 2,037.058 ↑ 58.8 13 3 / 3

Sort (cost=42,500.75..42,502.66 rows=764 width=47) (actual time=2,037.057..2,037.058 rows=13 loops=3)

  • Sort Key: a.priority, (to_number("substring"((i.id)::text, 5), '999999999999999999999999999'::text))
  • Sort Method: top-N heapsort Memory: 27kB
  • Worker 0: Sort Method: top-N heapsort Memory: 27kB
  • Worker 1: Sort Method: top-N heapsort Memory: 26kB
4. 17.068 2,028.466 ↓ 29.8 22,760 3 / 3

Nested Loop (cost=2,870.73..42,482.01 rows=764 width=47) (actual time=7.339..2,028.466 rows=22,760 loops=3)

5. 56.991 119.902 ↓ 8.2 157,625 3 / 3

Parallel Hash Join (cost=2,870.31..26,125.10 rows=19,107 width=25) (actual time=5.701..119.902 rows=157,625 loops=3)

  • Hash Cond: ((a.status_fv)::text = (f.id)::text)
6. 57.655 57.655 ↑ 1.3 159,225 3 / 3

Parallel Seq Scan on artifact a (cost=0.00..22,732.32 rows=199,032 width=24) (actual time=0.105..57.655 rows=159,225 loops=3)

7. 2.243 5.256 ↑ 1.8 4,050 3 / 3

Parallel Hash (cost=2,780.29..2,780.29 rows=7,201 width=21) (actual time=5.256..5.256 rows=4,050 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 864kB
8. 2.460 3.013 ↑ 1.8 4,050 3 / 3

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

  • Recheck Cond: ((value_class)::text = 'Open'::text)
  • Heap Blocks: exact=657
9. 0.553 0.553 ↑ 1.0 12,149 1 / 3

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

  • Index Cond: ((value_class)::text = 'Open'::text)
10. 1,891.496 1,891.496 ↓ 0.0 0 472,874 / 3

Index Scan using item_pk on item i (cost=0.43..0.86 rows=1 width=10) (actual time=0.012..0.012 rows=0 loops=472,874)

  • Index Cond: ((id)::text = (a.id)::text)
  • Filter: ((NOT is_deleted) AND ((folder_id)::text = 'tracker5673'::text))
  • Rows Removed by Filter: 1
Planning time : 19.967 ms
Execution time : 2,053.137 ms