explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5mNf

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 10,876.185 ↑ 1.0 1 1

Finalize Aggregate (cost=895,514.59..895,514.60 rows=1 width=8) (actual time=10,876.184..10,876.185 rows=1 loops=1)

2. 96.820 10,970.119 ↓ 1.5 3 1

Gather (cost=895,514.38..895,514.59 rows=2 width=8) (actual time=10,876.118..10,970.119 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.137 10,873.299 ↑ 1.0 1 3

Partial Aggregate (cost=894,514.38..894,514.39 rows=1 width=8) (actual time=10,873.298..10,873.299 rows=1 loops=3)

4. 900.405 10,873.162 ↑ 540.4 281 3

Hash Left Join (cost=222.84..894,134.73 rows=151,858 width=0) (actual time=481.237..10,873.162 rows=281 loops=3)

  • Hash Cond: ((builds.status)::text = (build_states.buildstate)::text)
  • Filter: (((build_states.metastate)::text = 'running'::text) OR ((builds.status)::text = 'storing'::text))
  • Rows Removed by Filter: 1678575
5. 3,696.386 9,972.715 ↓ 1.9 1,678,856 3

Hash Join (cost=221.19..891,331.36 rows=880,755 width=10) (actual time=2.697..9,972.715 rows=1,678,856 loops=3)

  • Hash Cond: (builds.productid = products.productid)
6. 6,273.760 6,273.760 ↑ 1.2 7,403,116 3

Parallel Seq Scan on builds (cost=0.00..866,879.38 rows=9,226,175 width=14) (actual time=0.018..6,273.760 rows=7,403,116 loops=3)

  • Filter: ((site)::text = 'sjc31'::text)
  • Rows Removed by Filter: 1997528
7. 0.406 2.569 ↑ 1.0 789 3

Hash (cost=211.06..211.06 rows=810 width=4) (actual time=2.568..2.569 rows=789 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
8. 2.163 2.163 ↑ 1.0 789 3

Seq Scan on products (cost=0.00..211.06 rows=810 width=4) (actual time=0.060..2.163 rows=789 loops=3)

  • Filter: ((name)::text ~~ 'nsx-%'::text)
  • Rows Removed by Filter: 7699
9. 0.021 0.042 ↑ 1.0 29 3

Hash (cost=1.29..1.29 rows=29 width=19) (actual time=0.041..0.042 rows=29 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.021 0.021 ↑ 1.0 29 3

Seq Scan on build_states (cost=0.00..1.29 rows=29 width=19) (actual time=0.009..0.021 rows=29 loops=3)