explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9z3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,378.880 ↓ 1.9 56 1

Nested Loop Semi Join (cost=236,938.83..680,942.41 rows=29 width=4) (actual time=1,038.144..1,378.880 rows=56 loops=1)

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

Gather (cost=235,938.83..486,115.45 rows=69 width=6) (actual time=570.329..911.650 rows=3,296 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 222.744 1,178.361 ↓ 37.9 1,099 3

Hash Join (cost=234,938.83..485,108.55 rows=29 width=6) (actual time=569.366..1,178.361 rows=1,099 loops=3)

  • Hash Cond: (x0.keyinstn = x0_1.keyinstn)
4. 532.666 532.666 ↑ 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.006..532.666 rows=2,861,760 loops=3)

  • Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0))
  • Rows Removed by Filter: 1273046
5. 0.519 422.951 ↓ 19.6 3,187 3

Hash (cost=234,936.79..234,936.79 rows=163 width=4) (actual time=422.951..422.951 rows=3,187 loops=3)

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

Index Scan using ix_panjivacompany_sudeep on panjivacompany x0_1 (cost=0.43..234,936.79 rows=163 width=4) (actual time=0.026..422.432 rows=3,187 loops=3)

  • Index Cond: (industrybenchmark = true)
  • Filter: (industrybenchmark AND (updoperation < 2) AND (keyinstn <> 4008251))
  • Rows Removed by Filter: 1
7. 0.209 468.032 ↑ 6.0 1 3,296

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

8. 2.365 467.823 ↑ 6.0 1 1

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

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

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

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