explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YErC

Settings
# exclusive inclusive rows x rows loops node
1. 0.494 2,524.867 ↓ 1.9 56 1

Nested Loop Semi Join (cost=505,509.67..945,438.33 rows=29 width=4) (actual time=2,174.708..2,524.867 rows=56 loops=1)

  • Join Filter: (x0.keymiindustrytree = x0_2.keymiindustrytree)
  • Rows Removed by Join Filter: 3240
2. 0.000 2,043.157 ↓ 48.5 3,296 1

Gather (cost=504,509.67..750,611.46 rows=68 width=6) (actual time=1,692.337..2,043.157 rows=3,296 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 222.110 2,316.071 ↓ 39.2 1,099 3

Hash Join (cost=503,509.67..749,604.66 rows=28 width=6) (actual time=1,689.859..2,316.071 rows=1,099 loops=3)

  • Hash Cond: (x0.keyinstn = x0_1.keyinstn)
4. 548.525 548.525 ↑ 1.1 2,861,760 3

Parallel Seq Scan on instnmiindustry x0 (cost=0.00..180,899.25 rows=3,259,773 width=6) (actual time=0.009..548.525 rows=2,861,760 loops=3)

  • Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0))
  • Rows Removed by Filter: 1273046
5. 0.628 1,545.436 ↓ 20.0 3,187 3

Hash (cost=503,507.68..503,507.68 rows=159 width=4) (actual time=1,545.436..1,545.436 rows=3,187 loops=3)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 145kB
6. 1,544.808 1,544.808 ↓ 20.0 3,187 3

Seq Scan on panjivacompany x0_1 (cost=0.00..503,507.68 rows=159 width=4) (actual time=0.016..1,544.808 rows=3,187 loops=3)

  • Filter: (industrybenchmark AND (updoperation < 2) AND (keyinstn <> 4008251))
  • Rows Removed by Filter: 9989925
7. 0.000 481.216 ↑ 6.0 1 3,296

Materialize (cost=1,000.00..194,821.26 rows=6 width=2) (actual time=0.028..0.146 rows=1 loops=3,296)

8. 2.330 482.337 ↑ 6.0 1 1

Gather (cost=1,000.00..194,821.23 rows=6 width=2) (actual time=90.914..482.337 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 480.007 480.007 ↓ 0.0 0 3

Parallel Seq Scan on instnmiindustry x0_2 (cost=0.00..193,820.62 rows=2 width=2) (actual time=349.563..480.007 rows=0 loops=3)

  • Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0) AND (keyinstn = 4008251))
  • Rows Removed by Filter: 4134806
Planning time : 0.238 ms