explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qiSR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9.258 ↑ 4.5 138 1

Nested Loop (cost=1,047.80..44,407.41 rows=626 width=4) (actual time=0.716..9.258 rows=138 loops=1)

  • Join Filter: (x0.keymiindustrytree = x0_2.keymiindustrytree)
  • Rows Removed by Join Filter: 3118
2. 2.712 9.357 ↓ 3.2 3,256 1

Gather (cost=1,047.37..44,290.28 rows=1,015 width=6) (actual time=0.702..9.357 rows=3,256 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.911 6.645 ↓ 2.7 1,628 2 / 2

Nested Loop (cost=47.37..43,188.78 rows=597 width=6) (actual time=0.227..6.645 rows=1,628 loops=2)

4. 0.846 1.006 ↓ 1.1 1,576 2 / 2

Parallel Bitmap Heap Scan on panjivacompany x0_1 (cost=46.93..9,001.28 rows=1,404 width=4) (actual time=0.211..1.006 rows=1,576 loops=2)

  • Recheck Cond: (updoperation < 2)
  • Filter: industrybenchmark
  • Heap Blocks: exact=320
5. 0.160 0.160 ↓ 1.4 3,234 1 / 2

Bitmap Index Scan on ai_panjivacompany_27645 (cost=0.00..46.34 rows=2,387 width=0) (actual time=0.320..0.320 rows=3,234 loops=1)

  • Index Cond: (industrybenchmark = true)
6. 4.728 4.728 ↑ 6.0 1 3,152 / 2

Index Scan using ai_instnmiindustry_27402 on instnmiindustry x0 (cost=0.43..24.29 rows=6 width=6) (actual time=0.003..0.003 rows=1 loops=3,152)

  • Index Cond: ((keyindustryrelationshiplevel = 0) AND (keyinstn = x0_1.keyinstn))
  • Filter: (updoperation < 2)
7. 0.000 0.000 ↑ 6.0 1 3,256

Materialize (cost=0.43..25.80 rows=6 width=2) (actual time=0.000..0.000 rows=1 loops=3,256)

8. 0.010 0.010 ↑ 6.0 1 1

Index Scan using ai_instnmiindustry_27402 on instnmiindustry x0_2 (cost=0.43..25.77 rows=6 width=2) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((keyindustryrelationshiplevel = 0) AND (keyinstn = 114523))
  • Filter: (updoperation < 2)